SQLTerminal.app
now available

XPath.app
now available
Want fresh tech tips in your inbox?

How to Find Postgres Log File and Postgres Data Directory from PSQL

       

If you want to find the location of your log file in Postgres, you'll need to hop into a Psql session..

psql dbname

Then it's as simple as running..

 show data_directory ;

Which will output the data directory, in my case..

/Users/sean/Library/Application Support/Postgres/var-9.5

To see the file name run..

show log_filename ;

There are other useful commands too. You can read more of them here https://www.postgresql.org/docs/9.3/static/runtime-config-logging.html

Tagged w/ #postgres #databases #db #pg #psql #logging

Apps I've Built

XPath Expression Editor
Practice and improve your XPath skills with XPath Editor
Click to buy on the App Store
Photo Location Changer
Easily change the location on your photos and videos
Click here for more info about the app
Photo Date Changer
Easily change the dates and times on your photos and videos
Click here for more info about the app
VocabReminder
English dictionary with notifications so you won't forget what you're studying!
Click here for more info about the app
VocabQuiz
The app that quizzes and scores you on your vocabulary!
Click here for more info about the app