postgresql-python-py stable port information

Info2: <<
Package: postgresql-python-py%type_pkg[python]
Version: 8.2.5
Revision: 1021
Distribution: (%type_pkg[python] = 23) 10.3, (%type_pkg[python] = 23) 10.4
Description: PostgreSQL Python tools
Type: python(2.3 2.4 2.5)
License: BSD
Maintainer: Benjamin Reed

Depends: <<
postgresql82-shlibs (>= %v-1021),
python%type_pkg[python],
python-mx-py%type_pkg[python],
readline5-shlibs
<<
BuildDepends: <<
postgresql82-dev (>= %v-1021),
python%type_pkg[python],
bison,
readline5,
system-openssl-dev
<<
Conflicts: <<
postgresql-python-py%type_pkg[python],
postgresql-ssl-python-py%type_pkg[python] (<< %v-%r),
postgresql-python,
postgresql-ssl-python
<<
Replaces: <<
postgresql-python-py%type_pkg[python],
postgresql-ssl-python-py%type_pkg[python] (<< %v-%r),
postgresql-python,
postgresql-ssl-python
<<

CustomMirror: <<
afr-ZA: ftp://ftp.za.postgresql.org/mirror/ftp.postgresql.org
asi-CN: ftp://ftp.cn.postgresql.org/ftp.postgresql.org
asi-GE: ftp://ftp.ge.postgresql.org/pub/postgresql
asi-HK: ftp://ftp.hk.postgresql.org/postgresql
asi-ID: ftp://ftp8.id.postgresql.org/pub/PostgreSQL
asi-ID: ftp://ftp9.id.postgresql.org/postgresql
asi-JP: ftp://ftp.jp.postgresql.org
asi-KR: ftp://ftp.kr.postgresql.org/mirror/database/postgresql
asi-TW: ftp://ftp.tw.postgresql.org/pub/postgresql
asi-TW: ftp://ftp3.tw.postgresql.org/pub/postgresql
asi-TW: ftp://ftp5.tw.postgresql.org/pub/Unix/Database/PostgreSQL
aus-AU: ftp://ftp.au.postgresql.org/pub/postgresql
aus-AU: ftp://ftp2.au.postgresql.org/pub/postgresql
aus-AU: ftp://ftp3.au.postgresql.org/pub/postgresql
aus-NZ: ftp://ftp.nz.postgresql.org/postgresql
eur-AT: ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub
eur-BE: ftp://ftp.be.postgresql.org/postgresql
eur-BA: ftp://ftp.ba.postgresql.org/pub/postgresql
eur-BG: ftp://ftp3.bg.postgresql.org/postgresql
eur-CH: ftp://ftp2.ch.postgresql.org/mirror/postgresql
eur-CZ: ftp://ftp.cz.postgresql.org/pub/ftp.postgresql.org
eur-CZ: ftp://ftp2.cz.postgresql.org/pub/postgresql
eur-DE: ftp://ftp.de.postgresql.org/mirror/postgresql
eur-DE: ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org
eur-DE: ftp://ftp7.de.postgresql.org/pub/ftp.postgresql.org
eur-DE: ftp://ftp8.de.postgresql.org/pub/misc/pgsql
eur-DE: ftp://ftp9.de.postgresql.org/unix/databases/postgresql
eur-DK: ftp://ftp.dk.postgresql.org/mirrors/postgresql
eur-EE: ftp://ftp.ee.postgresql.org/mirrors/postgresql
eur-ES: ftp://ftp5.es.postgresql.org/mirror/postgresql
eur-FR: ftp://ftp.fr.postgresql.org
eur-FR: ftp://ftp2.fr.postgresql.org/postgresql
eur-FR: ftp://ftp3.fr.postgresql.org/pub/postgresql
eur-GR: ftp://ftp.gr.postgresql.org/pub/databases/postgresql
eur-GR: ftp://ftp2.gr.postgresql.org/pub/databases/postgresql
eur-HR: ftp://ftp.hr.postgresql.org/postgresql
eur-HU: ftp://ftp3.hu.postgresql.org/pub/postgresql
eur-IE: ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub
eur-IE: ftp://ftp2.ie.postgresql.org/mirrors/ftp.postgresql.org
eur-IL: ftp://ftp.il.postgresql.org/ftp.postgresql.org
eur-IS: ftp://ftp.is.postgresql.org/pub/postgresql
eur-IT: ftp://ftp2.it.postgresql.org/mirrors/postgres
eur-IT: ftp://ftp6.it.postgresql.org/pub/PostgreSQL
eur-IT: ftp://ftp7.it.postgresql.org/pub/unix/postgres
eur-LV: ftp://ftp.lv.postgresql.org/pub/software/postgresql
eur-NL: ftp://ftp.eu.postgresql.org/pub/unix/db/postgresql
eur-NL: ftp://ftp.nl.postgresql.org:21/pub/mirror/postgresql
eur-NL: ftp://ftp2.nl.postgresql.org/mirror/postgresql
eur-NL: ftp://ftp4.nl.postgresql.org/postgresql.zeelandnet.nl
eur-NO: ftp://ftp.no.postgresql.org/pub/databases/postgresql
eur-PL: ftp://ftp6.pl.postgresql.org/pub/postgresql
eur-PL: ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org
eur-PL: ftp://ftp8.pl.postgresql.org/pub/postgresql
eur-PT: ftp://ftp.pt.postgresql.org/postgresql
eur-RO: ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org
eur-RU: ftp://ftp.ru.postgresql.org/pub/mirrors/pgsql
eur-RU: ftp://ftp2.ru.postgresql.org/pub/databases/postgresql
eur-RU: ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub
eur-RU: ftp://ftp6.ru.postgresql.org/pub/pgsql
eur-SE: ftp://ftp.se.postgresql.org/pub/database/relational/postgresql
eur-SK: ftp://ftp2.sk.postgresql.org/pub/postgresql
eur-UK: ftp://ftp2.uk.postgresql.org/sites/ftp.postgresql.org
eur-UK: ftp://ftp4.uk.postgresql.org/sites/ftp.postgresql.org
eur-UK: ftp://ftp8.uk.postgresql.org/sites/ftp.postgresql.org
nam-CA: ftp://ftp3.ca.postgresql.org/pub
nam-CA: ftp://ftp4.ca.postgresql.org/pub/postgresql
sam-BR: ftp://ftp.br.postgresql.org/pub/PostgreSQL
sam-CL: ftp://ftp.cl.postgresql.org/ftp/pub/postgresql
sam-CO: ftp://ftp.co.postgresql.org/pub/mirrors/postgresql
nam-US: ftp://ftp.us.postgresql.org/pub/mirrors/postgresql
nam-US: ftp://ftp3.us.postgresql.org/pub/postgresql
nam-US: ftp://ftp4.us.postgresql.org/pub/postgresql
nam-US: ftp://ftp5.us.postgresql.org/pub/PostgreSQL
nam-US: ftp://ftp8.us.postgresql.org/postgresql
nam-US: ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql
nam-US: ftp://ftp10.us.postgresql.org/pub/postgresql
nam-US: ftp://ftp22.us.postgresql.org/mirrors/ftp.postgresql.org
<<
Source: mirror:custom:source/v%v/postgresql-%v.tar.bz2
Source-MD5: bb1cd309ea72f070cb964736f5755847
Source2: ftp://ftp.druid.net/pub/distrib/PyGreSQL-3.8.1.tgz
Source2-MD5: 5575979dac93c9c5795d7693a8f91c86
PatchScript: sed -e 's|@INSTPREFIX@|%p|g' -e 's|python2.1|python%type_raw[python]|g' < %a/postgresql82.patch | patch -p1

