How to get PostgreSQl log

Question

How can I get log information from PostgreSQl server?

I found ability to watch it in pgAdmin Tolls->ServerStatus. Is there a SQL way, or API, or consol way, to show content of log file(s)?

Thanks.

vyegorov · Accepted Answer · 2012-06-21 09:17:20Z

1

I am command line addict, so I prefer “console” way.

Where you find logs and what will be inside those depends on how you've configured your PostgreSQL cluster. This the first thing I change after creating a new cluster, so that I get all the information I need and in the expected location.

Please, review your $PGDATA/postgresql.conf file for your current settings and adjust them in the appropriate way.

answered Jun 21, 2012 at 9:17

vyegorov

23k7 gold badges61 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Milen A. Radev · Accepted Answer · 2012-06-21 10:39:30Z

0

The adminpack extension is the one providing the useful info behind pgAdmin3's server status functionality.

answered Jun 21, 2012 at 10:39

Milen A. Radev

63.2k22 gold badges111 silver badges112 bronze badges

Collectives™ on Stack Overflow

How to get PostgreSQl log

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related