Re: Synch Replication

Hi Niranjan,

On Mon, Feb 9, 2009 at 6:58 PM, K, Niranjan (NSN - IN/Bangalore)
<niranjan(dot)k(at)nsn(dot)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(at)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