Re: Streaming replication issue

[mallikarjun t <mallit333@xxxxxxxxx>]

Dear Team,

Please find the below commands,

[postgres@localhost bin]$ ps -ef | grep sender
postgres   3577   3521  0 19:33 ?        00:00:00 postgres: wal sender process postgres 192.168.211.149(59260) streaming 0/12D5AAA8
postgres   3622   3460  0 19:37 pts/1    00:00:00 grep --color=auto sender
[postgres@localhost bin]$
[postgres@localhost bin]$

[postgres@localhost pg_log]$ ps -ef | grep receiver
postgres   3600   3594  0 19:33 ?        00:00:01 postgres: wal receiver process   streaming 0/12D5AAA8
postgres   3660   3512  0 19:39 pts/0    00:00:00 grep --color=auto receiver
[postgres@localhost pg_log]$

In slave server process

[postgres@localhost pg_log]$ ps -ef | grep postgres
root       3511   3476  0 19:31 pts/0    00:00:00 su - postgres
postgres   3512   3511  0 19:31 pts/0    00:00:00 -bash
postgres   3594      1  0 19:33 pts/0    00:00:00 /opt/edb/as9.6/bin/edb-postgres -D /home/postgres/data_96
postgres   3595   3594  0 19:33 ?        00:00:00 postgres: logger process
postgres   3596   3594  0 19:33 ?        00:00:01 postgres: startup process   recovering 000000010000000000000012
postgres   3597   3594  0 19:33 ?        00:00:00 postgres: checkpointer process
postgres   3598   3594  0 19:33 ?        00:00:00 postgres: writer process
postgres   3599   3594  0 19:33 ?        00:00:00 postgres: stats collector process
postgres   3600   3594  0 19:33 ?        00:00:01 postgres: wal receiver process   streaming 0/12D5AAA8
postgres   3669   3512  0 19:39 pts/0    00:00:00 ps -ef
postgres   3670   3512  0 19:39 pts/0    00:00:00 grep --color=auto postgres
[postgres@localhost pg_log]$

Regards,

Malli.

On Thu, Sep 5, 2019 at 3:04 PM mallikarjun t <mallit333@xxxxxxxxx> wrote:

Dear All,

 

Iam doing streaming replication between PostgreSQL community version to EDB Advanced server. It is possible or not? Same versions for example PostgreSQL community version is 9.6.2 and EDB Advanced Server PostgreSQL compatability version is 9.6.2.7.  PostgreSQL community version taken as Master and EDB Advanced Server taken as Slave server.

 

I am already configured, streaming is also happens, but Slave server (EDB Advanced Server) I am trying to connect to ./psql I will get below error message.

 

ERROR: psql.bin: FATAL: role "postgres" is not permitted to log in

 

Iam try to access port number also I will get below error message.

 

./psql -p 5432 

psql.bin: 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 checked the /tmp directory .s.PGSQL.5444  port number is running, and postmaster.pid also contains 5444 port number. But I am stop this database cluster and take the basebackup of PostgreSQL Community version and start the cluster. but postmaster.pid file contains port number is 5444. 

Why this  take 5444 port not in 5432 port ?

 

Please clarify the issuse?

 

Regards,

Malli.