Re: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-08-08 Thread Saul Perdomo
hey Karthick, if you've made triple sure that it's not a permissions issue, take a look at some of the suggestions in this old thread: https://dba.stackexchange.com/questions/17546/why-is-pg-dumpall-throwing-an-oid-does-not-exist-error On Mon, Aug 8, 2022 at 5:30 AM Techsupport wrote: > *Hi to a

RE: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-08-08 Thread Techsupport
Hi to all, We are using PostgreSQL 12.3 and it is running under Windows environment. In my server multiple databases are available. When we try to Back up one of the database, it gives the following error message, we can able to connect and read & write to the database. But unable to back up th

Re: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-23 Thread Adrian Klaver
On 7/23/22 07:54, Adrian Klaver wrote: On 7/22/22 21:27, Techsupport wrote: 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 Please expand on this: 1) Did it change location when you moved the

Re: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-23 Thread Adrian Klaver
On 7/22/22 21:27, Techsupport wrote: 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 Please expand on this: 1) Did it change location when you moved the data directory? 2) If so where was it pre

RE: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-22 Thread Techsupport
: Techsupport; pgsql-general@lists.postgresql.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 databa

Re: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-22 Thread Adrian Klaver
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 P