On 05/05/2015 11:21 AM, Melvin Davidson wrote:
Have you allowed access to user "replication" in the master pg_hba.conf
and done a
SELECT pg_reload_conf()?
Can you ping the master from the standby?
Did you RTFM?
http://www.postgresql.org/docs/9.2/interactive/warm-standby.html
25.2.3 Preparing the Master for Standby Servers
25.2.4 Setting Up a Standby Server
See the OPs original post:
http://www.postgresql.org/message-id/5546C3DC.5070808@xxxxxxxxxxxxxxx
The OP had streaming only replication working, so the basics are there.
The wheels fell off when WAL archiving was introduced. Best guess is
this is a timing issue, the relevant WALs got recycled while archiving
was being set up and the standby was down.
On Tue, May 5, 2015 at 2:05 PM, Edson F. Lidorio <edson@xxxxxxxxxxxxxxx
<mailto:edson@xxxxxxxxxxxxxxx>> wrote:
__
Em 2015-05-05 14:31, Adrian Klaver escreveu:
On 05/05/2015 08:35 AM, Edson F. Lidorio wrote:
On 05-05-2015 11:22, Melvin Davidson wrote:
It's possible you have wal_keep_segments set too low. What
happens is that the master will keep the wals ( in your case 20)
after processing them, before sending them off to the great
black hole in the network (deleting) and making them unavailable
to the standby. Try increasing wal_keep_segments = 100.
Increased thewal_keep_segments=100andkeeps popping upthe same
message:
The message did not come through. Also increasing wal_keep_segments only works for the future, it will not deal with a WAL file that has already been recycled before the setting was changed.
A question thatI have! astheslave servercan seethis folderin
themaster? /mnt/server/archivedir/
So have you tried logging into the standby and then accessing the directory on the master manually. In other words copy a file from the master to standby using cp from the standby command line.
Sorrymy doubtsI'mbasicbeginner!
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
OK,I'm going to dothis testtoo.
--
Edson F. Lidorio
Atenção: Este e-mail pode conter anexos no formato ODF (Open Document
Format)/ABNT (extensões odt, ods, odp, odb, odg). Antes de pedir os anexos
em outro formato, você pode instalar gratuita e livremente o LibreOffice (
http://pt-br.libreoffice.org/).
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
