Re: help for pg_wal issue

[Laurenz Albe <laurenz.albe@xxxxxxxxxxx>]

On Mon, 2022-06-27 at 09:50 +0000, Özge Özyavuz wrote:
> 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

You forgot to tell us how exactly you are performing that backup.

Yours,
Laurenz Albe