| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Steeles <steeles(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What is better method to backup postgresql DB. |
| Date: | 2010-10-27 09:01:53 |
| Message-ID: | 1288170113.1587.1441.camel@ebony |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2010-10-26 at 14:27 -0400, Steeles wrote:
> new to postgresl. need to backup postgresql DB, which way is better to
> backup DB.
>
> from training, I learned that we can backup the whole PGdata and other
> direcotries to acheive backup goal, originally I was plainned to
> schedule jobs to use pgdump to backup all DBs.
>
> so which way is better for backup or there is other way to backup
> PGDB.
Backup is explained in a detailed chapter in the new book:
PostgreSQL Administration Cookbook, available from the link below.
--
Simon Riggs http://www.2ndQuadrant.com/books/
PostgreSQL Development, 24x7 Support, Training and Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Mamin | 2010-10-27 09:21:43 | pg_get_procdef ? |
| Previous Message | Devrim GÜNDÜZ | 2010-10-27 06:37:24 | Re: Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate? |