SetCPPFLAGS: -DHAVE_OPTRESET -I%p/include/postgresql -I%p/include
SetLIBS: -L%p/lib
NoSetCPPFLAGS: true
NoSetLDFLAGS: true
ConfigureParams: --prefix=%p --with-docdir=%p/share/doc --mandir=%p/share/man --enable-multibyte --enable-recode --with-CXX --without-perl --with-python --with-openssl --with-libraries=%p/lib --with-includes=%p/include --without-tcl --without-java --enable-odbc --with-pam --with-rendezvous
CompileScript: <<
#!/bin/sh -ev

export lt_cv_sys_max_cmd_len=65536
export ac_cv_path_PYTHON=%p/bin/python%type_raw[python]
export CPPFLAGS="-I%p/lib/system-openssl/include -I%p/include -DHAVE_OPTRESET -fno-common"
export LDFLAGS="-L%p/lib/system-openssl/lib -L%p/lib"
./configure %c

pushd src/pl/plpython
make BE_DLLLIBS="-bundle_loader %p/bin/postgres"
popd

pushd ../PyGreSQL-3.8.1
python%type_raw[python] setup.py build
popd
<<

InstallScript: <<
#!/bin/sh -ev

pushd src/pl/plpython
make install DESTDIR=%d INSTALLSITEMAN3DIR=%i/share/man/man3
popd

