Hi,
I am running streaming replication with the archive.
As you can see below that Master pg_xlog is at WAL:
000101330093. But archive_status shows way behind:
000101330088.done
What could be the reason behind this? How should I let the PostgreSQL
archive the WAL from
On Wed, Sep 27, 2017 at 2:55 PM, Jerry Sievers
wrote:
> John Britto writes:
>
> > Hello,
> >
> > I have a streaming replication setup along with WAL archive.
> >
> > archive_command = ‘test ! -f /var/pg_archive/%f && cp %p > location>%f && scp %p postgres@192.168.0.123:/%f'
> >
> > When the SCP
John Britto writes:
> Hello,
>
> I have a streaming replication setup along with WAL archive.
>
> archive_command = ‘test ! -f /var/pg_archive/%f && cp %p location>%f && scp %p postgres@192.168.0.123:/%f'
>
> When the SCP command fails, the master repeatedly tries to send the
> archived WAL to s
