From: | "Techsupport" <techsupport(at)sardonyx(dot)in> |
---|---|
To: | <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | 20220722-pg_dump: error: invalid number of parents 0 for table |
Date: | 2022-07-22 15:20:43 |
Message-ID: | 014a01d89dde$9e120030$da360090$@sardonyx.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2022-07-22 15:52:47 | Re: 20220722-pg_dump: error: invalid number of parents 0 for table |
Previous Message | Sergey Burladyan | 2022-07-22 14:46:37 | How does postgres sort large strings? |