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

Jim Pistrang jim at jpcr.com
Sun Mar 12 11:05:21 EDT 2017


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>






More information about the omnisdev-en mailing list