help for pg_wal issue - Mailing list pgsql-general

Hi,

I want to backup my postgresql database but it fails because it is looking for some wal files on pg_wal directory.

Before backup I checked my pg_wal directory and I saw the wal file,

bash-4.2$ cd /pgdata/pgsql/data/pg_wal

bash-4.2$  ls

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000AE

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000AF

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B0

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B1

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B2

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B3

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B4

-rw------- 1 postgres postgres 16777216 Jun 24 01:16 000000010000000A000000B5

-rw------- 1 postgres postgres 16777216 Jun 24 01:31 000000010000000A000000B6

-rw------- 1 postgres postgres 16777216 Jun 24 01:46 000000010000000A000000B7

But backup fails with,

Failed to open:  /pgdata//pgsql/data/pg_wal/000000010000000A000000AE

Error! The backup has failed.

After I checked pg_wal directory and really there is no such file, it was not appear on disk. What can I do for this? Please help..

bash-4.2$ cd /pgdata/pgsql/data/pg_wal

bash-4.2$  ls

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000AF

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B0

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B1

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B2

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B3

-rw------- 1 postgres postgres 16777216 Jun 24 01:01 000000010000000A000000B4

-rw------- 1 postgres postgres 16777216 Jun 24 01:16 000000010000000A000000B5

-rw------- 1 postgres postgres 16777216 Jun 24 01:31 000000010000000A000000B6

-rw------- 1 postgres postgres 16777216 Jun 24 01:46 000000010000000A000000B7

-rw------- 1 postgres postgres 16777216 Jun 24 02:01 000000010000000A000000B8

Regards,

Some of my parameters on postgresql.conf file;

wal_buffers = 16MB 

max_wal_size = 5GB

min_wal_size = 2GB

shared_buffers = 4GB

max_wal_senders = 10

wal_level = replica                   

wal_keep_segments = 50

archive_mode = on               # enables archiving; off, on, or always

archive_command = 'cp %p /pgdata/arc'           # command to use to archive a logfile segment

archive_timeout =0              # force a logfile segment switch after this