Re: What is better method to backup postgresql DB. - Mailing list pgsql-general

From Simon Riggs
Subject Re: What is better method to backup postgresql DB.
Date
Msg-id 1288170113.1587.1441.camel@ebony
Whole thread Raw
In response to What is better method to backup postgresql DB.  (Steeles <steeles@gmail.com>)
List 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



pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?
Next
From: "Marc Mamin"
Date:
Subject: pg_get_procdef ?