Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] PITR - base backup question

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] PITR - base backup question
Date: 2008-08-27 00:38:01
Message-ID: b42b73150808261738j605e1bchc1935f81d695fb08@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On Tue, Aug 26, 2008 at 6:53 PM, Richard Broersma
<richard(dot)broersma(at)gmail(dot)com> wrote:
> From the following link:
> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP
>
> Step 3 says to perform the back up.
>
>    Does this mean a File System Backup of the Data directory?
> OR
>    Does this mean performing a pg_dumpall and backing up the dump file?

File system backup.  You tar up the database folder except pg_xlog
(and maybe pg_log).  You then expand it on the other side (making sure
to set up pg_xlog properly).  If you ever want to mess around with log
shipping I strongly suggest you go through the motions of setting up a
warm standby vi the pg_standby utility and practice popping the
standby out of recovery.  It will give you a good understanding of the
process.

merlin

In response to

Responses

pgsql-admin by date

Next:From: LewDate: 2008-08-27 00:46:33
Subject: Re: Bug introduced in 8.0
Previous:From: steveDate: 2008-08-27 00:19:42
Subject: Re: PITR - base backup question

pgsql-general by date

Next:From: Richard BroersmaDate: 2008-08-27 01:00:26
Subject: Re: PITR - base backup question
Previous:From: steveDate: 2008-08-27 00:19:42
Subject: Re: PITR - base backup question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group