Re: BUG #14009: pg_restore not restoring privilegs when one login/group role is missing

Alexander Spiteri <alexander@spiteri.org> writes:
> I tried the command as you suggested but still had the same issue.
> [postgres@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