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-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

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

2022-07-22 Thread Techsupport
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 co

RE: 20220226-Clarification regarding delay time of PostgeSQL starting up

2022-02-26 Thread Techsupport
nks, -Original Message- From: Julien Rouhaud [mailto:rjuju...@gmail.com] Sent: Saturday, February 26, 2022 8:27 PM To: Techsupport Cc: pgsql-general@lists.postgresql.org Subject: Re: 20220226-Clarification regarding delay time of PostgeSQL starting up Hi, On Sat, Feb 26, 2022 at 07:51:45PM +0

20220226-Clarification regarding delay time of PostgeSQL starting up

2022-02-26 Thread Techsupport
Hi to all, We are using PostgreSQL 12.3, it is running on the Windows Server. Database data directory is configured in the network shared path. Unexpectedly it was disconnected and up again. PgAgent is not connected, when I check the Log, it showing FATAL: the database system is star

RE: 20220221-Clarification regarding PostgeSQL DB backup

2022-02-20 Thread Techsupport
: Daevor The Devoted [mailto:doll...@gmail.com] Sent: Monday, February 21, 2022 11:05 AM To: Techsupport Cc: pgsql-generallists.postgresql.org Subject: Re: 20220221-Clarification regarding PostgeSQL DB backup Hi Karthick I'm a little rusty on PG (it's been about a decade since I l

20220221-Clarification regarding PostgeSQL DB backup

2022-02-20 Thread Techsupport
Hi Team, We have used PG_DUMP to take backup of particular database from the PostgreSQL Server. It takes too long to restore the databases , which has Half Billion records (almost 8 Hour) My primary need is to make the Differential and Incremental backup on the Windows Serv