could not accept SSL connection: Success

Hi all, We've noticed the following connection error logs recently: sql_error_code = XX000 LOG: could not accept SSL connection: Success We're seeing this on PostgreSQL databases running on Ubuntu Focal 20.04 with different PostgreSQL versions (13.5, 13.4, 12.9, 10.19...). After going thro

How to properly hash a row or set of columns.

Hashing a row or set of columns is useful in some circumstances where you need to compare the row with for instance incoming data. This is most relevant when you do not control the source data yourself, or else you would usually solve it by other means. Still, It would be great if you could do

Re: How to properly hash a row or set of columns.

A minor correction by casting the row a little: create table t ( a text b text hashid varchar not NULL GENERATED ALWAYS AS (sha256(row(a,b)::text::bytea)) stored ) Sent with [ProtonMail](https://protonmail.com/) Secure Email. ‐‐‐ Original Message ‐‐‐ On Tuesday, January 18th, 2022 at 14:

Re: WAL Archiving and base backup

Greetings, * David G. Johnston (david.g.johns...@gmail.com) wrote: > On Fri, Jan 14, 2022 at 11:31 AM Stephen Frost wrote: > > * Issa Gorissen (issa-goris...@usa.net) wrote: > > > Thx a lot. I thought about it but was not so sure about having a complex > > > script (compared to the very simple ve

Re: WAL Archiving and base backup

On Tue, Jan 18, 2022 at 10:53 AM Stephen Frost wrote: > We already have pg_receivewal, which is part of pg_basebackup, and is > able to use a slot and such. I'm not sure that making pg_basebackup > somehow also work as an archive command makes much sense I suppose my proposal should have been:

Re: WAL Archiving and base backup

Greetings, * David G. Johnston (david.g.johns...@gmail.com) wrote: > On Tue, Jan 18, 2022 at 10:53 AM Stephen Frost wrote: > > We already have pg_receivewal, which is part of pg_basebackup, and is > > able to use a slot and such. I'm not sure that making pg_basebackup > > somehow also work as an

Re: could not accept SSL connection: Success

On Mon, Jan 17, 2022 at 05:05:52PM +0100, Carla Iriberri wrote: > I saw previous discussions where different errors were logged with the > "Success" > message and this was corrected/treated as a bug, but I couldn't find similar > reports specific to "could not accept SSL connection". Is this a know

How to schedule running of a script?

Can a script be scheduled to run within Postgres? Regards, David

Re: How to schedule running of a script?

On Tuesday, January 18, 2022, Shaozhong SHI wrote: > Can a script be scheduled to run within Postgres > Core, no. I think there are some extensions you could search for. e.g., pg_cron and pgagent IIRC. David J.