On Tue, Sep 20, 2016 at 12:38 PM, Patrick B <patrickbake...@gmail.com> 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_ar >> chivecleaup_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
