Thread

WAL replication standby server: query

KK CHN <kkchn.in@gmail.com> — 2024-10-15T17:10:53Z

List ,

I am trying  to  configure a WAL replicated  standby server(EDB16) ..   In
the archive command  I used a dedicated  "/data/archive " directory  for
WAL archiving as follows, as I don't want any WAL overwriting in the
default WAL directory and loss of WAL files.

I have
archive_command=  ' cp %p /data/archive/%f '

pg_hba.conf    I have

host replication     all             10.255.10.0/24              md5

My doubt is whether the standby Postgres server(EDB16) reads WAL files by
itself   from the primary server's  explicit WAL archive folder
/data/archive  by its own  ?
OR
  The standby can read  only from the default WAL location  ie; pg_wal
 directory of primary server ?

Please  enlighten me.

If the standby can read only the default pg_wal folder, then how can we
make the standby server to read from the explicit  " /data/archive "
folder for WAL syncing automatically to the standby ?

Any input is much appreciated.

Thank you,
Krishane