Re: could not accept SSL connection: Success

2022-01-19 Thread Michael Paquier
On Wed, Jan 19, 2022 at 08:06:30PM -0500, Tom Lane wrote: > Michael Paquier writes: > > Leaving things in their current state is fine by me. Would it be > > better to add a note about the business with 3.0 though? > > What do you envision saying? "We don't need to do anything here > for 3.0" do

Re: could not accept SSL connection: Success

2022-01-19 Thread Tom Lane
Michael Paquier writes: > Leaving things in their current state is fine by me. Would it be > better to add a note about the business with 3.0 though? What do you envision saying? "We don't need to do anything here for 3.0" doesn't seem helpful. regards, tom lane

Re: could not accept SSL connection: Success

2022-01-19 Thread Michael Paquier
On Wed, Jan 19, 2022 at 07:58:43PM -0500, Tom Lane wrote: > Personally I'm satisfied to leave it as-is, since this issue apparently > occurs only in a minority of OpenSSL versions, and not the newest. Leaving things in their current state is fine by me. Would it be better to add a note about the

Re: could not accept SSL connection: Success

2022-01-19 Thread Tom Lane
Michael Paquier writes: > I don't think that it makes much sense to leave this unchecked as the > message is confusing as it stands. Perhaps we could do something like > the attached by adding a note about OpenSSL 3.0 to revisit this code > once we unplug support for 1.1.1 and avoiding the errno=

Re: could not accept SSL connection: Success

2022-01-19 Thread Michael Paquier
On Thu, Jan 20, 2022 at 09:05:35AM +1300, Thomas Munro wrote: > Good news, I'm glad they nailed that down. I recall that this > behaviour was a bit of a moving target in earlier versions: > > https://www.postgresql.org/message-id/CAEepm%3D3cc5wYv%3DX4Nzy7VOUkdHBiJs9bpLzqtqJWxdDUp5DiPQ%40mail.gmai

Re: WAL Archiving and base backup

2022-01-19 Thread Chris Travers
On Fri, Jan 14, 2022 at 8:27 PM Ron wrote: > On 1/14/22 12:31 PM, Stephen Frost wrote: > > Greetings, > > > > * 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 version when using th

Re: could not accept SSL connection: Success

2022-01-19 Thread Thomas Munro
On Thu, Jan 20, 2022 at 12:06 AM Carla Iriberri wrote: > On Wed, Jan 19, 2022 at 5:42 AM Michael Paquier wrote: >> "On an unexpected EOF, versions before OpenSSL 3.0 returned >> SSL_ERROR_SYSCALL, nothing was added to the error stack, and errno was >> 0. Since OpenSSL 3.0 the returned error is SS

Can we get the CTID value

2022-01-19 Thread Garfield Lewis
Hi, I am creating a new type and would like to know if it was possible to access the CTID for the row affected by the INPUT and RECEIVE functions of the new type? Actually, would it be possible from the OUTPUT and SEND functions as well? Regards, Garfield

Re: Slony mailing list activity

2022-01-19 Thread Steve Singer
On Wed, 19 Jan 2022, Tim Kane wrote: I’ve just found the list maintainers address, perhaps that goes somewhere. slony1-general-ow...@lists.slony.info I am overseeing the slony list. Signup requests shouldn't require moderator intervention. I haven't seen any pending requests. Something might

Re: Slony mailing list activity

2022-01-19 Thread Tim Kane
I’ve just found the list maintainers address, perhaps that goes somewhere. slony1-general-ow...@lists.slony.info On Wed, 19 Jan 2022 at 18:50, Tim Kane wrote: > Apologies for posting here, but.. I have attempted to sign up to the Slony > mailing lists and have been waiting over a week to be ap

Slony mailing list activity

2022-01-19 Thread Tim Kane
Apologies for posting here, but.. I have attempted to sign up to the Slony mailing lists and have been waiting over a week to be approved. I’m suspicious that the mailing list functionality there is broken, perhaps? Or the moderator is MIA. When attempting to sign up, the following is displayed:

Re: Connecting Postgresql to Google Sheets

2022-01-19 Thread David G. Johnston
On Wed, Jan 19, 2022 at 6:22 AM Siddharth Golia < siddharth.go...@altlifelab.com> wrote: > I think JDBC Doesn't support PostgreSQL. Is there any alternative on how > we can import data to google sheets? > It seems a bit ironic that searching on Google for "jdbc postgresql" turns up a driver as th

Re: Connecting Postgresql to Google Sheets

2022-01-19 Thread Ron
On 1/19/22 7:56 AM, Matthias Apitz wrote: El día Mittwoch, Januar 19, 2022 a las 11:24:26 +, Siddharth Golia escribió: Hi, I am trying to get data from PostgreSQL to Google sheets but I am unable to do the same. Google script allows connecting using JDBC Service - https://developers.goog

Re: Connecting Postgresql to Google Sheets

2022-01-19 Thread Matthias Apitz
El día Mittwoch, Januar 19, 2022 a las 11:24:26 +, Siddharth Golia escribió: > Hi, > > I am trying to get data from PostgreSQL to Google sheets but I am unable to > do the same. Google script allows connecting using JDBC Service - > https://developers.google.com/apps-script/reference/jdbc/j

Connecting Postgresql to Google Sheets

2022-01-19 Thread Siddharth Golia
Hi, I am trying to get data from PostgreSQL to Google sheets but I am unable to do the same. Google script allows connecting using JDBC Service - https://developers.google.com/apps-script/reference/jdbc/jdbc#getcloudsqlconnectionurl. I think JDBC Doesn't support PostgreSQL. Is there any alterna

Re: could not accept SSL connection: Success

2022-01-19 Thread Carla Iriberri
Thanks, Michael, that's it, indeed! I had missed that part of the OpenSSL docs. These PG instances are running on Ubuntu Focal hosts that come with OpenSSL 1.1.1. We had never seen these in the previous Xenial images because those were using OpenSSL 1.0.2, and from what I've seen the bug was intro

Re: How to schedule running of a script?

2022-01-19 Thread hubert depesz lubaczewski
On Wed, Jan 19, 2022 at 05:10:29AM +, Shaozhong SHI wrote: > Can a script be scheduled to run within Postgres? https://www.depesz.com/2021/01/15/how-to-run-some-tasks-without-user-intervention-at-specific-times/ https://www.depesz.com/2021/01/28/how-to-run-some-tasks-without-user-intervention-