| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore 1 Table from pg_dumpall? [RESOLVED] |
| Date: | 2013-01-22 18:32:42 |
| Message-ID: | alpine.LNX.2.00.1301221031050.16354@salmo.appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 22 Jan 2013, Joshua D. Drake wrote:
> Rich, the main problem is using pg_dumpall. Unfortunately pg_dumpall has
> not kept up with all the other advances Postgres has had in the last
> decade. To set up dump based backups properly I suggest reviewing:
>
> http://www.commandprompt.com/blogs/joshua_drake/2010/07/a_better_backup_with_postgresql_using_pg_dump/
Thanks, Josh, I will read that.
I have only 4 databases so I can easily back up each one individually. I
make system backups daily using dirvish but understand that it's better to
backup the databases separately with the appropriate tools.
Regards,
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2013-01-22 18:34:43 | Re: Pg_xlog increase due to postgres crash (disk full) |
| Previous Message | Joshua D. Drake | 2013-01-22 18:17:06 | Re: Restore 1 Table from pg_dumpall? [RESOLVED] |