Re: Hello - About how to install PgAdmin4 on Debian 10

On 3/26/21 1:21 PM, Benedict Holland wrote: Install docker and pull dpage/pgadmin4. Seriously. It just works. All of the time, every time, with updates. Docker is amazing. Or better yet use psql. No containers and greater productivity. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Hello - About how to install PgAdmin4 on Debian 10

Install docker and pull dpage/pgadmin4. Seriously. It just works. All of the time, every time, with updates. Docker is amazing. On Fri, Mar 26, 2021, 2:55 PM Adrian Klaver wrote: > On 3/26/21 11:00 AM, Carlos Montenegro wrote: > > Hello Adrian. > > First I installed postgresql version 12.6 then

Re: Hello - About how to install PgAdmin4 on Debian 10

On 3/26/21 11:00 AM, Carlos Montenegro wrote: Hello Adrian. First I installed postgresql version 12.6 then for pgadmin4 followed this guide: https://www.pgadmin.org/download/pgadmin-4-apt/ There are three choices in the above as to what mode t

PostgreSQL Users: Take the State of PostgreSQL 2021 Survey

My apologies if this is not the right forum, but I saw other posts about surveys in this mailing list. The purpose of this survey is to gain insight into how developers across the globe use PostgreSQL to build great things. By sharing your responses, you are helping to create a knowledge base, wh

Re: i := t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value

On Fri, Mar 26, 2021 at 1:21 PM Bryn Llewellyn wrote: > Given these, where the timestamptz values span the start of US/Pacific DST: > t0 timestamptz := ...; > t1 timestamptz := ...; > i_by_subtraction interval second := t1 - t0; > then this expression tests FALSE: > t0 + i_by_subtraction i

Re: i := t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value

Bryn Llewellyn writes: > There's more. We see that while the two "interval second” values '1 day > 01:00:00' and '25 hours' test as equal, the results of adding each to the > same timestamptz value are different. You're misunderstanding how it works. The whole point of these operations is that

i := t1 - t0 but t0 + i <> t1 when t1 and t2 timestamptz values and i is an interval value

Given these, where the timestamptz values span the start of US/Pacific DST: t0 timestamptz := ...; t1 timestamptz := ...; i_by_subtraction interval second := t1 - t0; then this expression tests FALSE: t0 + i_by_subtraction i = t1 There's more. We see that while the two "interval second”

Re: Hello - About how to install PgAdmin4 on Debian 10

Hello dear Adrian and Ray. Good day ! Thank you both for helping me. It has worked and have installed pgadmin4, but have this issue when try to open the server: pgAdmin4 server could not be contacted Any suggestions? Best On Wed, Mar 24, 2021 at 4:10 PM Adrian Klaver wrote: > On 3/24/21 1:17

Re: About CVE-2018-1058

"Mahongwei (March, ICSL)" writes: > Hi > > > > From this blog: > https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058%3A_Protect_Your_Search_Path > > > > Do you think that this is just a mitigation, not a real fix, is there any > plan to fix it? > I would argue that many possible vu