Date: Thu, 2 Jul 2020 11:54:33 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Praveen Kumar K S <praveenssit@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [HELP] Issue with standby server using WAL archive
Message-ID: <20200702155433.GT3125@tamriel.snowman.net>
References: 
 <CANSiNp6iAACN_4HjHUqFEmTOd_0QvdBiE5W1XXjwFniNwUWAYQ@mail.gmail.com>
 <20200702141444.GJ3125@tamriel.snowman.net>
 <CANSiNp6y1tm08Z=mDj6RL33iUjM1ozw6DtKY7Dz6FofxLvFNqA@mail.gmail.com>
 <20200702152608.GQ3125@tamriel.snowman.net>
 <CANSiNp4MiEBrOgK3s-Ljw7poNFeb8_oL9HuTt-hZfhqYiendFQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="+8CbEAItL+VIz8WN"
Content-Disposition: inline
In-Reply-To: 
 <CANSiNp4MiEBrOgK3s-Ljw7poNFeb8_oL9HuTt-hZfhqYiendFQ@mail.gmail.com>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk


--+8CbEAItL+VIz8WN
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Greetings,

* Praveen Kumar K S (praveenssit@gmail.com) wrote:
> I'm seeing below error on pg3 (DR server) in log. Is this expected ?
> *cp: cannot stat '/mnt/server/archivedir/00000001000000000000000D': No such
> file or directory*

Yes, that's expected, the replica will constantly attempt to get the
next WAL segment to replay, unless you have streaming replication
configured.  There's nothing wrong with that.

> On master, I see below info. I would like to know why the WALs are not
> being archived.

The WAL file isn't going to be archived until PG is done writing into
it, which won't happen until there's been ~16MB of write activity on the
database.  If you want WAL to be archived more frequently even if the
segment isn't full then you should look at the archive_timeout option.

Thanks,

Stephen

--+8CbEAItL+VIz8WN
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJe/gM5AAoJEO1sijiDR2RVK+AQAJ8HdGBreaOSsNk/ler+aDUW
yQDYnHWKvLZ/o+G7zhfUCDpy6j9gHOD+yDMtESdoulD4JO1+fOj7oklYR6bvQYkc
+nSWAmqnA/YjtPgwb+RXWiU8DrxwSsz3pD5qeijL4n/UYyw5/Va8S2oMI2xhuZEA
lirBcrsO7MqD+yJMlq4Hrpkk+rHHvA1AoRywxGncK9KhgubyunNVuPSJ/k02fWCL
LJ7Ns5NsTiomGY/pMrzy+fWhOlHXIeLlvlSAeZ/AS7yyHJ/ZY6LXSpbe08S4nILY
6zmeHpMLd94VnJCiZQVer49peOsiZ4Kvak+cOQgHswMEh5Lt43wt7PwixXudejm0
3cIWyJ1Cv4DNXktp5YF7X2rfZHlakgy6LDgXy80joBy9Jp65nCpKt3nO0JCnUGc9
ywME3hdCkb3vW/qj5hTk23YHbizt/8/Ny1IHbR6RX9eci4Zf/FkST0tb3F408fLJ
kcGhHQAprSBrg6zg+ZbOXFn9xddByZ0D0mxQTTRJa+hzHeDQxouWHzZQYksUyohD
qwnnevckyACbkOMN9b711ZFBCHcs0GXrDGi09wcwX58vsX9Wa/E941N+13U6Yo0t
ZXjVQSOHYByDuArGSaukLbef7WBcVEE9qh+SMZ9ZB0euP71AVPlj9MGRNVgION7X
+5VBE1pgZDNXsG2hsWo+
=zNUA
-----END PGP SIGNATURE-----

--+8CbEAItL+VIz8WN--