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.
Reminder: Answers generated by AI tools are not allowed due to Database Administrators Stack Exchange's artificial intelligence policy
Required, but never shown
By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.
Start asking to get answers
Find the answer to your question by asking.
Explore related questions
See similar questions with these tags.