Hi Niranjan, On Mon, Feb 9, 2009 at 6:58 PM, K, Niranjan (NSN - IN/Bangalore) <niranja...@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! --------------------------- [postg...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers