Hi,
While testing Hot Standby, I have encountered strange behavior with
DROP DATABASE command.
1) connect to "test" database at standby via psql
2) issue DROP DATABASE test command to primary
3) session #1 works fine
4) close session #1
5) "test" database dropped on standby
Fromt the manual:
Running DROP DATABASE, ALTER DATABASE ... SET TABLESPACE, or ALTERDATABASE ... RENAME on primary will generate a log
messagethat willcause all users connected to that database on the standby to beforcibly disconnected. This action
occursimmediately, whatever thesetting of max_standby_delay.
So it seems at least the behavior is quite different from what the
docs stats. Am I missing something here?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp