Re: Re: could not accept ssl connection tlsv1 alert unknown ca

> Von: Tom Lane > Gesendet: Donnerstag, 30. Januar 2025 18:51 > An: Zwettler Markus (OIZ) > Cc: pgsql-general@lists.postgresql.org > Betreff: [Extern] Re: could not accept ssl connection tlsv1 alert unknown ca > > "Zwettler Markus (OIZ)" writes: > > However, one client also configured some clie

Postgres restore sometimes restores to a point 2 days in the past

I'm running postgres 16.6 My backup strategy is: basebackup and WAL archive. These get uploaded to the cloud. The restore is on an isolated machine and is performed daily. It downloads the basebackup, unpacks it, sets a recovery.signal, and a script is provided as restore_command, to download the

Re: Postgres restore sometimes restores to a point 2 days in the past

On Fri, 2025-01-31 at 10:47 +0100, Koen De Groote wrote: > I'm running postgres 16.6 > > My backup strategy is: basebackup and WAL archive. These get uploaded to the > cloud. > > The restore is on an isolated machine and is performed daily. It downloads the > basebackup, unpacks it, sets a recov

Re: Re: could not accept ssl connection tlsv1 alert unknown ca

> -Ursprüngliche Nachricht- > Von: Adrian Klaver > Gesendet: Freitag, 31. Januar 2025 17:37 > An: Zwettler Markus (OIZ) ; Tom Lane > ; pgsql-general@lists.postgresql.org > Betreff: [Extern] Re: could not accept ssl connection tlsv1 alert unknown ca > > On 1/31/25 00:57, Zwettler Markus (O

Re: could not accept ssl connection tlsv1 alert unknown ca

On 1/31/25 08:57, Zwettler Markus (OIZ) wrote: bash-4.4$ cat pg_hba.conf # Do not edit this file manually! # It will be overwritten by Patroni! local all "postgres" peer hostssl replication "_crunchyrepl" all cert hostssl "postgres" "_crunchyrepl" all cert host all "_crunchyrepl" all reject host

Re: Using psql's \prompt command

On Thu, Jan 30, 2025 at 01:47:59PM -0800, Rich Shepard wrote: > # \i person_view.sql > Enter person_nbr: 468 > psql:person_view.sql:9: ERROR: column "store" does not exist > LINE 3: where person_nbr = store >^ > What's the correct syntax for the \prompt? prompt is ok.

Re: Postgres restore sometimes restores to a point 2 days in the past

On 1/31/25 01:47, Koen De Groote wrote: Comments in line. I'm running postgres 16.6 My backup strategy is: basebackup and WAL archive. These get uploaded to the cloud. The restore is on an isolated machine and is performed daily. It downloads the basebackup, unpacks it, sets a recovery.sig

Re: could not accept ssl connection tlsv1 alert unknown ca

On 1/31/25 00:57, Zwettler Markus (OIZ) wrote: Von: Tom Lane Those cause some additional checks to be made, but it's not like you can expect a completely broken certificate to work without them. regards, tom lane I don't understand why Postgres does a certificat

Re: Postgres restore sometimes restores to a point 2 days in the past

No, it's meant to be an off-site restore, as to do a daily check if the restore actually works. Regards, Koen De Groote On Fri, Jan 31, 2025 at 2:30 PM Laurenz Albe wrote: > On Fri, 2025-01-31 at 10:47 +0100, Koen De Groote wrote: > > I'm running postgres 16.6 > > > > My backup strategy is: bas

Re: Postgres restore sometimes restores to a point 2 days in the past

Any advice on a different mailing list that something like this would be more suited to? Regards, Koen De Groote On Fri, Jan 31, 2025 at 8:38 PM Koen De Groote wrote: > No, it's meant to be an off-site restore, as to do a daily check if the > restore actually works. > > Regards, > Koen De Groot

Re: Postgres restore sometimes restores to a point 2 days in the past

> What is the complete pg_basebackup command? The command: pg_basebackup -h -p -U -D -Ft -z -P -v --wal-method=none So basically the same as the 2nd example here: https://www.postgresql.org/docs/16/app-pgbasebackup.html except for the verbose flag and the wal-method flag. The wal-method is n

Re: Postgres restore sometimes restores to a point 2 days in the past

On 1/31/25 12:10, Koen De Groote wrote: > What is the complete pg_basebackup command? 2/ All my WAL files are archived and uploaded to the cloud. So, I can just have them downloaded. I should have asked earlier what is the archive command? Are > What is determining that a particular WAL

Re: Postgres restore sometimes restores to a point 2 days in the past

> I should have asked earlier what is the archive command The example from the documentation, but with GZIP. So from the documentation: https://www.postgresql.org/docs/16/continuous-archiving.html#BACKUP-ARCHIVING-WAL Which becomes this: archive_command = 'test ! -f /mnt/server/archivedir/%f.gz &

Re: Postgres restore sometimes restores to a point 2 days in the past

On 1/31/25 13:52, Koen De Groote wrote: > I should have asked earlier what is the archive command The example from the documentation, but with GZIP. So from the documentation: https://www.postgresql.org/docs/16/continuous-archiving.html#BACKUP-ARCHIVING-WAL