From: | Philip Semanchuk <philip(at)americanefficient(dot)com> |
---|---|
To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
Cc: | Ian Harding <harding(dot)ian(at)gmail(dot)com>, Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: How different is AWS-RDS postgres? |
Date: | 2021-05-27 13:45:30 |
Message-ID: | AEF79379-0271-4D58-9DB3-2E3EA23348AD@americanefficient.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On May 26, 2021, at 10:04 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>
>
>> On May 26, 2021, at 4:37 PM, Ian Harding <harding(dot)ian(at)gmail(dot)com> 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 smattering of hints to increase wal size!? I have yet to spot anything which corresponds to the “I/O failure” which the middle ware gets.
>
> I don’t have query logging on, but I do see reports from my psql session fat-fingering.
>
> As to the logs UI, the search is pretty feeble; I don’t understand why there are four channels of logs; the graphs are wearing the same rose-coloured as the logs.
> And 24 hours without a peep from AWS support. (I don’t call mailing me what I sent them “contact”.)
>
> My guess right now is that the entire tomcat connection pool is in a single transaction? That’s the only way the tables could disappear. I am making separate calls to JDBC getConnection () for each doPost.
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 find it useful.
Cheers
Philip
Attachment | Content-Type | Size |
---|---|---|
get_aws_logs.py | text/x-python-script | 2.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2021-05-27 15:14:45 | Re: How different is AWS-RDS postgres? |
Previous Message | Rob Sargent | 2021-05-27 02:04:59 | Re: How different is AWS-RDS postgres? |