Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work.
Bring the best of human thought and AI automation together at your work. Learn more
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
How can I change the location of the log file in PostgreSQL? Can it be done without stopping the cluster?
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.
log_directory
re 2) No, you need to restart Postgres when you change this.
Start asking to get answers
Find the answer to your question by asking.
Explore related questions
See similar questions with these tags.