Re: Streaming replication issue
| От | mallikarjun t |
|---|---|
| Тема | Re: Streaming replication issue |
| Дата | |
| Msg-id | CAOA8XiU9BB6nPC5W+pOAzhjak=MbQ3D_N+g3KErgS9Zz7oxy2Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Streaming replication issue (mallikarjun t <mallit333@gmail.com>) |
| Список | pgsql-admin |
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 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]$
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]$
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.
В списке pgsql-admin по дате отправления: