Re: Streaming replication issue

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 <[email protected]> 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.
>