up vote 2 down vote favorite
share [fb]

How can I change the location of the log file in PostgreSQL? Can it be done without stopping the cluster?

link|improve this question

feedback

1 Answer

up vote 9 down vote accepted

re 1) See the chapter "Where to log" in the manual.

http://www.postgresql.org/docs/current/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE

You want to change the log_directory property.

re 2) No, you need to restart Postgres when you change this.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.