!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