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

warm standby server

From: zz_11(at)mail(dot)bg
To: pgsql-admin(at)postgresql(dot)org
Subject: warm standby server
Date: 2008-12-10 12:23:35
Message-ID: 20081210142335.s2y9d3bcw0kwkcw0@mail.bg (view raw or flat)
Thread:
Lists: pgsql-admin
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!Само сега–промоционални цени и на Студентските ни програми в САЩ!
  http://charter.bg/catalog/index.php

Responses

pgsql-admin by date

Next:From: Marcelo MartinsDate: 2008-12-10 13:08:19
Subject: Re: moving users/roles from one server to another?
Previous:From: Tommy GildsethDate: 2008-12-10 11:35:23
Subject: Re: moving users/roles from one server to another?

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