From: | "Techsupport" <techsupport(at)sardonyx(dot)in> |
---|---|
To: | "'Adrian Klaver'" <adrian(dot)klaver(at)aklaver(dot)com>, <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | RE: 20220722-pg_dump: error: invalid number of parents 0 for table |
Date: | 2022-07-23 04:27:53 |
Message-ID: | 015301d89e4c$952913f0$bf7b3bd0$@sardonyx.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com]
Sent: Friday, July 22, 2022 9:23 PM
To: Techsupport; pgsql-general(at)lists(dot)postgresql(dot)org
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rory Campbell-Lange | 2022-07-23 09:09:40 | Logical replication versus pglogical on PostgreSQL 14 |
Previous Message | Zheng Li | 2022-07-22 21:18:56 | Re: Support logical replication of DDLs |