| From: | AI Rumman <rummandba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | streaming replication trigger file |
| Date: | 2011-06-16 08:31:53 |
| Message-ID: | BANLkTim_271G=_xPD9s_4vjvu-kRW7WB5A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I am a bit confused regarding streaming replication.
I have two server: A and B.
I set up replication successfully.
But when the master A goes down, B are not acting as master.
My recovery.conf as follows:
standby_mode = 'on'
primary_conninfo = 'host=10.0.0.91 port=5432 user=postgres'
trigger_file = 'C:\\pg\\stopreplication\\standby.txt'
restore_command = 'copy \pg\\wal_archive_91\\%f %p'
When I manually create the C:\\pg\\stopreplication\\standby.txt' file, then
it is working. That is, B is becoming the master.
So, my question is, how this trigger file should be created so that B will
become master automatically as soon as A goes down?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manuel Gysin | 2011-06-16 08:35:13 | Re: Encryption For Specific Column- Where to store the key |
| Previous Message | salah jubeh | 2011-06-16 08:22:23 | order by and view def. |