Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Joanna Xu <Joanna(dot)Xu(at)amdocs(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1
Date: 2016-11-02 23:15:11
Message-ID: 8d06ea25-d817-e86b-a734-8f9ca41c5709@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/2/16 2:49 PM, Joanna Xu wrote:
> The replication is verified and works. My questions are what’s the
> reason causing “cp: cannot stat
> `/opt/postgres/9.1/archive/000000010000000000000003': No such file or
> directory” on STANDBY and how to fix it?

What instructions/tools did you use to setup replication?

> Also, it seems the startup
> process stucks on “recovering 000000010000000000000004”, how to resolve
> it?

As far as I know that's normal while in streaming mode.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2016-11-02 23:21:45 Re: Recover from corrupted database due to failing disk
Previous Message Jim Nasby 2016-11-02 23:05:08 Re: initdb createuser commands