Обсуждение: warm standby server

Поиск
Список
Период
Сортировка

warm standby server

От
zz_11@mail.bg
Дата:
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.

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

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?

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.

regards,
Ivan.


-------------------------------------
Създай профил днес и можеш да спечелиш безплатен самолетен билет за Лондон!
Възползвай се от нашите намаления за Нова Година.Крайният срок наближава-
побързайтe!Само сега–промоционални цени и на Студентските ни програми в САЩ!

Re: warm standby server

От
Simon Riggs
Дата:
On Wed, 2008-12-10 at 14:23 +0200, zz_11@mail.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