Postgresql Backups

Hello all

To backup my postgresql data I use the pg_dumpall command which dumps all my
databases to a .sql file.

If I would like to restore a single database from this file how would I do
this? Is it possible using PgAdmin - as this only allows us to restore a
database from a .backup file???

When trying to do from the command prompt I get the following errors:

SET
SET
SET
SET
SET
WARNING: no privileges could be revoked for "public"
REVOKE
WARNING: no privileges could be revoked for "public"
REVOKE
WARNING: no privileges were granted for "public"
GRANT
WARNING: no privileges were granted for "public"
GRANT

And it doesnt restore my database.

Any help would be greatly appreciated!
--
View this message in context: http://www.nabble.com/Postgresql-Backups-tp24845786p24845786.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.