Log Monitoring with PG Admin

Started by Alex Magnumabout 10 years ago2 messagesgeneral
Jump to latest
#1Alex Magnum
magnum11200@gmail.com

Hi,
i am running and RDS instance on AWS but monitoring logs is a bit
cumbersome.
Is there a way to do the through pgadmin3 ? Like tailing the logfile?

Does anyone know when 9.5 will be available on aws?

Thanks
Alex

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: Alex Magnum (#1)
Re: Log Monitoring with PG Admin

On Wed, Feb 17, 2016 at 9:05 AM, Alex Magnum <magnum11200@gmail.com> wrote:

Hi,
i am running and RDS instance on AWS but monitoring logs is a bit
cumbersome.
Is there a way to do the through pgadmin3 ? Like tailing the logfile?

​Only if you are capable of doing something like this on RDS:​

http://www.postgresql.org/docs/9.4/static/file-fdw.html​

​(in theory a plain SQL COPY command could work here but I'm not sure how
that plays in reality)​

​Otherwise​ pgAdmin3 is like any other piece of client software that talks
to the server using SQL. It doesn't get any special access to the server's
environment including its filesystem and thus logs. The above would
pre-suppose that RDS PostgreSQL even keeps its logs in a flat file directly
accessible by PostgreSQL.

David J.