Postgres Pro
Downloads
Home   >   mailing lists

Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1 - Mailing list pgsql-general

From Jim Nasby
Subject Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1
Date
Msg-id 8d06ea25-d817-e86b-a734-8f9ca41c5709@BlueTreble.com
Whole thread Raw
In response to Questions on Post Setup MASTER and STANDBY replication - Postgres9.1  (Joanna Xu <Joanna.Xu@amdocs.com>)
Responses Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1  (Joanna Xu <Joanna.Xu@amdocs.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: initdb createuser commands
Next
From: Jim Nasby
Date:
Subject: Re: Recover from corrupted database due to failing disk