On Wed, 2008-12-10 at 14:23 +0200, zz_11@xxxxxxx 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
