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@aklaver.com