From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | sub_woofer <tqzelijah(at)yahoo(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql Backups |
Date: | 2009-08-06 14:23:46 |
Message-ID: | 4A7AE772.6010406@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Trutwin | 2009-08-06 16:53:16 | Empty Updates, ON UPDATE triggers and Rules |
Previous Message | Nicolas | 2009-08-06 14:23:41 | Re: Clients disconnect but query still runs |