Re: could not receive data from client: Connection reset by peer

2021-04-07 Thread Tom Lane
Jagmohan Kaintura writes: > We are receiving alot of below error messages in the postgresql logs. It looks very much like something in your network infrastructure is dropping connections after 1 hour. The consistent length-of-connection log reports are hard to explain any other way. Check firew

could not receive data from client: Connection reset by peer

2021-04-07 Thread Jagmohan Kaintura
Hi Team, We are receiving alot of below error messages in the postgresql logs. These all connections are being created and released by the applications attached to the database. Please help how these failures can be identified and what all steps need to be taken for further analysis. 2021-04-08

Re: Primary keys and composite unique keys(basic question)

2021-04-07 Thread Ron
On 4/7/21 1:16 PM, Rob Sargent wrote: On 4/7/21 11:59 AM, Ron wrote: On 4/7/21 11:35 AM, Rob Sargent wrote: On Apr 7, 2021, at 10:17 AM, Ron wrote:  On 4/5/21 9:37 PM, Rob Sargent wrote: It's a small thing, but UUIDs are absolutely not memorizable by humans; they have zero semantic value.

Re: Primary keys and composite unique keys(basic question)

2021-04-07 Thread Rob Sargent
On 4/7/21 11:59 AM, Ron wrote: On 4/7/21 11:35 AM, Rob Sargent wrote: On Apr 7, 2021, at 10:17 AM, Ron wrote:  On 4/5/21 9:37 PM, Rob Sargent wrote: It's a small thing, but UUIDs are absolutely not memorizable by humans; they have zero semantic value.  Sequential numeric identifiers are ge

Re: Primary keys and composite unique keys(basic question)

2021-04-07 Thread Ron
On 4/7/21 11:35 AM, Rob Sargent wrote: On Apr 7, 2021, at 10:17 AM, Ron wrote:  On 4/5/21 9:37 PM, Rob Sargent wrote: It's a small thing, but UUIDs are absolutely not memorizable by humans; they have zero semantic value.  Sequential numeric identifiers are generally easier to transpose and

Re: Primary keys and composite unique keys(basic question)

2021-04-07 Thread Rob Sargent
> On Apr 7, 2021, at 10:17 AM, Ron wrote: > >  On 4/5/21 9:37 PM, Rob Sargent wrote: >>> It's a small thing, but UUIDs are absolutely not memorizable by >>> humans; they have zero semantic value. Sequential numeric identifiers >>> are generally easier to transpose and the value gives some clu

Re: Primary keys and composite unique keys(basic question)

2021-04-07 Thread Ron
On 4/5/21 9:37 PM, Rob Sargent wrote: It's a small thing, but UUIDs are absolutely not memorizable by humans; they have zero semantic value.  Sequential numeric identifiers are generally easier to transpose and the value gives some clues to its age (of course, in security contexts this can be a d

Re: PostgreSQL log query's result size

2021-04-07 Thread Peter J. Holzer
On 2021-04-07 09:53:11 -0500, Hellmuth Vargas wrote: > Could you tell me if it is possible that in addition to the > configuration that the log presents the duration of the delayed > queries, it can also present the size of the result data? Not that I know of. > especially those who want to retur

PostgreSQL log query's result size

2021-04-07 Thread Hellmuth Vargas
Excuse me in advance for my English, I'm improving :-) Could you tell me if it is possible that in addition to the configuration that the log presents the duration of the delayed queries, it can also present the size of the result data? especially those who want to return a lot of information. My

Re: Using indexes through a plpgsql procedure

2021-04-07 Thread Peter J. Holzer
On 2021-04-07 12:15:37 +0100, Ciaran Doherty wrote: > As a quick question. Can Postgres make use of indexes on a table when the data > from that table is being returned from a procedure? > > Some more details. I have a big table which has a long running query running > on > it. This table gets re

Re: Cascade publication with pg_stat_replication empty

2021-04-07 Thread Laurenz Albe
On Wed, 2021-04-07 at 04:16 -0700, PegoraroF10 wrote: > I have a server which replicates using Publication/Subscription. On > subscriber server I have some ETL processes running on it and from this > second server I´ve created a new publication to send this database to a > third server. While this

Cascade publication with pg_stat_replication empty

2021-04-07 Thread PegoraroF10
I have a server which replicates using Publication/Subscription. On subscriber server I have some ETL processes running on it and from this second server I´ve created a new publication to send this database to a third server. While this second server was copying data with COPY to third, everything

Using indexes through a plpgsql procedure

2021-04-07 Thread Ciaran Doherty
Hello, Thank you for taking the time to read this. As a quick question. Can Postgres make use of indexes on a table when the data from that table is being returned from a procedure? Some more details. I have a big table which has a long running query running on it. This table gets rebuilt from

RE: Upgrade from 11.3 to 13.1 failed with out of memory

2021-04-07 Thread Mihalidesová Jana
Open Hi, Thanks a lot for information. Best regards, Jana -Original Message- From: Magnus Hagander Sent: Tuesday, April 6, 2021 3:23 PM To: Mihalidesová Jana Cc: pgsql-general@lists.postgresql.org Subject: Re: Upgrade from 11.3 to 13.1 failed with out of memory On Tue, Apr 6, 2021

RE: Open source licenses

2021-04-07 Thread DAVID Nicolas
Yes sure. I also did it ... without answer. But my initial question concerned only the open source components linked to the PostgreSQL server that are not under the PostgreSQL license( ex: openssl, libcharset, ...). Regarding the other modules added by EDB, I will ask again to EDB. Best regards,

Re: Open source licenses

2021-04-07 Thread Laurenz Albe
On Wed, 2021-04-07 at 06:41 +, DAVID Nicolas wrote: > > > It is to make an inventory of all the used opensource licenses from > > > all the used components, to check and respect the terms of use, to > > > preserve copyrights and intellectual property. > > > > > > However, when I get PostgreS