two questions regarding warm-standby on 8.4

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

two questions regarding warm-standby on 8.4

От:
Gary Webster <webster@lexmark.com>
Дата:
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.
Gx

Re: two questions regarding warm-standby on 8.4

От:
Devrim GÜNDÜZ <devrim@gunduz.org>
Дата:
Вложения:
Hi,

On Mon, 2012-01-23 at 09:48 -0500, Gary Webster wrote:

> 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?

Both are correct. You need to use 9.0+ to be able to read from standby.

Regards,
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Re: two questions regarding warm-standby on 8.4

От:
Simon Riggs <simon@2ndQuadrant.com>
Дата:
On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster  wrote:

> I am configuring warm-standby as documented here:
> http://www.postgresql.org/docs/8.4/interactive/warm-standby.html
>
> 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?

Exactly. That's what Hot Standby does in 9.x

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: two questions regarding warm-standby on 8.4

От:
Gary Webster <webster@lexmark.com>
Дата:
Hello.
Thanks for the informative replies.

So, is Hot Standby the recommended way to do HA?
My application does not need to be able to do queries on the standby.


On Mon, Jan 23, 2012 at 9:53 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
On Mon, Jan 23, 2012 at 2:48 PM, Gary Webster <webster@lexmark.com> wrote:

> I am configuring warm-standby as documented here:
> http://www.postgresql.org/docs/8.4/interactive/warm-standby.html
>
> 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?

Exactly. That's what Hot Standby does in 9.x

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: two questions regarding warm-standby on 8.4

От:
Simon Riggs <simon@2ndQuadrant.com>
Дата:
On Mon, Jan 23, 2012 at 8:05 PM, Gary Webster  wrote:

> Thanks for the informative replies.
>
> So, is Hot Standby the recommended way to do HA?
> My application does not need to be able to do queries on the standby.

Streaming replication is the recommended way to do HA, which is roughly "yes".

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
FAQ