Re: Pgbackrest failure for INCR and DIFF but not FULL backup

On Wed, May 7, 2025 at 6:46 PM Greg Sabino Mullane wrote: > On Wed, May 7, 2025 at 7:15 AM KK CHN wrote: > >> *archive_command = 'pgbackrest --stanza=My_Repo archive-push %p && cp %p >> /data/archive/%f' * >> > > Don't do this. You are archiving twice, and worse, the first part is using > async

Re: Pgbackrest failure for INCR and DIFF but not FULL backup

On Wed, May 7, 2025 at 7:15 AM KK CHN wrote: > *archive_command = 'pgbackrest --stanza=My_Repo archive-push %p && cp %p > /data/archive/%f' * > Don't do this. You are archiving twice, and worse, the first part is using async archiving. Remove that whole "cp" part. Once that is fixed, run: pgbac

Pgbackrest failure for INCR and DIFF but not FULL backup

Hi folks, I am facing a strange issue, Pgbackrest backup fails for DIFF or INCR backups but not Full backup, with the * error WAL file cannot be archived before 6 ms timeout.* The pgbackrest " *stanza check* " command *sometimes succeeds, but sometimes fails.* I don't kno

Re: Pgbackrest : Resumable backup of same type exists

Thanks for the helpful hints. The backup finished successfully : 20250425-115723F timestamp start/stop: 2025-05-01 09:31:36+05:30 / 2025-05-01 14:13:08+ The log doesn't show anything other than (025-05-01 09:30:16.377 P00 WARN: resumable backup 20250425-115723F of same type e

Re: Pgbackrest : Resumable backup of same type exists

Hi Greg, My apologies but the above answer which i gave was not from chatgpt, I had face similar situation in one of our env. Deleting failed backup helped me. To be honest I did use chathpt to paraphrase my sentences before posting in general mail list. Thanks & Regards, Abdul Sayeed On

Re: Pgbackrest : Resumable backup of same type exists

On Thu, May 1, 2025 at 9:08 AM Abdul Sayeed wrote: > Hello, > > This warning message indicates that a *resumable backup*, > (plus lots more ChatGPT crap) Please do not use LLMs to answer questions here. If the original poster wanted that, they could have done it themselves. Furt

Re: Pgbackrest : Resumable backup of same type exists

Hello, This warning message indicates that a *resumable backup*, labeled 20250425-115723F, already exists from a previous attempt. The backup system has detected it and will do the following: - *Remove any invalid or corrupted files* from that existing backup attempt. - *Resume

Pgbackrest : Resumable backup of same type exists

Hi, Due to a backup failure in my Reposerver, the storage disk ran out of space, fixed later. I reschedule the cron job to take a full backup but it show for the last 3 hours 025-05-01 09:30:16.377 P00 WARN: resumable backup 20250425-115723F of same type exists -- invalid files will be

Re: To take backup of Postgresql Database without large objects

On 4/11/25 23:05, David G. Johnston wrote: On Friday, April 11, 2025, Adrian Klaver > wrote: On 4/11/25 22:06, sivapostg...@yahoo.com wrote: Either my command should be wrong or I'm missing something. This w

Re: To take backup of Postgresql Database without large objects

Thanks for the clarification. bytea != large object Happiness Always BKR Sivaprakash On Saturday 12 April, 2025 at 11:36:11 am IST, David G. Johnston wrote: On Friday, April 11, 2025, Adrian Klaver wrote: On 4/11/25 22:06, sivapostg...@yahoo.com wrote: Either my command should be wr

Re: To take backup of Postgresql Database without large objects

On Friday, April 11, 2025, Adrian Klaver wrote: > On 4/11/25 22:06, sivapostg...@yahoo.com wrote: > > Either my command should be wrong or I'm missing something. >> > > This was explained in my post as quoted below. Yeah, the short version. Then you added a long version that just confused the

Re: To take backup of Postgresql Database without large objects

postg...@yahoo.com <mailto:sivapostg...@yahoo.com> wrote: > Hello, > > Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in > Windows 10. > > Trying to take backup of a database, using pg_dump, where one table > contains bytea datatype, which I don

