[GENERAL] Hot-Standby and sequences

2011-02-02 Thread Wouter D'Haeseleer
-c "select last_value from foo" 10 Using Nextval -- # psql -t -h master -c "select nextval('foo')" 11 # psql -t -h master -c "select last_value from foo" 11 # psql -t -h slave -c "select last_value from

[GENERAL] Hot-Standby and sequences

2011-02-02 Thread Wouter D'Haeseleer
-c "select last_value from foo" 10 Using Nextval -- # psql -t -h master -c "select nextval('foo')" 11 # psql -t -h master -c "select last_value from foo" 11 # psql -t -h slave -c "select last_value from

Re: [GENERAL] Hot-Standby and sequences

2011-02-02 Thread Wouter D'Haeseleer
OKay Tom, Thanks for this clarification

Re: [GENERAL] Question about switchover with PG9 replication

2011-02-07 Thread Wouter D'Haeseleer
Question 1 : is it possible to have such a replication configuration with the streaming replication of PG9 (cascaded replication) ? Nope, as far as I have tested pg only has 1 master and can have a number of slaves, so having 2 masters is not possible. Question 2 : All the proce