Discussion:
[ADMIN] two questions regarding warm-standby on 8.4
(too old to reply)
Gary Webster
2012-01-23 14:48:56 UTC
Permalink
Hello.

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?

Thanks.
Gx
Devrim GÜNDÜZ
2012-01-23 14:52:30 UTC
Permalink
Hi,
Post by Gary Webster
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
Simon Riggs
2012-01-23 14:53:11 UTC
Permalink
Post by Gary Webster
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
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Gary Webster
2012-01-23 20:05:46 UTC
Permalink
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.
Post by Gary Webster
Post by Gary Webster
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.
Post by Gary Webster
1) The standby database never 'starts', right?
(/etc/init.d/postgresql-8.4
Post by Gary Webster
start" times out; I can't connect to the db to see if tables are
correct).
Post by Gary Webster
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
Simon Riggs
2012-01-23 20:53:29 UTC
Permalink
Post by Gary Webster
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
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...