[ADMIN] postgres make fails with java option

2004-10-26 Thread Rob Long
Trying to configure --with-java but make is failing with: (see below for other details) Any ideas? Thanks, Rob -->./configure --enable-shared --with-maxbackend-connections=256 --with-perl --with-java -->make . . . make[3]: Entering directory `/home/postgres/postgresql-7.4.5/src/interfaces/jdbc

[ADMIN] best way to revert back to 7.3.3?

2004-09-28 Thread Rob Long
Need a hand. Was running 7.3.3 with several databases on a windows/cygwin platform. Recently downloaded/installed 7.4.5-1 from cygwin.com without first dumping my 7.3.3 databases needed for the upgrade. Have to go back to 7.3.3 and dump the databases. Tried installing 7.3.3 from source, conf

[ADMIN] pg_restore fails postgres 7.3.4

2003-10-03 Thread Rob Long
Trying to dump and restore a production database with no success. pg_dump database using the following: pg_dump -v -b -C -Fc -U postgres -f servdb.tar.gz servdb pg_restore with with following: pg_restore -v -C -D template1 -Fc -U postgres servdb.tar.gz restore fails with: pg_restore: [archi

Re: [ADMIN] pg_restore fails - postgres 7.3.4

2003-10-03 Thread Rob Long
Tom, Will this be fixed in 7.4? Thanks for the support. Rob - Original Message - From: Tom Lane <[EMAIL PROTECTED]> Date: Thursday, October 2, 2003 6:28 pm Subject: Re: [ADMIN] pg_restore fails - postgres 7.3.4 > "Rob Long" <[EMAIL PROTECTED]> writes: > &g

Re: [ADMIN] pg_restore fails - postgres 7.3.4

2003-10-02 Thread Rob Long
Attached. The previously posted index failure stated: CREATE INDEX idx_disc_loc ON order_items USING gist (disc, loc); However in this list it is: CREATE INDEX idx_item_loc ON content_items USING gist (disclosuer, loc); Rob Tom Lane wrote: > "Rob Long" <[EMAIL PROTECTED]>

[ADMIN] pg_restore fails - postgres 7.3.4

2003-10-02 Thread Rob Long
Trying to dump and restore a production database with no success. pg_dump database using the following: pg_dump -v -b -C -Fc -U postgres -f servdb.tar.gz servdb pg_restore with with following: pg_restore -v -C -D template1 -Fc -U postgres servdb.tar.gz restore fails with: pg_restore: [archi