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

Re: warm standby server

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: zz_11(at)mail(dot)bg
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: warm standby server
Date: 2008-12-10 17:56:11
Message-ID: 1228931771.20796.875.camel@hp_dx2400_1 (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, 2008-12-10 at 14:23 +0200, zz_11(at)mail(dot)bg wrote:
> Hi,
>  
> I am using pg 8.3 and configured warm standby server. It is working
> well, but my db is relative big ( ~ 40 GB).
>  
> Is it possible to stop running "Warm standby server" and when it
> starts again to continue executing WALs from the stop moment.

Yes

> I'm using following command to stop the server:
>     
> kill -SIGINT `head -1 /POSTGRESQL_DATA_DIR/postmaster.pid`

Use pg_ctl

> but when it starts again there is broken link
> "/POSTGRESQL_DATA_DIR/pg_xlog/RECOVERYHISTORY" which points to the
> following missing file "/WAL_ARCHIVE_DIR/00000001.history"
> 
> i wonder if it is fatal or not?

That's normal.

> I will not to start the process ot making the base backup and send it
> to my warm standby server. My warm standby server is on diferent
> location connected via slow connection.

That's OK.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


In response to

pgsql-admin by date

Next:From: AmitKumar JainDate: 2008-12-11 08:10:54
Subject: Re: Tool to converter plsql in pgplsql
Previous:From: Scott MarloweDate: 2008-12-10 14:15:26
Subject: Re: File system level backup with more than one cluster folders

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