Home > mailing lists

Re: replication issue - Mailing list pgsql-admin

From	Dhandapani Shanmugam
Subject	Re: replication issue
Date	April 9, 2018 14:51:51
Msg-id	CAAj4MFHbgUaqnHzJ2ZoruhOPRpowdk8grY2k3_0yk+0-XawPVw@mail.gmail.com Whole thread Raw
In response to	replication issue (Dhandapani Shanmugam <postgresql95@gmail.com>)
List	pgsql-admin

Tree view

I am getting below error in logfile

2018-04-09 16:51:00 SGT LOG: invalid record length at 0/1F000098: wanted 24, got 0

2018-04-09 16:51:00 SGT FATAL: highest timeline 1 of the primary is behind recovery timeline 2

On Mon, Apr 9, 2018 at 2:11 PM, Dhandapani Shanmugam <postgresql95@gmail.com> wrote:

Hi All,

I am setting up streaming replication and getting below error when starting the postgreSQL instance on stanby server. Need your expert advise

postgres 26110 26108 0 16:35 ? 00:00:00 postgres: startup process recovering 00000002000000000000001F

Below are my content of recovery.conf

standby_mode = 'on'
primary_conninfo = 'host=188.33.44.33 port=5432 user=replication'
restore_command = 'cp /u101/oradata/postgres/standby/pg_xlog/%f %p'

-D

pgsql-admin by date:

From: Dhandapani Shanmugam
Date: 09 April 2018, 14:41:41
Subject: replication issue

From: Dhandapani Shanmugam
Date: 09 April 2018, 15:09:51
Subject: Re: replication issue

Re: replication issue - Mailing list pgsql-admin

Previous

Next