On 7/22/22 8:20 AM, Techsupport wrote:
*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: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.
Do you have table spaces other then the default set up? In particular
for partitioned tables.
Thanks in advance.
*Thanks,*
*Karthick Ramu*
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx