Re: Help with pg_restore - Mailing list pgsql-admin

From Tom Lane
Subject Re: Help with pg_restore
Date
Msg-id 20558.1061415027@sss.pgh.pa.us
Whole thread Raw
In response to Help with pg_restore  ("dan" <dan@webfolks.us>)
Responses Re: Help with pg_restore
List pgsql-admin
"dan" <dan@webfolks.us> writes:
> cat file1 file2 file3 | pg_restore --clean --create

Not sure that you can get away with this; pg_restore may expect to be
able to seek in its input file.

> It churned for a while and generated a lot of output (file1 and file 2 are
> just over a gigabyte each, and file3 is about 300 MB). But when I ran psql,
> none of the tables had been created. What am I doing wrong?

Were there any error messages in that output?

You've left out a lot of other significant information, btw, like how
you invoked pg_dump, what OS this is, what PG version, ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "VanderLeeden"
Date:
Subject: DBMirror - Replicating binary objects of type bytea ?
Next
From: "dan"
Date:
Subject: Re: Help with pg_restore