Password reset link / 'less' does not exit in psql version 13.4

2022-07-25 Thread Michael J. Baars
Hello, I have two very simple questions: 1) I have an account at postgresql.org, but a link to a 'forgot password' seems to be missing on the login page. I have my password stored only on an old Fedora 32 computer. To change the password when logged in, you need to supply the old password. In s

Re: SSL compression

2021-11-08 Thread Michael J. Baars
On Mon, 2021-11-08 at 10:20 +0100, Magnus Hagander wrote: > On Mon, Nov 8, 2021 at 10:11 AM Michael J. Baars > wrote: > > On Mon, 2021-11-08 at 13:30 +0530, Abhijit Menon-Sen wrote: > > > > > At 2021-11-08 08:41:42 +0100, mjbaars1977.pgsql.hack...@gmail.com wrote:

Re: SSL compression

2021-11-08 Thread Michael J. Baars
On Mon, 2021-11-08 at 13:30 +0530, Abhijit Menon-Sen wrote: > At 2021-11-08 08:41:42 +0100, mjbaars1977.pgsql.hack...@gmail.com wrote: > > Could someone please explain to me, why compression is being > > considered unsafe / insecure? > > https://en.wikipedia.org/wiki/CRIME > Well Abhijit, person

SSL compression

2021-11-07 Thread Michael J. Baars
Hi All, While I was searching for methods to send the result of a query to the other side of the world, because it might be nice to go there once in a while, I noticed my best option, SSL compression, has been disabled as of version 14. Could someone please explain to me, why compression is bei

Re: Postgresql network transmission overhead

2021-02-25 Thread Michael J. Baars
On Wed, 2021-02-24 at 19:18 -0600, Justin Pryzby wrote: > On Wed, Feb 24, 2021 at 09:14:19AM +0100, Michael J. Baars wrote: > > I've written this function to insert several rows at once, and noticed a > > certain postgresql overhead as you can see from the log file. A lot

Postgresql network transmission overhead

2021-02-24 Thread Michael J. Baars
Hi, I've written this function to insert several rows at once, and noticed a certain postgresql overhead as you can see from the log file. A lot more data than the user data is actually sent over the net. This has a certain noticeable impact on the user transmission speed. I noticed that a lib

Re: computing dT from an interval

2021-02-23 Thread Michael J. Baars
On Mon, 2021-02-22 at 10:52 -0500, Tom Lane wrote: > "Michael J. Baars" writes: > > So how do you compute the number of seconds in 8 years? > > IMO, that's a meaningless computation, because the answer is not fixed. > Before you claim otherwise, think about th

Re: computing dT from an interval

2021-02-22 Thread Michael J. Baars
On Sat, 2021-02-20 at 11:20 -0500, Tom Lane wrote: > "Michael J. Baars" writes: > > Can someone please tell me which of these two queries gives the correct > > result and which one the incorrect? > > // 2.922 (&) > > with A1 as ( select make_inte

computing dT from an interval

2021-02-20 Thread Michael J. Baars
Hi, Can someone please tell me which of these two queries gives the correct result and which one the incorrect? /* * * * * dT in days for 1000 samples */ // 2.922 (&) with A1 as ( select make_interval (0, 0, 0, 0, 0, 0, ( extract ( epoch from interval '8 years' ) / 1000 ) ) as "00"