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
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
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
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