Re: To take backup of Postgresql Database without large objects

> On Apr 11, 2025, at 22:34, sivapostg...@yahoo.com wrote: > Then I've misunderstood large objects. Is there document to explain large > objects? Large objects are a relatively old and now little-used feature of PostgreSQL that predates the bytea type: https://www.postgresql.org/d

Re: To take backup of Postgresql Database without large objects

o.com wrote: bytea field also included in the backup.    Bytea typed columns are completely separate things than large objects.  You cannot exclude individual columns using pg_dump. David J.

Re: To take backup of Postgresql Database without large objects

On Friday, April 11, 2025, sivapostg...@yahoo.com wrote: > > > bytea field also included in the backup. > Bytea typed columns are completely separate things than large objects. You cannot exclude individual columns using pg_dump. David J.

Re: To take backup of Postgresql Database without large objects

ng.I tried with all the other combinations.  NO LUCK. bytea field also included in the backup.    I tried taking backup using pg_dump of version 17 also, with no luck.   [ Database version is 15 and the pg_dump version is 17 ].  Confirming this after restoring the backup file in a new database.

Re: To take backup of Postgresql Database without large objects

On Fri, Apr 11, 2025 at 8:56 AM sivapostg...@yahoo.com < sivapostg...@yahoo.com> wrote: > Hello, > > Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in > Windows 10. > That's 11 patch releases behind current. > Trying to take backup of a datab

Re: To take backup of Postgresql Database without large objects

On 4/11/25 05:55, sivapostg...@yahoo.com wrote: Hello, Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in Windows 10. Trying to take backup of a database, using pg_dump, where one table contains bytea datatype, which I don't want to include in the backup. My comman

Re: To take backup of Postgresql Database without large objects

Hello, Using PostgreSQL 15.1, compiled by Visual C++ build 1914, 64-bit in Windows 10. Trying to take backup of a database, using pg_dump, where one table contains bytea datatype, which I don't want to include in the backup. My command was:"E:\DBBackup\bin\pg_dump.exe"  -h 192.168

Re: How to recover correctly master and replica using backup made by pg_basebackup?

On 07/11/2024 22:19, Evgeniy Ratkov wrote:Hello.I try to use pg_basebackup to make backup and recover master and replicafrom it.I recover master with action "promote". Next, I recover replica from thesamebackup with action "shutdown". After it, I start replica with con

Re: Errors when restoring backup created by pg_dumpall

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: Restoring database from backup

u can specify the option when you call pg_restore. " This means when you run the script with: psql -d bustrac -f bustrac-2024-12-12.sql it will clean out the current corrupted objects and replace them with those in the backup file. Adrian, That's what I thought since I wrote the

Re: Restoring database from backup

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 comman

Re: Restoring database from backup

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

Re: Restoring database from backup

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

Re: Restoring database from backup

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

Re: Restoring database from backup

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

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

Restoring database from backup

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

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

Re: Errors when restoring backup created by pg_dumpall

On 12/10/24 21:22, Adrian Klaver wrote: On 12/10/24 19:05, PopeRigby wrote: On 12/9/24 16:31, Adrian Klaver wrote: On 12/9/24 15:30, PopeRigby wrote: On 12/9/24 15:23, Tom Lane wrote: Adrian Klaver writes: You could file an issue here: https://www.postgresql.org/account/login/?next=/account

Re: Errors when restoring backup created by pg_dumpall

On 12/10/24 19:05, PopeRigby wrote: On 12/9/24 16:31, Adrian Klaver wrote: On 12/9/24 15:30, PopeRigby wrote: On 12/9/24 15:23, Tom Lane wrote: Adrian Klaver writes: You could file an issue here: https://www.postgresql.org/account/login/?next=/account/submitbug/ Ask if the developers could u

Re: Errors when restoring backup created by pg_dumpall

On 12/9/24 16:31, Adrian Klaver wrote: On 12/9/24 15:30, PopeRigby wrote: On 12/9/24 15:23, Tom Lane wrote: Adrian Klaver writes: You could file an issue here: https://www.postgresql.org/account/login/?next=/account/submitbug/ Ask if the developers could use the mechanisms available here: htt

