Re: Postgresql Backups

On Thu, Aug 6, 2009 at 6:42 AM, sub_woofer<tqzelijah@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.