[GENERAL] Errors regarding transporting database using pg_dump

2009-10-05 Thread Chun-fan Ivan Liao
I want to transport the database server to a new machine. The OS and the PostgreSQL version of the old machine: FreeBSD 6.1-RELEASE & psql 8.1.3 And that of the new machine: FreeBSD 7.2-RELEASE & psql 8.4.0 (Using "uname -a" "psql -U pgsql" to check the version) I used pg_dump to dump the old d

Re: [GENERAL] Errors regarding transporting database using pg_dump

2009-10-05 Thread Chun-fan Ivan Liao
06:07:44PM +0800, Chun-fan Ivan Liao wrote: > > I used pg_dump to dump the old database out and psql to store the database > > into the new server, but the following two errors occurred: > > > > ERROR:  incompatible library "/lib/libc.so.6": missing magic block > &