How can I change the location of the log file in PostgreSQL? Can it be done without stopping the cluster?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
re 1) See the chapter "Where to log" in the manual.
You want to change the
re 2) No, you need to restart Postgres when you change this.