On Thu, Aug 6, 2009 at 6:42 AM, sub_woofer<tqzeli...@yahoo.co.uk> wrote: > > 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???
You're probably better off switching to explicitly backing up databases in the custom format and using a single pg_dumpall --globals to backup the users accounts and such. That's how I prefer to do it and it makes life much easier. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
