Tena Sakai <tsakai@xxxxxxxxxxxxxx> wrote: > Having said that, I think Ian is correct that I was missing -c > flag in the command below: > gunzip ..../dumpall20100822.0.gz | /usr/local/pgsql/bin/psql -f > - postgres Yeah. Good spot on Ian's part. > This command, I think, uncompressed the file, but didn't feed the > output into the pipe and psql just waited and then received > nothing and terminated. Agreed. > Since the file got uncompressed, I am now running the command: > psql -f /home/tsakai/Notes/postgres/dumpall20100822.0 > and I think it is working. It is giving messsages: > ERROR: role "postgres" already exists > STATEMENT: CREATE ROLE postgres; > ERROR: database "testdb" already exists > STATEMENT: CREATE DATABASE testdb WITH TEMPLATE = template0 > OWNER = postgres ENCODING = 'UTF8'; > LOG: checkpoints are occurring too frequently (5 seconds apart) > HINT: Consider increasing the configuration parameter > "checkpoint_segments". > > > The last 2 lines are repeated many, many times. This is not > terribly Serious, is it? (I will fix it via postgresql.conf file > shortly.) The frequent checkpoints may affect the speed of the restore, nothing more serious than that. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
