Thread: I can't see wal receiver process in one node
Hi everybody I have a question about the replication process, I have a cluster with three nodes A,B and C in PostgreSQL 9.3 with streaming replication in cascade mode MASTER->SLAVE-SLAVE. The question is a single process that I can't see in Node B but yes I can see it in the Node C. This process is this: Node B: * postgres: startup process recovering 000000xxxxxxx * Node C: * postgres: startup process recovering 000000xxxxxxx postgres: wal receiver process streaming xxxx/XXXXXX* The wal 000000xxxxxxx is the same in both. Is a problem or is the case in the process of cascade replication? Best regards DrakoRod ----- Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- View this message in context: http://postgresql.nabble.com/I-can-t-see-wal-receiver-process-in-one-node-tp5896950.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Wed, 6 Apr 2016 03:13 DrakoRod, <drakoflames@hotmail.com> wrote:
Hi everybody
I have a question about the replication process, I have a cluster with three
nodes A,B and C in PostgreSQL 9.3 with streaming replication in cascade mode
MASTER->SLAVE-SLAVE. The question is a single process that I can't see in
Node B but yes I can see it in the Node C.
This process is this:
Node B:
*
postgres: startup process recovering 000000xxxxxxx *
What is your recovery.conf on Slave (NodeB)? Are you also/only using restore_command?
Node C:
*
postgres: startup process recovering 000000xxxxxxx
postgres: wal receiver process streaming xxxx/XXXXXX*
The wal 000000xxxxxxx is the same in both.
Is a problem or is the case in the process of cascade replication?
Best regards
DrakoRod
-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
View this message in context: http://postgresql.nabble.com/I-can-t-see-wal-receiver-process-in-one-node-tp5896950.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
Hi Sameer Yesterday I reviewed the configuration in both servers. Configured each with the restore_command and archive_cleanup_command (to clean wal archives). But I saw in the Node B (only this node) have active the parameter named recovery_target_timeline = 'latest', this was because the one production node failed and the node B had that resync up the replication with another production node. My question. This parameter if not disabled affect the replication? Best Regards! DrakoRod ----- Dame un poco de fe, eso me bastará. Rozvo Ware Solutions -- View this message in context: http://postgresql.nabble.com/I-can-t-see-wal-receiver-process-in-one-node-tp5896950p5897234.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.