Re: Help with pg_restore

"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