> Date: Wed, 27 Aug 2008 06:58:33 -0700
> From: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] [GENERAL] PITR - base backup question
> To: pgsql-general@postgresql.org; [EMAIL PROTECTED]; [EMAIL PROTECTED]
>
>
>
>
> --- On Tue
On Wed, Aug 27, 2008 at 9:52 AM, Michael Nolan <[EMAIL PROTECTED]> wrote:
>> This is a nice touch. With a little bash-fu you could do a find |
>> xargs rm and list/kill the files in one pass. In the standby setups
>> I've done I usually script the whole process, a prep on the main and a
>> startu
--- On Tue, 8/26/08, Richard Broersma <[EMAIL PROTECTED]> wrote:
> From: Richard Broersma <[EMAIL PROTECTED]>
> Subject: [GENERAL] PITR - base backup question
> To: "pgsql-general@postgresql.org" , [EMAIL
> PROTECTED]
> Date: Tuesday, August 26, 200
On Wed, Aug 27, 2008 at 8:32 AM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> > 3. Shut down the Postgresql server running on the backup server, if any
> > pg_ctl stop
> > (Use 'ps ax' to make sure the server is stopped.)
>
> probably pg_ctl -m fast stop or -m immediate...since we a
On Wed, Aug 27, 2008 at 9:18 AM, Michael Nolan <[EMAIL PROTECTED]> wrote:
> I have what I have sometimes called a 'tepid spare' backup. Once a week I
> copy the physical files over to another system (actually to two of them) and
> every few hours I make sure the archived WAL log files are in sync
I have what I have sometimes called a 'tepid spare' backup. Once a week I
copy the physical files over to another system (actually to two of them) and
every few hours I make sure the archived WAL log files are in sync (using
rsync.)
Anyway, here's the cookbook guide I wrote for updating one of th
On Tue, Aug 26, 2008 at 9:04 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> On Tue, Aug 26, 2008 at 5:38 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
>
>
>> 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
On Tue, Aug 26, 2008 at 5:38 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> 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.
Thanks for t
On Tue, Aug 26, 2008 at 6:53 PM, Richard Broersma
<[EMAIL PROTECTED]> 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 direct
>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?
--
10 matches
Mail list logo
