Hi,
> [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".
It was silly that I missed this. :-(
But after I login to replication database (note the active I had brought
it down earlier & created a finish.trigger), I still cannot see the
table that was created on the primary.
Also please note that the LSN had changed after replication in the ps
command.
I have attached the logs.
regards,
Niranjan