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?
Pleasehelp..
>
> 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