Re: [ADMIN] pg_upgrade difficulties

2011-09-14 Thread Steve Crawford
On 09/14/2011 08:48 AM, Steve Crawford wrote: On 09/13/2011 05:31 PM, Tom Lane wrote: Steve Crawford writes: waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping There were problems executing "/usr/pgsql-9.1/bin/pg

Re: [ADMIN] pg_upgrade difficulties

2011-09-14 Thread Steve Crawford
On 09/13/2011 05:31 PM, Tom Lane wrote: Steve Crawford writes: waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping There were problems executing "/usr/pgsql-9.1/bin/pg_ctl" -w -l "upgrade.log" -D "/var/lib/pgsql/9.

Re: [ADMIN] pg_upgrade difficulties

2011-09-13 Thread Tom Lane
Steve Crawford writes: > waiting for server to start../usr/pgsql-9.1/bin/pg_ctl: symbol > lookup error: /usr/pgsql-9.1/bin/pg_ctl: undefined symbol: PQping > There were problems executing "/usr/pgsql-9.1/bin/pg_ctl" -w -l > "upgrade.log" -D "/var/lib/pgsql/9.1/data" -o "-p 5432 -b" start >>

[ADMIN] pg_upgrade difficulties

2011-09-13 Thread Steve Crawford
I am encountering multiple issues in my attempt to upgrade from PostgreSQL 9.0.4 to 9.1.0 on CentOS 5.6 i386. The latest working version is 9.0.4 installed from the http://yum.pgrpms.org/ site. After installing the 9.1 repo RPM and installing 9.1 via yum I set up a script to do pg_upgrade with