!Omnis: hoping for some Postgres hints on logs and logging

[David Blaymires]

Hi Jim,

pgAdmin gives you access to the main postgreSQL log so long as you are logging into the server as the postgres user or a superuser.  Select the postgres database (just so you are definitely connected to the server), then under the Tools menu, select Server status.  This will show you the current log, who is connected to the db, what processes are being run and a bunch of other things.

If you configure postgresql.conf, you can change the amount of information that is being tracked in the log, including the application that is connecting, the IP, user details etc.  It’s all contained in the help pages.

Hope you’re having fun!

- - 
Regards,
David Blaymires
david_blaymires at mac.com

M: 0416 183848

> On 13 Mar 2017, at 2:05 am, Jim Pistrang <jim at jpcr.com> wrote:
> 
> Hey Postgres wizards:
> 
> I have PostgreSQL 9.5 installed on OS X 10.12.3.  I have tried to educate myself online, but I am totally mystified on how to view the postgres log files.  Ideally I would like to open log files in a text editor or spreadsheet so I can search, etc.  I particularly want to see..
>  if any unwanted locking is happening
>  any sql errors that might be encountered
>  speed of select and fetch statements
> 
> I've seen references to logs residing in /Library/PostgreSQL/9.5/data but the /data folder is locked and I don't have access to it.
> 
> Can anyone offer any guidance here?
> 
> Thanks,
> 
> Jim
> 
> -- 
> Jim Pistrang
> JP Computer Resources
> 413-256-4569
> <http://www.jpcr.com>
> 
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com