Hi Team,
We are using PostgreSQL 12.3, It is running under windows
In that server there is nearly 8 databases are running.
I have changed the data directory from one drive to another drive. At the time of change the data directory,
have stopped the PostgreSQL instance and Copy the contents under the data directory and paste it on the new drive,
and changed the data directory in the registry and start the instance.
After that all the databases are working, but unable to take backup for one database.
In 8 database, I have faced this issue in one database.
When I see the log file it gives the following error,
2022-07-16 12:16:58.019 +04 [9332] STATEMENT: select f_rta_log_partition();
2022-07-16 12:21:41.186 +04 [12936] LOG: request to flush past end of generated WAL; request D9F/E61D8E10, currpos D9F/E61AB138
2022-07-16 12:21:41.186 +04 [12936] CONTEXT: writing block 9 of relation pg_tblspc/907117/PG_12_201909212/907120/2611
2022-07-16 12:21:41.187 +04 [12936] ERROR: xlog flush request D9F/E61D8E10 is not satisfied --- flushed only to D9F/E61AB138
2022-07-16 12:21:41.187 +04 [12936] CONTEXT: writing block 9 of relation pg_tblspc/907117/PG_12_201909212/907120/2611
2022-07-16 12:21:42.458 +04 [12936] LOG: request to flush past end of generated WAL; request D9F/E61D8E10, currpos D9F/E61AB138
2022-07-16 12:21:42.458 +04 [12936] CONTEXT: writing block 9 of relation pg_tblspc/907117/PG_12_201909212/907120/2611
2022-07-16 12:21:42.459 +04 [12936] ERROR: xlog flush request D9F/E61D8E10 is not satisfied --- flushed only to D9F/E61AB138
2022-07-16 12:21:42.459 +04 [12936] CONTEXT: writing block 9 of relation pg_tblspc/907117/PG_12_201909212/907120/2611
2022-07-16 12:21:42.460 +04 [12936] WARNING: could not write block 9 of pg_tblspc/907117/PG_12_201909212/907120/2611
2022-07-16 12:21:42.460 +04 [12936] DETAIL: Multiple failures --- write error might be permanent.
…
When I try to back up by using command prompt it shows the below error
pg_dump: error: invalid number of parents 0 for table "<partition Table name>"
suggest me how to solve this issue.
Thanks in advance.
Thanks,
Karthick Ramu
