Alexander Spiteri <alexander(at)spiteri(dot)org> writes:
> I tried the command as you suggested but still had the same issue.
> [postgres(at)server4 ~]$ pg_restore -p 5432 -d stgsample04
> /var/lib/pgsql/data/dumps/stgsample01_schema.dump | psql
Uh, no, you need to drop the -d switch from the pg_restore call ...
(and the -p switch is useless as well)
regards, tom lane