| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | sub_woofer <tqzelijah(at)yahoo(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgresql Backups |
| Date: | 2009-08-07 19:54:47 |
| Message-ID: | dcc563d10908071254j37ca9b17w95e16e9a75412641@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Aug 6, 2009 at 6:42 AM, sub_woofer<tqzelijah(at)yahoo(dot)co(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ray Stell | 2009-08-07 20:07:03 | Re: Postgresql Backups |
| Previous Message | Sam Mason | 2009-08-07 19:38:07 | Re: Getting linux $USER (and perhaps other env vars) in PL/pg-sql? |