Hi Niranjan,
On Mon, Feb 9, 2009 at 6:58 PM, K, Niranjan (NSN - IN/Bangalore)
<niranjan.k@nsn.com> wrote:
>> 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.
Thanks for the informations!
---------------------------
[postgres@node1 ~]$ psql -d replication
psql: could not connect to server: No such file or directory Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
---------------------------
I think that your standby postmaster is running under port = 5433, so
please specify "-p 5433".
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center