Thanks for your reply Adrian Klaver, Yes, I have the tablespace. It is not located in the default data directory. It is comes under new directory Thanks, Karthick Ramu -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Friday, July 22, 2022 9:23 PM To: Techsupport; pgsql-general@xxxxxxxxxxxxxxxxxxxx Subject: Re: 20220722-pg_dump: error: invalid number of parents 0 for table 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
