[GENERAL] Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

2005-08-11 Thread Christian Goetze
I have a database with blobs, I dump it with the following command: pg_dump\ --host=$SENSAGE_DB_HOST\ --port=$SENSAGE_DB_PORT\ -U $SENSAGE_DB_ROOT_USER\ --blobs\ --create\ --format=t\ --file="$upgrade_dump"\ $SENSAGE_DB_NAME I then move the data directory to the side, install the new version in

Re: [GENERAL] Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

2005-08-11 Thread Christian Goetze
pg_restore: [archiver] WARNING: skipping large-object restoration IIRC, you get that if you're asking it to emit a text script rather than connect directly to the destination database server. I think you need a "-d databasename" switch to make that happen. Does this mean that

[GENERAL] Upgrading 7.3.9 -> 7.4.8 - trouble with blobs

2005-08-12 Thread Christian Goetze
I have a database with blobs, I dump it with the following command: pg_dump\ --host=$SENSAGE_DB_HOST\ --port=$SENSAGE_DB_PORT\ -U $SENSAGE_DB_ROOT_USER\ --blobs\ --create\ --format=t\ --file="$upgrade_dump"\ $SENSAGE_DB_NAME I then move the data directory to the side, install the new version in

[GENERAL] Building postgres on Suze

2005-09-12 Thread Christian Goetze
I'm trying to build postgres on Suze with --with-pam, and it tells me: /usr/lib/gcc-lib/i586-suse-linux/3.3.5/../../../../i586-suse-linux/bin/ld: cannot find -lpam I know it is actually installed, and disecting the configure script and hand-compiling the test program works if I say "/lib/libp