pushd ../PyGreSQL-3.8.1
python%type_raw[python] setup.py install --root="%d"
install -d -m 755 %i/share/doc/%N
install -c -m 755 tutorial/* docs/*.txt %i/share/doc/%N/
popd

mv %i/lib/postgresql-8.2/plpython.so %i/lib/postgresql-8.2/plpython-%type_pkg[python].so
<<
DocFiles: COPYRIGHT HISTORY INSTALL README
SplitOff: <<
Package: postgresql-ssl-python-py%type_pkg[python]
Depends: postgresql-python-py%type_pkg[python] (>= %v-%r)
DocFiles: COPYRIGHT HISTORY INSTALL README
<<

PostInstScript: <<
update-alternatives --install %p/lib/postgresql-8.2/plpython.so postgresql-python-plpython.so %p/lib/postgresql-8.2/plpython-%type_pkg[python].so %type_pkg[python]
cat < *** WARNING ***

To be able to use this (plpython) in PostgreSQL, you will need to
start your database:

sudo %p/bin/pgsql.sh start

...and then run:

sudo -u postgres %p/bin/createlang plpythonu template1

*** WARNING ***
END
<<
PostRmScript: <<
update-alternatives --remove postgresql-python-plpython.so %p/lib/postgresql-8.2/plpython-%type_pkg[python].so
if [ ! -f %p/lib/postgresql-8.2/plpython.so ]; then
sudo -u postgres %p/bin/droplang plpython template1 >/dev/null 2>&1 || :
fi
<<

Homepage: http://www.postgresql.org/
DescDetail: <<
To be able to use this (plpython) in PostgreSQL, you will need to
start your database:

sudo %p/bin/pgsql.sh start

...and then run:

sudo -u postgres %p/bin/createlang plpythonu template1
<<
<<

postgresql-python-py stable port .patch

--- PyGreSQL-3.5/setup.py Sun Aug 29 20:12:24 2004
+++ PyGreSQL-3.5-new/setup.py Mon Oct 25 12:02:33 2004
@@ -36,8 +36,8 @@
optional_libs=[ 'libpqdll', 'wsock32', 'advapi32' ]
data_files = [ 'libpq.dll' ]
else:
- include_dirs=[getconfig ('includedir'),getconfig('includedir-server')]
- library_dirs=[getconfig('libdir')]
+ include_dirs=['@INSTPREFIX@/include/postgresql','@INSTPREFIX@/include',getconfig ('includedir'),getconfig('includedir-server')]
+ library_dirs=['@INSTPREFIX@/lib/postgresql-7.4', '@INSTPREFIX@/lib',getconfig('libdir')]
optional_libs=['pq']
data_files = []

postgresql-python-py _unstable_ port information

Info2: <<
Package: postgresql-python-py%type_pkg[python]
Version: 8.2.9
Revision: 1
Distribution: (%type_pkg[python] = 23) 10.3, (%type_pkg[python] = 23) 10.4
Description: PostgreSQL Python tools
Type: python(2.3 2.4 2.5)
License: BSD
Maintainer: Benjamin Reed

Depends: <<
postgresql82-shlibs (>= %v-1),
python%type_pkg[python],
python-mx-py%type_pkg[python],
readline5-shlibs
<<
BuildDepends: <<
postgresql82-dev (>= %v-1),
python%type_pkg[python],
bison,
readline5,
system-openssl-dev
<<
Conflicts: <<
postgresql-python-py%type_pkg[python],
postgresql-ssl-python-py%type_pkg[python] (<< %v-%r),
postgresql-python,
postgresql-ssl-python
<<
Replaces: <<
postgresql-python-py%type_pkg[python],
postgresql-ssl-python-py%type_pkg[python] (<< %v-%r),
postgresql-python,
postgresql-ssl-python
<<

CustomMirror: <<
afr-ZA: ftp://ftp.za.postgresql.org/mirror/ftp.postgresql.org
asi-CN: ftp://ftp.cn.postgresql.org/ftp.postgresql.org
asi-GE: ftp://ftp.ge.postgresql.org/pub/postgresql
asi-HK: ftp://ftp.hk.postgresql.org/postgresql
asi-ID: ftp://ftp8.id.postgresql.org/pub/PostgreSQL
asi-ID: ftp://ftp9.id.postgresql.org/postgresql
asi-JP: ftp://ftp.jp.postgresql.org
asi-KR: ftp://ftp.kr.postgresql.org/mirror/database/postgresql
asi-TW: ftp://ftp.tw.postgresql.org/pub/postgresql
asi-TW: ftp://ftp3.tw.postgresql.org/pub/postgresql
asi-TW: ftp://ftp5.tw.postgresql.org/pub/Unix/Database/PostgreSQL
aus-AU: ftp://ftp.au.postgresql.org/pub/postgresql
aus-AU: ftp://ftp2.au.postgresql.org/pub/postgresql
aus-AU: ftp://ftp3.au.postgresql.org/pub/postgresql
aus-NZ: ftp://ftp.nz.postgresql.org/postgresql
eur-AT: ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub
eur-BE: ftp://ftp.be.postgresql.org/postgresql
eur-BA: ftp://ftp.ba.postgresql.org/pub/postgresql
eur-BG: ftp://ftp3.bg.postgresql.org/postgresql
eur-CH: ftp://ftp2.ch.postgresql.org/mirror/postgresql
eur-CZ: ftp://ftp.cz.postgresql.org/pub/ftp.postgresql.org
eur-CZ: ftp://ftp2.cz.postgresql.org/pub/postgresql
eur-DE: ftp://ftp.de.postgresql.org/mirror/postgresql
eur-DE: ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org
eur-DE: ftp://ftp7.de.postgresql.org/pub/ftp.postgresql.org
eur-DE: ftp://ftp8.de.postgresql.org/pub/misc/pgsql
eur-DE: ftp://ftp9.de.postgresql.org/unix/databases/postgresql
eur-DK: ftp://ftp.dk.postgresql.org/mirrors/postgresql
eur-EE: ftp://ftp.ee.postgresql.org/mirrors/postgresql
eur-ES: ftp://ftp5.es.postgresql.org/mirror/postgresql
eur-FR: ftp://ftp.fr.postgresql.org
eur-FR: ftp://ftp2.fr.postgresql.org/postgresql
eur-FR: ftp://ftp3.fr.postgresql.org/pub/postgresql
eur-GR: ftp://ftp.gr.postgresql.org/pub/databases/postgresql
eur-GR: ftp://ftp2.gr.postgresql.org/pub/databases/postgresql
eur-HR: ftp://ftp.hr.postgresql.org/postgresql
eur-HU: ftp://ftp3.hu.postgresql.org/pub/postgresql
eur-IE: ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub
eur-IE: ftp://ftp2.ie.postgresql.org/mirrors/ftp.postgresql.org
eur-IL: ftp://ftp.il.postgresql.org/ftp.postgresql.org
eur-IS: ftp://ftp.is.postgresql.org/pub/postgresql
eur-IT: ftp://ftp2.it.postgresql.org/mirrors/postgres
eur-IT: ftp://ftp6.it.postgresql.org/pub/PostgreSQL
eur-IT: ftp://ftp7.it.postgresql.org/pub/unix/postgres
eur-LV: ftp://ftp.lv.postgresql.org/pub/software/postgresql
eur-NL: ftp://ftp.eu.postgresql.org/pub/unix/db/postgresql
eur-NL: ftp://ftp.nl.postgresql.org:21/pub/mirror/postgresql
eur-NL: ftp://ftp2.nl.postgresql.org/mirror/postgresql
eur-NL: ftp://ftp4.nl.postgresql.org/postgresql.zeelandnet.nl
eur-NO: ftp://ftp.no.postgresql.org/pub/databases/postgresql
eur-PL: ftp://ftp6.pl.postgresql.org/pub/postgresql
eur-PL: ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org
eur-PL: ftp://ftp8.pl.postgresql.org/pub/postgresql
eur-PT: ftp://ftp.pt.postgresql.org/postgresql
eur-RO: ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org
eur-RU: ftp://ftp.ru.postgresql.org/pub/mirrors/pgsql
eur-RU: ftp://ftp2.ru.postgresql.org/pub/databases/postgresql
eur-RU: ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub
eur-RU: ftp://ftp6.ru.postgresql.org/pub/pgsql
eur-SE: ftp://ftp.se.postgresql.org/pub/database/relational/postgresql
eur-SK: ftp://ftp2.sk.postgresql.org/pub/postgresql
eur-UK: ftp://ftp2.uk.postgresql.org/sites/ftp.postgresql.org
eur-UK: ftp://ftp4.uk.postgresql.org/sites/ftp.postgresql.org
eur-UK: ftp://ftp8.uk.postgresql.org/sites/ftp.postgresql.org
nam-CA: ftp://ftp3.ca.postgresql.org/pub
nam-CA: ftp://ftp4.ca.postgresql.org/pub/postgresql
sam-BR: ftp://ftp.br.postgresql.org/pub/PostgreSQL
sam-CL: ftp://ftp.cl.postgresql.org/ftp/pub/postgresql
sam-CO: ftp://ftp.co.postgresql.org/pub/mirrors/postgresql
nam-US: ftp://ftp.us.postgresql.org/pub/mirrors/postgresql
nam-US: ftp://ftp3.us.postgresql.org/pub/postgresql
nam-US: ftp://ftp4.us.postgresql.org/pub/postgresql
nam-US: ftp://ftp5.us.postgresql.org/pub/PostgreSQL
nam-US: ftp://ftp8.us.postgresql.org/postgresql
nam-US: ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql
nam-US: ftp://ftp10.us.postgresql.org/pub/postgresql
nam-US: ftp://ftp22.us.postgresql.org/mirrors/ftp.postgresql.org
<<
Source: mirror:custom:source/v%v/postgresql-%v.tar.bz2
Source-MD5: 579506cf91881f6ede67e3be98a47c37
Source2: ftp://ftp.druid.net/pub/distrib/PyGreSQL-3.8.1.tgz
Source2-MD5: 5575979dac93c9c5795d7693a8f91c86
PatchScript: sed -e 's|@INSTPREFIX@|%p|g' -e 's|python2.1|python%type_raw[python]|g' < %a/postgresql82.patch | patch -p1

SetCPPFLAGS: -DHAVE_OPTRESET -I%p/include/postgresql -I%p/include
SetLIBS: -L%p/lib
NoSetCPPFLAGS: true
NoSetLDFLAGS: true
ConfigureParams: --prefix=%p --with-docdir=%p/share/doc --mandir=%p/share/man --enable-multibyte --enable-recode --with-CXX --without-perl --with-python --with-openssl --with-libraries=%p/lib --with-includes=%p/include --without-tcl --without-java --enable-odbc --with-pam --with-rendezvous
CompileScript: <<
#!/bin/sh -ev

export lt_cv_sys_max_cmd_len=65536
export ac_cv_path_PYTHON=%p/bin/python%type_raw[python]
export CPPFLAGS="-I%p/lib/system-openssl/include -I%p/include -DHAVE_OPTRESET -fno-common"
export LDFLAGS="-L%p/lib/system-openssl/lib -L%p/lib"
./configure %c

pushd src/pl/plpython
make BE_DLLLIBS="-bundle_loader %p/bin/postgres"
popd

pushd ../PyGreSQL-3.8.1
python%type_raw[python] setup.py build
popd
<<

InstallScript: <<
#!/bin/sh -ev

pushd src/pl/plpython
make install DESTDIR=%d INSTALLSITEMAN3DIR=%i/share/man/man3
popd

pushd ../PyGreSQL-3.8.1
python%type_raw[python] setup.py install --root="%d"
install -d -m 755 %i/share/doc/%N
install -c -m 755 tutorial/* docs/*.txt %i/share/doc/%N/
popd

mv %i/lib/postgresql-8.2/plpython.so %i/lib/postgresql-8.2/plpython-%type_pkg[python].so
<<
DocFiles: COPYRIGHT HISTORY INSTALL README
SplitOff: <<
Package: postgresql-ssl-python-py%type_pkg[python]
Depends: postgresql-python-py%type_pkg[python] (>= %v-%r)
DocFiles: COPYRIGHT HISTORY INSTALL README
<<

PostInstScript: <<
update-alternatives --install %p/lib/postgresql-8.2/plpython.so postgresql-python-plpython.so %p/lib/postgresql-8.2/plpython-%type_pkg[python].so %type_pkg[python]
cat < *** WARNING ***

To be able to use this (plpython) in PostgreSQL, you will need to
start your database:

sudo %p/bin/pgsql.sh start

...and then run:

sudo -u postgres %p/bin/createlang plpythonu template1

*** WARNING ***
END
<<
PostRmScript: <<
update-alternatives --remove postgresql-python-plpython.so %p/lib/postgresql-8.2/plpython-%type_pkg[python].so
if [ ! -f %p/lib/postgresql-8.2/plpython.so ]; then
sudo -u postgres %p/bin/droplang plpython template1 >/dev/null 2>&1 || :
fi
<<

Homepage: http://www.postgresql.org/
DescDetail: <<
To be able to use this (plpython) in PostgreSQL, you will need to
start your database:

sudo %p/bin/pgsql.sh start

...and then run:

sudo -u postgres %p/bin/createlang plpythonu template1
<<
<<

postgresql-python-py _unstable_ port .patch

--- PyGreSQL-3.5/setup.py Sun Aug 29 20:12:24 2004
+++ PyGreSQL-3.5-new/setup.py Mon Oct 25 12:02:33 2004
@@ -36,8 +36,8 @@
optional_libs=[ 'libpqdll', 'wsock32', 'advapi32' ]
data_files = [ 'libpq.dll' ]
else:
- include_dirs=[getconfig ('includedir'),getconfig('includedir-server')]
- library_dirs=[getconfig('libdir')]
+ include_dirs=['@INSTPREFIX@/include/postgresql','@INSTPREFIX@/include',getconfig ('includedir'),getconfig('includedir-server')]
+ library_dirs=['@INSTPREFIX@/lib/postgresql-7.4', '@INSTPREFIX@/lib',getconfig('libdir')]
optional_libs=['pq']
data_files = []