Re: Errors when restoring backup created by pg_dumpall

SELECT pg_catalog.set_config('search_path', 'public', false); What if this had been a pg_dump --format={custom,directory} backup? pg_restore has a mode where it can dump out SQL to a script instead of directly restoring to the database. That Would Be

Re: Errors when restoring backup created by pg_dumpall

erences. >>> >>> For now in the dump file you could search for >>> >>> SELECT pg_catalog.set_config('search_path', '', false); >>> >>> and set to >>> >>> SELECT pg_catalog.set_config('search_path',

Re: Errors when restoring backup created by pg_dumpall

#x27;search_path', '', false); >> >> and set to >> >> SELECT pg_catalog.set_config('search_path', 'public', false); >> > > What if this had been a pg_dump --format={custom,directory} backup? > pg_restore has a mode where it can dump out SQL to a script instead of directly restoring to the database. David J.

Re: Errors when restoring backup created by pg_dumpall

talog.set_config('search_path', 'public', false); > What if this had been a pg_dump --format={custom,directory} backup? -- Death to , and butter sauce. Don't boil me, I'm still alive. lobster!

Re: Errors when restoring backup created by pg_dumpall

On 12/9/24 15:30, PopeRigby wrote: On 12/9/24 15:23, Tom Lane wrote: Adrian Klaver writes: You could file an issue here: https://www.postgresql.org/account/login/?next=/account/submitbug/ Ask if the developers could use the mechanisms available here: https://www.postgresql.org/docs/current/ext

Re: Errors when restoring backup created by pg_dumpall

On 12/9/24 15:23, Tom Lane wrote: Adrian Klaver writes: You could file an issue here: https://www.postgresql.org/account/login/?next=/account/submitbug/ Ask if the developers could use the mechanisms available here: https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSION

Re: Errors when restoring backup created by pg_dumpall

On 12/9/24 15:23, Tom Lane wrote: Adrian Klaver writes: You could file an issue here: https://www.postgresql.org/account/login/?next=/account/submitbug/ Ask if the developers could use the mechanisms available here: https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSION

Re: Errors when restoring backup created by pg_dumpall

Adrian Klaver writes: > You could file an issue here: > https://www.postgresql.org/account/login/?next=/account/submitbug/ > Ask if the developers could use the mechanisms available here: > https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSIONS-RELOCATION This wouldn't r

Re: Errors when restoring backup created by pg_dumpall

On 12/9/24 14:47, Adrian Klaver wrote: On 12/9/24 14:14, PopeRigby wrote: On 12/7/24 11:58, David G. Johnston wrote: On Sat, Dec 7, 2024 at 12:25 PM PopeRigby wrote:     It actually looks like setting those all to have public fixed all the     errors, including the one with lldap. So, how

Re: Errors when restoring backup created by pg_dumpall

On 12/9/24 14:14, PopeRigby wrote: On 12/7/24 11:58, David G. Johnston wrote: On Sat, Dec 7, 2024 at 12:25 PM PopeRigby wrote: It actually looks like setting those all to have public fixed all the errors, including the one with lldap. So, how can I get it to not put public there a

Re: Errors when restoring backup created by pg_dumpall

On 12/9/24 14:31, David G. Johnston wrote: On Mon, Dec 9, 2024 at 3:14 PM PopeRigby wrote: On 12/7/24 11:58, David G. Johnston wrote: On Sat, Dec 7, 2024 at 12:25 PM PopeRigby wrote: It actually looks like setting those all to have public fixed all the er

Re: Errors when restoring backup created by pg_dumpall

On Mon, Dec 9, 2024 at 3:14 PM PopeRigby wrote: > On 12/7/24 11:58, David G. Johnston wrote: > > On Sat, Dec 7, 2024 at 12:25 PM PopeRigby wrote: > >> >> It actually looks like setting those all to have public fixed all the >> errors, including the one with lldap. So, how can I get it to not put

Re: Errors when restoring backup created by pg_dumpall

On 12/7/24 11:58, David G. Johnston wrote: On Sat, Dec 7, 2024 at 12:25 PM PopeRigby wrote: It actually looks like setting those all to have public fixed all the errors, including the one with lldap. So, how can I get it to not put public there automatically for next time? I assu

Re: Errors when restoring backup created by pg_dumpall

On Sat, Dec 7, 2024 at 12:25 PM PopeRigby wrote: > > It actually looks like setting those all to have public fixed all the > errors, including the one with lldap. So, how can I get it to not put > public there automatically for next time? > > I assume you mean "get it to put public there" (i.e.,

Re: Errors when restoring backup created by pg_dumpall

earch_path setting *would* be enough to get you past that. Having said that, the CREATE should have been seeing the new-style definition of ll_to_earth() if the 1.2 version of earthdistance was correctly installed.     regards, tom lane So, is there anything I can do to fix this particu

Re: Errors when restoring backup created by pg_dumpall

On Thursday, December 5, 2024, Ron Johnson wrote: > On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson >> wrote: >> >>> Another alternative is to open the .sql file in Notepad++, then add >>> "public." before al

Re: Errors when restoring backup created by pg_dumpall

On 12/5/24 18:44, Ron Johnson wrote: On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson mailto:ronljohnso...@gmail.com>> wrote: Another alternative is to open the .sql file in Notepad++, then

Re: Errors when restoring backup created by pg_dumpall

On Thu, Dec 5, 2024 at 6:24 PM David G. Johnston wrote: > On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson > wrote: > >> Another alternative is to open the .sql file in Notepad++, then add >> "public." before all the unqualified "earth" and "ll_to_earth" references. >> > > And as discussed there are n

Re: Errors when restoring backup created by pg_dumpall

On Thu, Dec 5, 2024 at 4:04 PM Ron Johnson wrote: > Another alternative is to open the .sql file in Notepad++, then add > "public." before all the unqualified "earth" and "ll_to_earth" references. > And as discussed there are none in that file because those references are within an extension's o

Re: Errors when restoring backup created by pg_dumpall

gt; > search_path setting *would* be enough to get you past that. > > > > Having said that, the CREATE should have been seeing the new-style > > definition of ll_to_earth() if the 1.2 version of earthdistance > > was correctly installed. > > > >

Re: Errors when restoring backup created by pg_dumpall

t you past that. Having said that, the CREATE should have been seeing the new-style definition of ll_to_earth() if the 1.2 version of earthdistance was correctly installed.     regards, tom lane So, is there anything I can do to fix this particular backup? I'm kind of stuck her

Re: Errors when restoring backup created by pg_dumpall

the CREATE should have been seeing the new-style definition of ll_to_earth() if the 1.2 version of earthdistance was correctly installed. regards, tom lane So, is there anything I can do to fix this particular backup? I'm kind of stuck here. There's also the i

Re: Errors when restoring backup created by pg_dumpall

On 12/2/24 17:17, Tom Lane wrote: PopeRigby writes: On 12/1/24 12:15, Tom Lane wrote: Cool. You did actually install the new scripts into your target installation, right? Oh, is applying the patch and rebuilding PostgreSQL not enough? Not unless you did "make install" in the contrib/earthdi

Re: Errors when restoring backup created by pg_dumpall

PopeRigby writes: > On 12/1/24 12:15, Tom Lane wrote: >> Cool. You did actually install the new scripts into your target >> installation, right? > Oh, is applying the patch and rebuilding PostgreSQL not enough? Not unless you did "make install" in the contrib/earthdistance directory (or somethi

Re: Errors when restoring backup created by pg_dumpall

On 12/1/24 12:15, Tom Lane wrote: Cool. You did actually install the new scripts into your target installation, right? Oh, is applying the patch and rebuilding PostgreSQL not enough?

Re: Errors when restoring backup created by pg_dumpall

Adrian Klaver writes: > On 12/1/24 13:14, Tom Lane wrote: >> It would be useful to know what is the command at line 4102 >> of all.sql. > It is here: > https://gist.github.com/poperigby/fcb59eb6c22c6051800e06a0ec482b49 > CREATE TABLE public.geodata_places ( > id integer NOT NULL, > na

Re: Errors when restoring backup created by pg_dumpall

On 12/1/24 13:14, Tom Lane wrote: Adrian Klaver writes: On 12/1/24 12:05, PopeRigby wrote: I'm still getting this error: psql:all.sql:4102: ERROR:  type "earth" does not exist LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth The issue is still this: SELECT pg_catalog

Re: Errors when restoring backup created by pg_dumpall

Adrian Klaver writes: > On 12/1/24 12:05, PopeRigby wrote: >> I'm still getting this error: >> >> psql:all.sql:4102: ERROR:  type "earth" does not exist >> LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth > The issue is still this: > SELECT pg_catalog.set_config('search_pa

Re: Errors when restoring backup created by pg_dumpall

On 12/1/24 12:05, PopeRigby wrote: On 11/30/24 19:58, Tom Lane wrote: "David G. Johnston" writes: Ok, so the error is not emanating from your code but rather the body of the ll_to_earth function defined in the earthdistance extension. Yeah.  That is CREATE FUNCTION ll_to_earth(float8, float

Re: Errors when restoring backup created by pg_dumpall

PopeRigby writes: > I've applied the following patch to postgres: > https://www.postgresql.org/message-id/attachment/122092/0002-earthdistance-sql-functions.patch Cool. You did actually install the new scripts into your target installation, right? > I'm still getting this error: > psql:all.sql:

Re: Errors when restoring backup created by pg_dumpall

On 11/30/24 19:58, Tom Lane wrote: "David G. Johnston" writes: Ok, so the error is not emanating from your code but rather the body of the ll_to_earth function defined in the earthdistance extension. Yeah. That is CREATE FUNCTION ll_to_earth(float8, float8) RETURNS earth LANGUAGE SQL IMMUTAB

Re: Errors when restoring backup created by pg_dumpall

"David G. Johnston" writes: > Ok, so the error is not emanating from your code but rather the body of the > ll_to_earth function defined in the earthdistance extension. Yeah. That is CREATE FUNCTION ll_to_earth(float8, float8) RETURNS earth LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE AS 'SELECT

Re: Errors when restoring backup created by pg_dumpall

On Saturday, November 30, 2024, PopeRigby wrote: > > Ok, so the error is not emanating from your code but rather the body of > the ll_to_earth function defined in the earthdistance extension. > > David J. > > By code do you mean my sql file created by pg_dumpall? Sorry, I'm just a > self-hoster s

Re: Errors when restoring backup created by pg_dumpall

On 11/30/24 19:45, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/30/24 18:41, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/30/24 17:27, David G. Johnston wrote: On Saturday, November 30, 2024, P

Re: Errors when restoring backup created by pg_dumpall

On Saturday, November 30, 2024, PopeRigby wrote: > On 11/30/24 18:41, David G. Johnston wrote: > > On Saturday, November 30, 2024, PopeRigby wrote: > >> On 11/30/24 17:27, David G. Johnston wrote: >> >> On Saturday, November 30, 2024, PopeRigby wrote: >> >>> On 11/29/24 17:47, Adrian Klaver wro

Re: Errors when restoring backup created by pg_dumpall

CREATE EXTENSION cube; I do not know if you might need this one as well. I am assuming that you are working on a gist server. CREATE EXTENSION earthdistance; I am assuming you are working with a gist server. This ought to be useful. https://gist.cs.berkeley.edu/pggist/ You might want to read t

Re: Errors when restoring backup created by pg_dumpall

On 11/30/24 18:41, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/30/24 17:27, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/29/24 17:47, Adrian Klaver wrote: On 11/29/24 17:34, PopeRigby wrot

Re: Errors when restoring backup created by pg_dumpall

On 11/30/24 19:26, PopeRigby wrote: On 11/30/24 18:41, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/30/24 17:27, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/29/24 17:47, Adrian Klaver wrote:

Re: Errors when restoring backup created by pg_dumpall

On 11/30/24 18:41, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/30/24 17:27, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/29/24 17:47, Adrian Klaver wrote: On 11/29/24 17:34, PopeRigby wrot

Re: Errors when restoring backup created by pg_dumpall

On Saturday, November 30, 2024, PopeRigby wrote: > On 11/30/24 17:27, David G. Johnston wrote: > > On Saturday, November 30, 2024, PopeRigby wrote: > >> On 11/29/24 17:47, Adrian Klaver wrote: >> >>> On 11/29/24 17:34, PopeRigby wrote: >>> >>> psql:all.sql:4104: ERROR: type "earth" does not exi

Re: Errors when restoring backup created by pg_dumpall

On 11/30/24 17:27, David G. Johnston wrote: On Saturday, November 30, 2024, PopeRigby wrote: On 11/29/24 17:47, Adrian Klaver wrote: On 11/29/24 17:34, PopeRigby wrote: psql:all.sql:4104: ERROR:  type "earth" does not exist LINE 1: ...ians($1))*sin(radians(

Re: Errors when restoring backup created by pg_dumpall

On Saturday, November 30, 2024, PopeRigby wrote: > On 11/29/24 17:47, Adrian Klaver wrote: > >> On 11/29/24 17:34, PopeRigby wrote: >> >> psql:all.sql:4104: ERROR: type "earth" does not exist >> LINE 1: ...ians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth >> >> QUERY: SELECT cube(cub

Re: Errors when restoring backup created by pg_dumpall

On 11/29/24 17:47, Adrian Klaver wrote: On 11/29/24 17:34, PopeRigby wrote: My HDD recently failed so I'm trying to restore my backup, but I'm running into some errors. I've been using a systemd service that periodically backs up my cluster with pg_dumpall, and I'm u

Re: Errors when restoring backup created by pg_dumpall

On 11/29/24 17:34, PopeRigby wrote: My HDD recently failed so I'm trying to restore my backup, but I'm running into some errors. I've been using a systemd service that periodically backs up my cluster with pg_dumpall, and I'm using this command to restore: sudo psql -f

Re: Errors when restoring backup created by pg_dumpall

On Fri, Nov 29, 2024 at 8:35 PM PopeRigby wrote: > My HDD recently failed so I'm trying to restore my backup, but I'm > running into some errors. > > I've been using a systemd service that periodically backs up my cluster > with pg_dumpall, and I'm using this c

Errors when restoring backup created by pg_dumpall

My HDD recently failed so I'm trying to restore my backup, but I'm running into some errors. I've been using a systemd service that periodically backs up my cluster with pg_dumpall, and I'm using this command to restore: sudo psql -f backup.sql postgres I'm ge

How to recover correctly master and replica using backup made by pg_basebackup?

Hello. I try to use pg_basebackup to make backup and recover master and replica from it. I recover master with action "promote". Next, I recover replica from the same backup with action "shutdown". After it, I start replica with configured connection and replication slot

Re: Backup

Postgres I > > only keep 6 months live on the mssql db and roll everything else to > > Postgres Arch DB. > > > >After I load this latest month to Postgres I just need to backup, or > > should I just retain my .csv files as a Backup... I have 2 tables that I &g

Re: Backup

load this latest month to Postgres I just need to backup, or should I just retain my .csv files as a Backup... I have 2 tables that I load to Hist and one table holds the images... Your choice, though the factors I would consider would be: 1) The process you use to load the CSV files into Postgres a

Re: Backup

I'm using the DB as a History repository... I'm pulling info from a Mssql db using a P/S script to a csv file then Import that to Postgres I only keep 6 months live on the mssql db and roll everything else to Postgres Arch DB. After I load this latest month to Postgres I just need to

Re: Backup

On 10/23/24 07:07, Andy Hartman wrote: I have been testing different backup methods suggested and wonder if I have all my files used to load the DB .. could that be considered a backup... obviously need to have schema backup in case of problem, but that seems to be easily re-created Thoughts

Re: Backup

I have been testing different backup methods suggested and wonder if I have all my files used to load the DB .. could that be considered a backup... obviously need to have schema backup in case of problem, but that seems to be easily re-created Thoughts? On Fri, Oct 18, 2024 at 2:30 PM Adrian

Re: Backup

On 10/18/24 11:25 AM, Andy Hartman wrote: Windows Server 2022 I would like a backup process similar to what I'm used to using in the mssql world if that's  possible with Postgres... I will be loading monthly archive data to Postgresql so that's why I probably only nee

Re: Backup

Windows Server 2022 I would like a backup process similar to what I'm used to using in the mssql world if that's possible with Postgres... I will be loading monthly archive data to Postgresql so that's why I probably only need once a backup .. once loaded data is just viewed th

Re: Backup

On 10/18/24 05:39, Andy Hartman wrote: I would like to use the closest thing to a mssql backup... As in? Searching on 'mssql backup' returns a lot of choices. You will need to be more specific on what you want to achieve. Also be specific about what versions of OS and Postgr

Re: Backup

On 10/18/24 09:52, Andy Hartman wrote: Reply to list also Ccing list. Windows 22 and Postgres 16.4 Is that Windows Server 2022 or Windows 10/11 with the 22H2 update? You also need to provide a more detailed description of what you want the backup to do? On Fri, Oct 18, 2024 at 12

Re: Backup

On 10/18/24 08:34, Andy Hartman wrote: Thanks.. I'm on a Windows platform using PG. AFAIK pgBackRest does not run on Windows: https://github.com/pgbackrest/pgbackrest/issues/2431 -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backup

Thanks.. I'm on a Windows platform using PG. On Fri, Oct 18, 2024 at 10:45 AM Adrian Klaver wrote: > On 10/18/24 05:39, Andy Hartman wrote: > > I would like to use the closest thing to a mssql backup... > > > > How do I install pgbackrest after downloading an

Re: Backup

On 10/18/24 05:39, Andy Hartman wrote: I would like to use the closest thing to a mssql backup... How do I install pgbackrest after downloading  and UnZip? Read the docs?: https://pgbackrest.org/user-guide.html#installation -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backup

I would like to use the closest thing to a mssql backup... How do I install pgbackrest after downloading and UnZip? On Thu, Oct 17, 2024 at 6:28 AM Andy Hartman wrote: > This is great, thank you so much! > > On Thu, Oct 17, 2024 at 12:47 AM Asad Ali wrote: > >> >&g

Re: Backup

ne's multiple CPUs by using parallel jobs: > > pg_dump -Fc -Z 9 -j 4 --blobs -f /path/to/backup/file.dump > your_database_name > >- -Fc: Custom format (supports compression and flexible restore >options). >- -Z 9: Maximum compression level (0-9 scale). >- -j

Re: Backup

on* A more efficient option would be to use the custom format (-Fc) with compression. You can also adjust the compression level and make use of your machine's multiple CPUs by using parallel jobs: pg_dump -Fc -Z 9 -j 4 --blobs -f /path/to/backup/file.dump your_database_name - -Fc: Cus

Re: Backup

Hi, you can refer the following link where many backup methods are mentioned according to your need. Backups in PostgreSQL. In PostgreSQL, different types of… | by Usman Khan | Aug, 2024 | Medium <https://medium.com/@usman.khan9805/backups-in-postgresql-2fca57c2872b> On Thu, 17 Oct 2024

Re: Backup

I'm on Ver16 and yes Our database has image in a bytea field. Running on Win22 box... On Wed, Oct 16, 2024 at 5:49 PM Peter J. Holzer wrote: > On 2024-10-16 16:02:24 -0400, Ron Johnson wrote: > > On Wed, Oct 16, 2024 at 4:00 PM Achilleas Mantzios < > > a.mantz...@cloud.gatewaynet.com> wrote: >

Re: Backup

On 2024-10-16 16:02:24 -0400, Ron Johnson wrote: > On Wed, Oct 16, 2024 at 4:00 PM Achilleas Mantzios < > a.mantz...@cloud.gatewaynet.com> wrote: > Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε: > On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman > wrote: [...] > > Step 1: re

Re: Backup

hing like pg_dump -Fc | gzip -c > compressed.dump.gz However, be aware that pg_dump is more an export tool than a backup suitable for large databases / quick recovery. It won't allow doing PITR and similar stuff. regards -- Adrian Klaver adrian.kla...@aklaver.com

Re: Backup

world. I'm looking for suggestions on DB backups. I currently have a DB used to store Historical information that has images it's currently around 100gig. I'm looking to take a monthly backup as I archive a month of data at a time. I am looki

  1   2   3   4   5   6   >