2016-09-20 16:29 GMT+12:00 Lucas Possamai <drum.lu...@gmail.com>: > > > 2016-09-20 15:14 GMT+12:00 Venkata B Nagothi <nag1...@gmail.com>: > >> >> 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 >> >> > > > > Yes..... > >
Ops.. sorry... sent to the wrong email
