I can't see wal receiver process in one node

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general