| From: | "K, Niranjan (NSN - IN/Bangalore)" <niranjan(dot)k(at)nsn(dot)com> |
|---|---|
| To: | "ext Fujii Masao" <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Synch Replication |
| Date: | 2009-02-09 09:58:39 |
| Message-ID: | 39C6C93FC1236641B94D3648B96E3BE702992C2E@inbhexc001.nsn-intra.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
> > - I brought down the active instance by executing 'pg_ctl -D
> > /home/postgres/postgresHSB/actdata stop' hoping that trigger file
will
> > enable failover. But I was not able to login to standby instance.
Not
> > sure why?
>
> Please let me know the failover procedure which you carried
> out. As follows?
>
> 1) pg_ctl -D /home/postgres/postgresHSB/actdata stop
> 2) touch /home/postgres/postgresHSB/finish.trigger
Yes. This the procedure that I followed. I have attached the relevant
logs.
"change_standby_mode.log" - Commands used to change from continous
recovery mode of the standby instance
"ps.log" - ps command before and after executing the SQL.
Regards,
Niranjan
| Attachment | Content-Type | Size |
|---|---|---|
| walreceiver_trace.out | application/octet-stream | 22.9 KB |
| change_standby_mode.log | application/octet-stream | 563 bytes |
| postmaster.log | application/octet-stream | 172.6 KB |
| ps.log | application/octet-stream | 687 bytes |
| tcpdump.log | application/octet-stream | 5.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2009-02-09 10:28:11 | Re: Synch Replication |
| Previous Message | Mihai Criveti | 2009-02-09 09:56:55 | Re: 64 bit PostgreSQL 8.3.6 build on AIX 5300-09-02-0849 with IBM XL C/C++ 10.1.0.1 - initdb fails (could not dump unrecognized node type: 650) |