Re: Streaming replication issue

Dear Team,

Please find the below commands,

[postgres(at)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(at)localhost bin]$
[postgres(at)localhost bin]$

[postgres(at)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(at)localhost pg_log]$

In slave server process

[postgres(at)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(at)localhost pg_log]$

Regards,
Malli.

On Thu, Sep 5, 2019 at 3:04 PM mallikarjun t <mallit333(at)gmail(dot)com> 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.
>