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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
