On 06/08/2009 13:42, sub_woofer 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'll have to edit the dump file and remove everything except the database you want to restore. Be aware that pg_dumpall also dumps cluster-wide objects, such as roles, which pg_dump doesn't dump. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
