Re: Errors when restoring backup created by pg_dumpall

2024-12-13 Thread PopeRigby
On 12/13/24 08:46, Adrian Klaver wrote: On 12/12/24 22:19, PopeRigby wrote: On 12/10/24 21:22, Adrian Klaver wrote: On 12/10/24 19:05, PopeRigby wrote: If I am following correctly I believe you need this one: https://www.postgresql.org/message-id/attachment/166859/v2-0002-Use-new-style-SQL

Re: Credcheck- credcheck.max_auth_failure

2024-12-13 Thread Peter J. Holzer
On 2024-12-11 13:43:38 -0500, Ron Johnson wrote: > On Wed, Dec 11, 2024 at 12:57 PM Greg Sabino Mullane > wrote: > > On Wed, Dec 11, 2024 at 5:46 AM 張宸瑋 wrote: > > In the use of the Credcheck suite, the parameter > "credcheck.max_auth_failure = '3'" is set in the postgresql.

Subscriptions limit for 32cpus and 128gb

2024-12-13 Thread Durgamahesh Manne
Hi Howmany subscriptions that we can create maximum for instance that has 32vcpu and 128gb for managing logical replication Highwork load on 4dbs and rest of 30dbs normal workload Regards Durga Mahesh

Re: Restoring database from backup

2024-12-13 Thread Rich Shepard
On Fri, 13 Dec 2024, Adrian Klaver wrote: Alright, from here: https://www.postgresql.org/docs/current/app-pgdump.html "-c --clean Output commands to DROP all the dumped database objects prior to outputting the commands for creating them. This option is useful when the restore is to overw

Re: Restoring database from backup

2024-12-13 Thread Adrian Klaver
On 12/13/24 11:18 AM, Rich Shepard wrote: On Fri, 13 Dec 2024, Adrian Klaver wrote: This needs more information: 1) Have you backed up your database at the current state? Adrian, No, the current state is FUBAR'd. The cron backup script runs each night at 11:15 p.m. 2) What command did

Re: Restoring database from backup

2024-12-13 Thread Rich Shepard
On Fri, 13 Dec 2024, Rich Shepard wrote: #!/usr/bin/bash The line was separated. Rich

Re: Restoring database from backup

2024-12-13 Thread Rich Shepard
On Fri, 13 Dec 2024, Adrian Klaver wrote: This needs more information: 1) Have you backed up your database at the current state? Adrian, No, the current state is FUBAR'd. The cron backup script runs each night at 11:15 p.m. 2) What command did you use to create bustrac-2024-12-12.sql? !/

Re: Restoring database from backup

2024-12-13 Thread Adrian Klaver
On 12/13/24 11:15 AM, Rich Shepard wrote: On Fri, 13 Dec 2024, Ron Johnson wrote: It's a text file.  Open it up, and see if there's a DROP DATABASE in there. Ron, No `drop database' but it drops constraints and tables. I could add a drop database to the backup script after restoring yeste

Re: Restoring database from backup

2024-12-13 Thread Rich Shepard
On Fri, 13 Dec 2024, Ron Johnson wrote: It's a text file. Open it up, and see if there's a DROP DATABASE in there. Ron, No `drop database' but it drops constraints and tables. I could add a drop database to the backup script after restoring yesterday's status. Thanks, Rich

Re: Restoring database from backup

2024-12-13 Thread Adrian Klaver
On 12/13/24 10:21 AM, Rich Shepard wrote: I made a careless error this morning and want to restore the database from yesterday's backup, `bustrac-2024-12-12.sql'. If I run psql -d bustrac -f bustrac-2024-12-12.sql will this restore the database to yesterday's status without first deleting/re

Restoring database from backup

2024-12-13 Thread Rich Shepard
I made a careless error this morning and want to restore the database from yesterday's backup, `bustrac-2024-12-12.sql'. If I run psql -d bustrac -f bustrac-2024-12-12.sql will this restore the database to yesterday's status without first deleting/removing the FUBAR'd one? TIA, Rich

Re: Errors when restoring backup created by pg_dumpall

2024-12-13 Thread Adrian Klaver
On 12/12/24 22:19, PopeRigby wrote: On 12/10/24 21:22, Adrian Klaver wrote: On 12/10/24 19:05, PopeRigby wrote: If I am following correctly I believe you need this one: https://www.postgresql.org/message-id/attachment/166859/v2-0002-Use-new-style-SQL-function-in-earthdistance-exten.patch I