Home > mailing lists

two questions regarding warm-standby on 8.4 - Mailing list pgsql-admin

From	Gary Webster
Subject	two questions regarding warm-standby on 8.4
Date	January 23, 2012 13:49:13
Msg-id	CAEHjwJ6M-QZah9M4+mSDy1pGjwLLEN1EhqrcbgNJ8asx9RirLQ@mail.gmail.com Whole thread Raw
Responses	Re: two questions regarding warm-standby on 8.4 (Devrim GÜNDÜZ <devrim@gunduz.org>) Re: two questions regarding warm-standby on 8.4 (Simon Riggs <simon@2ndQuadrant.com>)
List	pgsql-admin

Hello.

I am configuring warm-standby as documented here:

I am using "pg_standby", & may have it working corrrectly, but am not sure.

1) The standby database never 'starts', right? (/etc/init.d/postgresql-8.4 start" times out; I can't connect to the db to see if tables are correct).

2) Because of #1, I suppose I can't do a pg_dump on the standby db?

Thanks.

From: "Al-Salami, Adel"
Date: 23 January 2012, 12:56:37
Subject: "service user account 'postgres' could not be created"

From: Devrim GÜNDÜZ
Date: 23 January 2012, 13:52:53
Subject: Re: two questions regarding warm-standby on 8.4