Re: [ADMIN] Having problem with postgresql configuration (template1 doesn't
Tom Lane escreveu:
Vinicius <[EMAIL PROTECTED]> writes:
I tryed to create another data dir because I don't have the template1
database.
I think you got bit by one of the early-FC3 selinux policy bugs; see
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=142607
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=143208
You probably want to rm -rf /var/lib/pgsql/data/ and try again
after making sure (a) you have the latest postgres and selinux
packages and (b) you've done restorecon on /var/lib/pgsql and
/var/log/pgsql.
regards, tom lane
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
I did do "rm -fr /var/lib/pgsql/data/"
(a) I have the lastest *stable postgres package* from Fedora Core 3;
(b) I did do restorecon on "/var/lib/pgsql" and on "/var/log/pgsql".
now it pass the "...creating template1 database in
/var/lib/pgsql/data/base/1... ok" but stop at
"...
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
*creating information schema...*
initdb: failed"
/var/log/messages shows:
"...
Feb 21 09:10:43 ronin kernel: audit(1108987843.094:0): avc: denied {
read } for pid=6766 exe=/usr/bin/postgres path=/tmp/sh-thd-1108997049
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file
Feb 21 09:10:43 ronin kernel: audit(1108987843.423:0): avc: denied {
read } for pid=6767 exe=/usr/bin/postgres path=/tmp/sh-thd-1108980215
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file
Feb 21 09:10:43 ronin kernel: audit(1108987843.480:0): avc: denied {
read } for pid=6768 exe=/usr/bin/postgres path=/tmp/sh-thd-1109000142
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file
Feb 21 09:10:43 ronin kernel: audit(1108987843.542:0): avc: denied {
read } for pid=6769 exe=/usr/bin/postgres path=/tmp/sh-thd-1108983044
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file"
I think "/usr/bin/postgres" was tried to write to a file in "/tmp" and
was denied.
And I still don't get the template1 database.
Thanks.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Re: [ADMIN] Having problem with postgresql configuration (template1 doesn't
Vinicius escreveu:
Tom Lane escreveu:
Vinicius <[EMAIL PROTECTED]> writes:
I tryed to create another data dir because I don't have the template1
database.
I think you got bit by one of the early-FC3 selinux policy bugs; see
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=142607
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=143208
You probably want to rm -rf /var/lib/pgsql/data/ and try again
after making sure (a) you have the latest postgres and selinux
packages and (b) you've done restorecon on /var/lib/pgsql and
/var/log/pgsql.
regards, tom lane
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
I did do "rm -fr /var/lib/pgsql/data/"
(a) I have the lastest *stable postgres package* from Fedora Core 3;
(b) I did do restorecon on "/var/lib/pgsql" and on "/var/log/pgsql".
now it pass the "...creating template1 database in
/var/lib/pgsql/data/base/1... ok" but stop at
"...
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
*creating information schema...*
initdb: failed"
/var/log/messages shows:
"...
Feb 21 09:10:43 ronin kernel: audit(1108987843.094:0): avc: denied {
read } for pid=6766 exe=/usr/bin/postgres path=/tmp/sh-thd-1108997049
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file
Feb 21 09:10:43 ronin kernel: audit(1108987843.423:0): avc: denied {
read } for pid=6767 exe=/usr/bin/postgres path=/tmp/sh-thd-1108980215
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file
Feb 21 09:10:43 ronin kernel: audit(1108987843.480:0): avc: denied {
read } for pid=6768 exe=/usr/bin/postgres path=/tmp/sh-thd-1109000142
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file
Feb 21 09:10:43 ronin kernel: audit(1108987843.542:0): avc: denied {
read } for pid=6769 exe=/usr/bin/postgres path=/tmp/sh-thd-1108983044
(deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
tcontext=user_u:object_r:tmp_t tclass=file"
I think "/usr/bin/postgres" was tried to write to a file in "/tmp" and
was denied.
And I still don't get the template1 database.
Thanks.
I think it tried to read instead to write.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Re: [ADMIN] Having problem with postgresql configuration (template1 doesn't
Vinicius escreveu: And I still don't get the template1 database. Thanks. I think the server must be running to create the template1 database. I'm a newbie, sorry. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[ADMIN] Having problem with functions/operators/aggregates
Hi All, Have just installed a linux (red hat 9) version of postgreSQL (7.4.2) and for some reason the database has no functions/operators/aggregates that I have on a Windows BETA4 version. Are these seperate installations or are they supposed to be standard with the general installation. Regards, Kevin --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.859 / Virus Database: 585 - Release Date: 2005/02/14 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users
This Error message was given when i was dropping the database. There are idle connections to the database as seen from ps -ef | grep postgres How can i drop the database with out restarting the postgres server.?. FYI: i am dropping the database to perform restoration of this backup database using psql from production. -- Best, Gourish Singbal ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [ADMIN] ERROR: 40P01:
The DETAIL part is:- DETAIL: Process 17593 waits for AccessExclusiveLock on relation 1571110842 of database 917916301; blocked by process 17868. DETAIL: Process 25284 waits for AccessShareLock on relation 1613149934 of database 917916301; blocked by process 25010. the deadlock was from the application end. How can we release such locks?. regards gourish On Thu, 17 Feb 2005 08:51:38 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Thu, Feb 17, 2005 at 05:24:10PM +0530, Gourish Singbal wrote: > > > I got the below ERROR in my log file. Where can i get more info no > > what exactly caused this ERROR and how to debug it?. > > > > 2005-02-17 02:23:09 ERROR: 40P01: deadlock detected > > 2005-02-17 02:23:09 ERROR: 25P02: current transaction is aborted, > > commands ignored until end of transaction block > > Application code must be failing somewhere -- aren't you seeing > those problems? Or do the applications not perform enough error > checking and reporting? > > On the server side, if you're running 7.3 or later then you could > use log_min_error_statement. See the "Run-time Configuration" > section in the "Server Run-time Environment" chapter of the > documentation, in particular "Error Reporting and Logging" (or > "Logging and Debugging," depending on the version). > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > -- Best, Gourish Singbal ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[ADMIN] pg_clog corrupt, can't start postgres
Hi, I need some help in bringing back this db please. The partition ran out of space from an import process. I cleared up the space and attempted to start the postgres service again, but it doesn't start and i get following in the message log. HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. LOG: checkpoint record is at 1B/27F23A6C LOG: redo record is at 1B/27751714; undo record is at 0/0; shutdown FALSE LOG: next transaction ID: 45279762; next OID: 43062083 LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 1B/27751714 PANIC: could not access status of transaction 45514755 DETAIL: could not read from file "/var/lib/pgsql/data/pg_clog/002B" at offset 106496: Success LOG: startup process (PID 23991) was terminated by signal 6 LOG: aborting startup due to startup process failure Postgres is 7.4.1 on this machine. I saw some previous posts on this subject and so far the solution seems to be initialize and restore databases from the dumps. I can live with some aborted transactions, if it's possible to recover somehow. $ psql psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? # ls -l pg_xlog/ total 131232 -rw---1 postgres postgres 16777216 Feb 19 13:30 001B0026 -rw---1 postgres postgres 16777216 Feb 19 13:34 001B0027 -rw---1 postgres postgres 16777216 Feb 19 13:44 001B0028 -rw---1 postgres postgres 16777216 Feb 19 13:15 001B0029 -rw---1 postgres postgres 16777216 Feb 19 13:12 001B002A -rw---1 postgres postgres 16777216 Feb 19 13:18 001B002B -rw---1 postgres postgres 16777216 Feb 19 13:26 001B002C -rw---1 postgres postgres 16777216 Feb 19 13:22 001B002D # ls -l pg_clog/ total 628 -rw---1 postgres postgres 262144 Feb 19 04:31 0029 -rw---1 postgres postgres 262144 Feb 19 11:55 002A -rw---1 postgres postgres 106496 Feb 20 22:34 002B Thanks, Anjan ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] Having problem with postgresql configuration (template1 doesn't
Vinicius <[EMAIL PROTECTED]> writes:
> /var/log/messages shows:
> "...
> Feb 21 09:10:43 ronin kernel: audit(1108987843.094:0): avc: denied {
> read } for pid=6766 exe=/usr/bin/postgres path=/tmp/sh-thd-1108997049
> (deleted) dev=dm-0 ino=1046660 scontext=user_u:system_r:postgresql_t
> tcontext=user_u:object_r:tmp_t tclass=file
> And I still don't get the template1 database.
Sigh. I coulda sworn I tested this in December, but it's definitely
busted now:
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=149237
(I might have messed up by only testing PG 8.0 --- 8.0 does not have
this problem, since initdb is no longer a shell script.)
The short-term workaround is to temporarily disable selinux
(sudo /usr/sbin/setenforce 0) while you initialize the database.
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Re: [ADMIN] pg_clog corrupt, can't start postgres
"Anjan Dave" <[EMAIL PROTECTED]> writes: > The partition ran out of space from an import process. I cleared up the space > and attempted to start the postgres service again, but it doesn't start and i > get following in the message log. > PANIC: could not access status of transaction 45514755 > DETAIL: could not read from file "/var/lib/pgsql/data/pg_clog/002B" at > offset 106496: Success > LOG: startup process (PID 23991) was terminated by signal 6 > LOG: aborting startup due to startup process failure > Postgres is 7.4.1 on this machine. > I saw some previous posts on this subject and so far the solution seems to be > initialize and restore databases from the dumps. Before that, try updating to 7.4.7 (or at least 7.4.2) --- this looks like the same bug fixed here: 2004-01-26 14:16 tgl * src/backend/access/transam/varsup.c (REL7_4_STABLE): Repair incorrect order of operations in GetNewTransactionId(). We must complete ExtendCLOG() before advancing nextXid, so that if that routine fails, the next incoming transaction will try it again. Per trouble report from Christopher Kings-Lynne. You might also go back to the mail list archives from that time and see what advice was given to Chris about getting out of the problem he found himself in. I *think* that something along the line of forcibly appending a page of zeroes to that clog file might be the best solution, but this was more than a year ago and I don't recall for sure. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] pg_clog corrupt, can't start postgres
Tom, You're the man! I zeroed out the troubled pg_clog file and the db started up fine! Here's the link to the discussion, and a detailed explanation of the issue by Tom: http://groups-beta.google.com/group/comp.databases.postgresql.hackers/browse_thread/thread/c97c853f640b9ac1/d6bc3c75eed6c2a4?q=could+not+access+status+of+transaction#d6bc3c75eed6c2a4 Tom, is the issue resolved after 7.4.1? Thanks, Anjan -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Mon 2/21/2005 11:42 AM To: Anjan Dave Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_clog corrupt, can't start postgres "Anjan Dave" <[EMAIL PROTECTED]> writes: > The partition ran out of space from an import process. I cleared up the space and attempted to start the postgres service again, but it doesn't start and i get following in the message log. > PANIC: could not access status of transaction 45514755 > DETAIL: could not read from file "/var/lib/pgsql/data/pg_clog/002B" at offset 106496: Success > LOG: startup process (PID 23991) was terminated by signal 6 > LOG: aborting startup due to startup process failure > Postgres is 7.4.1 on this machine. > I saw some previous posts on this subject and so far the solution seems to be initialize and restore databases from the dumps. Before that, try updating to 7.4.7 (or at least 7.4.2) --- this looks like the same bug fixed here: 2004-01-26 14:16 tgl * src/backend/access/transam/varsup.c (REL7_4_STABLE): Repair incorrect order of operations in GetNewTransactionId(). We must complete ExtendCLOG() before advancing nextXid, so that if that routine fails, the next incoming transaction will try it again. Per trouble report from Christopher Kings-Lynne. You might also go back to the mail list archives from that time and see what advice was given to Chris about getting out of the problem he found himself in. I *think* that something along the line of forcibly appending a page of zeroes to that clog file might be the best solution, but this was more than a year ago and I don't recall for sure. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend
[ADMIN] Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
Emergency: I have a 200+ million row zip code radius table that has recently gone haywire. I cannot access it and get the following error code ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error My environment. Postgresql 7.3.2 OS: Redhat Linux 7.2 Any ideas to fix this... Thanks. Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'
Re: [ADMIN] pg_clog corrupt, can't start postgres
"Anjan Dave" <[EMAIL PROTECTED]> writes: > Tom, is the issue resolved after 7.4.1? Yes, that's why I told you to update. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
Christopher Smith <[EMAIL PROTECTED]> writes: > ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error This is a hardware failure: your disk drive has dropped some sectors. I don't think you can do anything about it except go back to your last backup :-( Oh, and buy a new disk ASAP, before you lose any more data ... regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[ADMIN] 64 bit rpms for 7.4.7??
I've checked the mirrors and although there is a directory for x86 64 bit rpms, it's empty. Are there plans to build these any time soon? Anyone point me to the latest srpms for 7.4.? Thanks. -- Until later, Geoffrey ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] 64 bit rpms for 7.4.7??
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 21 Feb 2005, Geoffrey wrote: I've checked the mirrors and although there is a directory for x86 64 bit rpms, it's empty. Are there plans to build these any time soon? Yep there is(was), but we are not sure when we will build it... BTW, next week or so I'll have rhel3(or 4, haven't decided yet) on an Intel EM64T, so that we can build x86_64 RPMs faster. Anyone point me to the latest srpms for 7.4.? http://www.postgresql.org/ftp/binary/v7.4.7/srpms/redhat/rhel-es-3.0/ Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCGkyJtl86P3SPfQ4RAnFnAKC4K7TEOAz/yuInAqRPTp2mStAu8gCfUkcw MglYFFFBcDlgoEKdDrgf/LE= =gAsh -END PGP SIGNATURE- ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] 64 bit rpms for 7.4.7??
Devrim GUNDUZ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 21 Feb 2005, Geoffrey wrote: I've checked the mirrors and although there is a directory for x86 64 bit rpms, it's empty. Are there plans to build these any time soon? Yep there is(was), but we are not sure when we will build it... BTW, next week or so I'll have rhel3(or 4, haven't decided yet) on an Intel EM64T, so that we can build x86_64 RPMs faster. Anyone point me to the latest srpms for 7.4.? http://www.postgresql.org/ftp/binary/v7.4.7/srpms/redhat/rhel-es-3.0/ Can I build 64 bit from these, or do I need specific 64 bit srpms? -- Until later, Geoffrey ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] 64 bit rpms for 7.4.7??
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 21 Feb 2005, Geoffrey wrote: Anyone point me to the latest srpms for 7.4.? http://www.postgresql.org/ftp/binary/v7.4.7/srpms/redhat/rhel-es-3.0/ Can I build 64 bit from these, or do I need specific 64 bit srpms? AFAIK, you can rebuild them using this package. BTW, we have a mailing list for RPM issues: [EMAIL PROTECTED] See http://pgfoundry.org/mail/?group_id=148 for details. Regards, - -- Devrim GUNDUZ devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.tdmsoft.com http://www.gunduz.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFCGlM6tl86P3SPfQ4RApHQAKDHDXvjdYsMWmBV8GTZvI40oQiDWACcCHV5 mUyEWLMKzB3XyR0p9PPXzMI= =M8WD -END PGP SIGNATURE- ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] 64 bit rpms for 7.4.7??
Devrim GUNDUZ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 21 Feb 2005, Geoffrey wrote: Anyone point me to the latest srpms for 7.4.? http://www.postgresql.org/ftp/binary/v7.4.7/srpms/redhat/rhel-es-3.0/ Can I build 64 bit from these, or do I need specific 64 bit srpms? AFAIK, you can rebuild them using this package. BTW, we have a mailing list for RPM issues: [EMAIL PROTECTED] See http://pgfoundry.org/mail/?group_id=148 for details. Thanks. -- Until later, Geoffrey ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Emergency: ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output error
Tom, you are exactly CORRECT. One scsi down... crap! Thanks for the support and quick response! Tom Lane <[EMAIL PROTECTED]> wrote: Christopher Smith <[EMAIL PROTECTED]>writes:> ERROR: _mdfd_getrelnfd: cannot open relation TABLE_NAME: Input/output errorThis is a hardware failure: your disk drive has dropped some sectors.I don't think you can do anything about it except go back to your lastbackup :-(Oh, and buy a new disk ASAP, before you lose any more data ...regards, tom lane Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'
Re: [ADMIN] 64 bit rpms for 7.4.7??
Hi, I've checked the mirrors and although there is a directory for x86 64 bit rpms, it's empty. Are there plans to build these any time soon? I should have built them. Sorry it took so long. Everything was delayed because of some problems at work adn at home. I will try to catch up with the RPM building tomorrow! Sorry for all this.. Sander. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] 64 bit rpms for 7.4.7??
Hi again, I've checked the mirrors and although there is a directory for x86 64 bit rpms, it's empty. Are there plans to build these any time soon? I should have built them. Sorry it took so long. Everything was delayed because of some problems at work adn at home. I will try to catch up with the RPM building tomorrow! I couldn't sleep anyway, and I felt very guilty about letting everyone down... I had to make some patches to python.m4 and the specfile to make everything compile, and the resulting (S)RPMs are at http://opensource.nederland.net/PostgreSQL/. Devrim: can you put them on the official FTP site? Again my apologies for letting everyone wait so long Sander. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [ADMIN] 64 bit rpms for 7.4.7??
Sander Steffann wrote: Hi, I've checked the mirrors and although there is a directory for x86 64 bit rpms, it's empty. Are there plans to build these any time soon? I should have built them. Sorry it took so long. Everything was delayed because of some problems at work adn at home. I will try to catch up with the RPM building tomorrow! Not a problem. Absolutely no need for an apology. Thanks so much for all the effort. -- Until later, Geoffrey ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [ADMIN] 64 bit rpms for 7.4.7??
Sander Steffann wrote: Hi again, I've checked the mirrors and although there is a directory for x86 64 bit rpms, it's empty. Are there plans to build these any time soon? I should have built them. Sorry it took so long. Everything was delayed because of some problems at work adn at home. I will try to catch up with the RPM building tomorrow! I couldn't sleep anyway, and I felt very guilty about letting everyone down... I had to make some patches to python.m4 and the specfile to make everything compile, and the resulting (S)RPMs are at http://opensource.nederland.net/PostgreSQL/. Devrim: can you put them on the official FTP site? Again my apologies for letting everyone wait so long Sander. Thanks again, I am humbled by your efforts... -- Until later, Geoffrey ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
