<html><body><span style="font-family:Verdana; color:#000; font-size:10pt;"><div>Hello Michael,</div><div> Thanks for your reply! The contents of /var/backup/WALarchive will of course vary, but at the moment I see:</div><div><br></div><div>[root(at)databaseServer5 ~]# ls -ld /var/backup<br>drwxr-xr-x. 3 root root 4096 Dec 24 10:16 /var/backup<br>[root(at)databaseServer5 ~]# ls -ld /var/backup/WALarchive/<br>drwx------. 2 postgres postgres 69632 Jan 4 08:40 /var/backup/WALarchive/<br>[root(at)databaseServer5 ~]# ls -ld /var/backup/WALarchive/*<br>-rw-------. 1 postgres postgres 16777216 Jan 4 08:36 /var/backup/WALarchive/000000010000000B0000009F<br>-rw-------. 1 postgres postgres 16777216 Jan 4 08:41 /var/backup/WALarchive/000000010000000B000000A0<br>[root(at)databaseServer5 ~]# <br><br> I dis this as root, and I run systemctl as root. But maybe, if systemctl does anything as an unprivileged user, the permissions on /var/backup/WALarchive would cause a problem? I will try adjusting them.</div><div><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: Re: [NOVICE] Centos Hot-Standby, different Startup behavior<br>
between systemctl & pg_ctl start.<br>
From: Michael Wood <<a href="mailto:esiotrot(at)gmail(dot)com">esiotrot(at)gmail(dot)com</a>><br>
Date: Sat, January 02, 2016 5:39 am<br>
To: <a href="mailto:kurt(at)thepw(dot)com">kurt(at)thepw(dot)com</a><br>
Cc: PostgreSQL List - Novice <<a href="mailto:pgsql-novice(at)postgresql(dot)org">pgsql-novice(at)postgresql(dot)org</a>><br>
<br>
<div dir="ltr">Hi</div> <div dir="ltr">I apologise if the quoting in my message is broken. Replying from my phone.</div> <div dir="ltr">On 31 Dec 2015 10:31 PM, <<a target="_blank" href="mailto:kurt(at)thepw(dot)com">kurt(at)thepw(dot)com</a>> wrote:<br> ><br> ><br> > Hello,<br> > I am running postgresql on Centos 7.2, using postgresql from the standard Centos repository, which provides postgresql.<br> ><br> > 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:<br> ><br> > "cp: cannot stat ‘/var/backup/WALarchive/0000000100000006000000FD’: No such file or directory"</div> <div dir="ltr">What does the following output?</div> <div dir="ltr"># ls -ld / /var /var/backup /var/backup/WALarchive /var/backup/WALarchive/*</div> <div dir="ltr">> but eventually i see a line like:<br> ><br> > "LOG: restored log file "0000000100000006000000FD" from archive"</div>
</div>
</blockquote></span></body></html>