Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> 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