Thread: pg_dump and restore

pg_dump and restore

From
John Herreshoff
Date:
Hi.

1.  pg_dump works just great, but pg_restore does not.  I can reload the
database with pg_restore; I need to use psql.  Anyone know what's up?

2.  When I restored the database, psql complained that it could not find
users and groups.  I would assume that I need to use some switch with pg_dump
in order to save the users and groups.  Again, anyone know how to solve this
problem?

TIA.

John.