Search Postgresql Archives

Re: FATAL: could not receive data from WAL stream

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2016-09-20 16:29 GMT+12:00 Lucas Possamai <drum.lucas@xxxxxxxxx>:


2016-09-20 15:14 GMT+12:00 Venkata B Nagothi <nag1010@xxxxxxxxx>:

On Tue, Sep 20, 2016 at 12:38 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:
Hi guys,

I got a slave server running Postgres 9.2 with streaming replication and wal_archive in an EC2 Instance at Amazon.

Postgres logs are showing me this error:
restored log file "000000020000179A000000F8" from archive
invalid record length at 179A/F8FFF3D0
WAL segment `/var/lib/pgsql/9.2/archive/00000003.history` not found
streaming replication successfully connected to primary
FATAL:  could not receive data from WAL stream: FATAL:  requested WAL segment 000000020000179A000000F8 has already been removed

However, 000000020000179A000000F8 file is inside /var/lib/pgsql/9.2/archive directory:
postgres@devops:/var/lib/pgsql/9.2/archive$ ls -la | grep 000000020000179A000000F8
-rw------- 1 postgres postgres 16777216 Sep 16 05:16 000000020000179A000000F8 


It's an UBUNTU instance, so my recovery.conf is:


/etc/postgresql/9.2/main/recovery.conf:
restore_command = 'exec /var/lib/pgsql/bin/restore_wal_segment.bash "/var/lib/pgsql/9.2/wal_archive/%f" "%p"'
archive_cleanup_command = '/var/lib/postgresql/bin/pg_archivecleaup_mv.bash'
recovery_target_timeline = 'latest'
standby_mode = on
primary_conninfo = 'host=IP_MY_SLAVE port=5432 user=replicator application_name=devops' 


What can be happening, if the file is in there?

Do you mean to say that the WAL file "000000020000179A000000F8" is available @ "/var/lib/pgsql/9.2/archive" location ?

Regards,
Venkata B N

Fujitsu Australia





Yes.....  



Ops.. sorry... sent to the wrong email 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux