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

2021-03-30 Thread Adrian Klaver
On 3/30/21 10:31 AM, Bryn Llewellyn wrote: adrian.kla...@aklaver.com wrote: The point is horology is cultural, see non-Western calendars and alternate time keeping methods. Trying to maintain a distinction between the two concepts only furthers the confusion. The inconsistencies you see are th

Re: Upgrading from 11 to 13

2021-03-30 Thread Adrian Klaver
On 3/30/21 10:51 AM, Ron wrote: On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote: On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: Hi, Le mar. 30 mars 2021 à 16:10, Susan Joseph a écrit :   I am currently using PostgreSQL 11.2 and would like to try and upgrade it   

Re: Debugging leaking memory in Postgresql 13.2/Postgis 3.1

2021-03-30 Thread Tom Lane
Stephan Knauss writes: > The wiki suggested to dump MemoryContext states for more details, but > something strange happens when attaching gdb. It seems that the process > is immediately killed and I can no longer dump such details. You might try running the postmaster under a restrictive ulimit

Debugging leaking memory in Postgresql 13.2/Postgis 3.1

2021-03-30 Thread Stephan Knauss
Hello, I have a setup in which I have constantly 8 connections to the database open which query data for map rendering. The query involve only a hand full of tables, but could be complex and use postgis functions. The connection stays open. Only read-requests are happening, no update/insert/

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 12:51:50PM -0500, Ron wrote: > On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote: > > > On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: > > > > Hi, > > > > > > > > Le mar. 30 mars 2021 à 16:10, Susan Joseph a > > > > écrit : > > > > > > > > I am

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

2021-03-30 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > > The point is horology is cultural, see non-Western calendars and alternate > time keeping methods. Trying to maintain a distinction between the two > concepts only furthers the confusion. The inconsistencies you see are the > result of one(culture) interve

Re: Upgrading from 11 to 13

2021-03-30 Thread Ron
On 3/30/21 9:53 AM, Daniel Westermann (DWE) wrote: On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: Hi, Le mar. 30 mars 2021 à 16:10, Susan Joseph a écrit : I am currently using PostgreSQL 11.2 and would like to try and upgrade it to the latest version 13.  Can I

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 03:25:06PM +, Daniel Westermann (DWE) wrote: > >On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote: > >> On 3/30/21 8:06 AM, Bruce Momjian wrote: > >> > What other software needs to upgrade through all intermediate versions? > >> > >> Many variations of OS'es

Re: Upgrading from 11 to 13

2021-03-30 Thread David G. Johnston
On Tue, Mar 30, 2021 at 8:25 AM Daniel Westermann (DWE) < daniel.westerm...@dbi-services.com> wrote: > >On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote: > >> On 3/30/21 8:06 AM, Bruce Momjian wrote: > >> > What other software needs to upgrade through all intermediate > versions? > >>

Re: Upgrading from 11 to 13

2021-03-30 Thread Daniel Westermann (DWE)
>On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote: >> On 3/30/21 8:06 AM, Bruce Momjian wrote: >> > What other software needs to upgrade through all intermediate versions? >> >> Many variations of OS'es, though not all. One of the benefits of Ubuntu is >> that you can jump from x.LTS

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 08:10:08AM -0700, Adrian Klaver wrote: > On 3/30/21 8:06 AM, Bruce Momjian wrote: > > What other software needs to upgrade through all intermediate versions? > > Many variations of OS'es, though not all. One of the benefits of Ubuntu is > that you can jump from x.LTS to y.L

Re: Upgrading from 11 to 13

2021-03-30 Thread Adrian Klaver
On 3/30/21 8:06 AM, Bruce Momjian wrote: On Tue, Mar 30, 2021 at 02:53:10PM +, Daniel Westermann (DWE) wrote: On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: Hi, Le mar. 30 mars 2021 à 16:10, Susan Joseph a écrit : I am currently using PostgreSQL 11.2 and would

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

2021-03-30 Thread Adrian Klaver
On 3/29/21 2:48 PM, Bryn Llewellyn wrote: On 27-Mar-2021, at 01:42, Francisco Olarte wrote: Bryn, ( 1st, sorry if I misquote something, but i use text-only for the list )... Thanks again, Francisco. You said several things that clarify my understanding. Re your comment: I've never tried t

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 02:53:10PM +, Daniel Westermann (DWE) wrote: > > >On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: > >> Hi, > >> > >> Le mar. 30 mars 2021 à 16:10, Susan Joseph a > >> écrit : > >> > >> I am currently using PostgreSQL 11.2 and would like to try

Re: Upgrading from 11 to 13

2021-03-30 Thread Daniel Westermann (DWE)
>On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: >> Hi, >> >> Le mar. 30 mars 2021 à 16:10, Susan Joseph a écrit  >> : >> >> I am currently using PostgreSQL 11.2 and would like to try and upgrade it >> to the latest version 13.  Can I go straight from 11 to 13 or do I

Re: Upgrading from 11 to 13

2021-03-30 Thread Adrian Klaver
On 3/30/21 7:09 AM, Susan Joseph wrote: I am currently using PostgreSQL 11.2 and would like to try and upgrade it to the latest version 13.  Can I go straight from 11 to 13 or do I need to upgrade to 12 first and then to 13? You can do this using either dump/restore or pg_upgrade. The importan

Re: Upgrading from 11 to 13

2021-03-30 Thread Bruce Momjian
On Tue, Mar 30, 2021 at 04:34:34PM +0200, Guillaume Lelarge wrote: > Hi, > > Le mar. 30 mars 2021 à 16:10, Susan Joseph a écrit : > > I am currently using PostgreSQL 11.2 and would like to try and upgrade it > to the latest version 13.  Can I go straight from 11 to 13 or do I need to >

Re: Upgrading from 11 to 13

2021-03-30 Thread Guillaume Lelarge
Hi, Le mar. 30 mars 2021 à 16:10, Susan Joseph a écrit : > I am currently using PostgreSQL 11.2 and would like to try and upgrade it > to the latest version 13. Can I go straight from 11 to 13 or do I need to > upgrade to 12 first and then to 13? > You can go straight to 13. Regards.

Upgrading from 11 to 13

2021-03-30 Thread Susan Joseph
I am currently using PostgreSQL 11.2 and would like to try and upgrade it to the latest version 13.  Can I go straight from 11 to 13 or do I need to upgrade to 12 first and then to 13? Thanks, Susan

Re: Dangerous Naming Confusion

2021-03-30 Thread Don Seiler
On Mon, Mar 29, 2021 at 5:22 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Mar 29, 2021 at 3:20 PM Adrian Klaver > wrote: > >> On 3/29/21 3:00 PM, Don Seiler wrote: >> > >> > I'm wondering if this is expected behavior that PG uses the >> > dts_orders.order_id value in the su

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

2021-03-30 Thread Bryn Llewellyn
> On 27-Mar-2021, at 09:16, Adrian Klaver wrote: > > … Re Adrian’s quote of the doc thus: > Also, field values “to the right” of the least significant field allowed by > the fields specification are silently discarded. Yes, I do take this point. But there’s some murkiness here. All of my test

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

2021-03-30 Thread Bryn Llewellyn
> On 27-Mar-2021, at 01:42, Francisco Olarte wrote: > > Bryn, ( 1st, sorry if I misquote something, but i use text-only for the list > )... Thanks again, Francisco. You said several things that clarify my understanding. Re your comment: > I've never tried to make some thing as complex as what