Re: Centos Hot-Standby, different Startup behavior between systemctl & pg_ctl start.

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: kurt(at)thepw(dot)com
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Centos Hot-Standby, different Startup behavior between systemctl & pg_ctl start.
Date: 2016-01-02 10:39:06
Message-ID: CAP6d-HVsHfJvSm5LQEzx4A5x=5VE_3SESf7UJ3tcU6BwHsXQ-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi

I apologise if the quoting in my message is broken. Replying from my phone.

On 31 Dec 2015 10:31 PM, <kurt(at)thepw(dot)com> wrote:
>
>
> Hello,
> I am running postgresql on Centos 7.2, using postgresql from the
standard Centos repository, which provides postgresql.
>
> My goal is to run a Master and a hot-standby server via WAL-file
archiving, and the standby machine seems to be working prop[erly as long as
I start postgresql on it via pg_ctl on the command line as the postgres
user. The logs in pg_log collect lots of messages like:
>
> "cp: cannot stat ‘/var/backup/WALarchive/0000000100000006000000FD’: No
such file or directory"

What does the following output?

# ls -ld / /var /var/backup /var/backup/WALarchive /var/backup/WALarchive/*

> but eventually i see a line like:
>
> "LOG: restored log file "0000000100000006000000FD" from archive"

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Damian Carey 2016-01-04 01:43:54 Finding aggregate data size in columns
Previous Message kurt 2015-12-31 20:34:29 Re: Centos Hot-Standby, different Startup behavior between systemctl & pg_ctl start.