Re: How long to get a password reset ???

2021-05-27 Thread Dean Gibson (DB Administrator)
It's pretty simple: 1. Not having used this mailing list for a while, I went to https://lists.postgresql.org/ to make sure my settings were as I wanted them. 2. I attempted to log in with the above eMail address, which is obviously part of this list, since I receive messages to that a

TRUNCATE memory leak with temporary tables?

2021-05-27 Thread Nick Muerdter
I've been seeing what looks like unbounded memory growth (until the OOM killer kicks in and kills the postgres process) when running a pl/pgsql function that performs TRUNCATE statements against various temporary tables in a loop. I think I've been able to come up with some fairly simple reprodu

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Gmail
Not important who does what with whom re Catalina/Tomcat ;) I will indeed re-examine timeouts and such as inserting 100sK record is not instantaneous by any stretch. Tomcat is the new kid on my block as prior to this release I managed a naked port with a Selector and that had no trouble with t

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Sam Gendler
Unless something has changed in recent years, the core servlet engine of tomcat IS catalina. Embedded tomcat is embedded catalina. It looks like the I/O error is a result of attempting to send a query on an already dead connection. I'd look for something that is limiting how long a connection can

Re: How long to get a password reset ???

2021-05-27 Thread Adrian Klaver
On 5/27/21 4:06 PM, Adrian Klaver wrote: On 5/27/21 11:51 AM, Dean Gibson (DB Administrator) wrote: I have a continuous log feed from my mail server, showing that I've received list eMail to the above eMail address, as recently as this morning.  Obviously, eMail is not being blocked at this end

Re: How long to get a password reset ???

2021-05-27 Thread Adrian Klaver
On 5/27/21 11:51 AM, Dean Gibson (DB Administrator) wrote: I have a continuous log feed from my mail server, showing that I've received list eMail to the above eMail address, as recently as this morning.  Obviously, eMail is not being blocked at this end. But no responses to a password reset f

How long to get a password reset ???

2021-05-27 Thread Dean Gibson (DB Administrator)
I have a continuous log feed from my mail server, showing that I've received list eMail to the above eMail address, as recently as this morning.  Obviously, eMail is not being blocked at this end. But no responses to a password reset for the above eMail address. Sincerely, Dean

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Rob Sargent
On 5/27/21 4:25 PM, Sam Gendler wrote: That sure looks like something is causing your connection to have a transaction rollback.  I haven't worked in Java in far too long, but it seems like your connection pool is under the impression your connection was abandoned so it reclaims it and rollback

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Sam Gendler
That sure looks like something is causing your connection to have a transaction rollback. I haven't worked in Java in far too long, but it seems like your connection pool is under the impression your connection was abandoned so it reclaims it and rollback the transaction, which would explain why y

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Rob Sargent
On 5/27/21 4:10 PM, Ron wrote: On 5/27/21 4:58 PM, Rob Sargent wrote: On 5/27/21 3:08 PM, Sam Gendler wrote: The same JDBC connection that is resulting in lost data?  Sounds to me like you aren't connecting to the DB you think you are connecting to. I almost wish that were true. However, lo

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Ron
On 5/27/21 4:58 PM, Rob Sargent wrote: On 5/27/21 3:08 PM, Sam Gendler wrote: The same JDBC connection that is resulting in lost data?  Sounds to me like you aren't connecting to the DB you think you are connecting to. I almost wish that were true. However, looking at AWS "Performance Insigh

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Rob Sargent
On 5/27/21 3:08 PM, Sam Gendler wrote: The same JDBC connection that is resulting in lost data?  Sounds to me like you aren't connecting to the DB you think you are connecting to. I almost wish that were true. However, looking at AWS "Performance Insights" is see the sql statements generate

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Sam Gendler
The same JDBC connection that is resulting in lost data? Sounds to me like you aren't connecting to the DB you think you are connecting to. On Thu, May 27, 2021 at 2:01 PM Rob Sargent wrote: > On 5/27/21 7:45 AM, Philip Semanchuk wrote: > > On May 26, 2021, at 10:04 PM, Rob Sargent > wrote:

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Rob Sargent
On 5/27/21 7:45 AM, Philip Semanchuk wrote: On May 26, 2021, at 10:04 PM, Rob Sargent wrote: On May 26, 2021, at 4:37 PM, Ian Harding wrote:  There is an option to send the logs to cloudwatch which makes it less awful to look at them. I have that but precious little of interest there.

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Rob Sargent
> We used Aurora (AWS hosted Postgres) and I agree that Cloudwatch search is > pretty limited. I wrote a Python script to download cloudwatch logs to my > laptop where I can use proper tools like grep to search them. It’s attached > to this email. It’s hacky but not too terrible. I hope you fi

Re: How different is AWS-RDS postgres?

2021-05-27 Thread Philip Semanchuk
> On May 26, 2021, at 10:04 PM, Rob Sargent wrote: > > > >> On May 26, 2021, at 4:37 PM, Ian Harding wrote: >> >>  >> There is an option to send the logs to cloudwatch which makes it less awful >> to look at them. > I have that but precious little of interest there. Lots of autovac, a >