"dan" <dan(at)webfolks(dot)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