Re: pg_standby replication problem

From: Khangelani Gama <kgama(at)argility(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_standby replication problem
Date: 2014-06-09 14:28:53
Message-ID: ce3ab4298e3cc6f2751653d6f50f0342@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Please please help

*From:* Khangelani Gama [mailto:kgama(at)argility(dot)com]
*Sent:* Monday, June 09, 2014 1:42 PM
*To:* pgsql-general(at)postgresql(dot)org
*Subject:* pg_standby replication problem

Please help me with this, my secondary server shows a replication problem.
It stopped at the file called *0000000500004BAF000000AF …*then from here
primary server kept on sending walfiles, until the walfiles used up the
disc space in the data directory. How do I fix this problem. It’s postgres
9.1.2.

*Postgres log file Postgres-2014-06-08_000000.log file **has the following
details :*

2014-06-08 00:15:54 SAST LOG: restored log file *"0000000500004BAF000000AF"
from* archive

Trigger file: /tmp/recovery.pgsql.trigger.5432

Waiting for WAL file: 0000000500004BAF000000B0

WAL file path: /pgsql2/walfiles/0000000500004BAF000000B0

Restoring to: pg_xlog/RECOVERYXLOG

Sleep interval: 2 seconds

Max wait interval: 0 forever

*Command for restore: cp "/pgsql2/walfiles/0000000500004BAF000000B0"
"pg_xlog/RECOVERYXLOG"*

Keep archive history: 0000000500004BAE000000F7 and later

WAL file not present yet. Checking for trigger file...

WAL file not present yet. Checking for trigger file...

WAL file not present yet. Checking for trigger file...

WAL file not present yet. Checking for trigger file...

WAL file not present yet. Checking for trigger file...

CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-06-09 14:36:03 Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb
Previous Message Adrian Klaver 2014-06-09 14:27:23 Re: PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb