2016-12-02 17:10 GMT+13:00 Michael Paquier <michael.paqu...@gmail.com<mailto:michael.paqu...@gmail.com>>: On Fri, Dec 2, 2016 at 1:04 PM, Melvin Davidson <melvin6...@gmail.com<mailto:melvin6...@gmail.com>> wrote: > Well, while the location of pg_xlog is not currently configurable, on Linux > system the way to do it is to: > 1. stop PostgreSQL > 2. move the pg_xlog directory to a separate partition > 3. create a symbolic link to point to the new partition > 4. restart PostgreSQL
It’s also worth mentioning that the xlog directory can be specified at cluster creation time using ‘initdb -X <directory>’, which (AFAICT) just creates the symlink for you. Steve. Dr. Steven Winfield Scientist D: +44 (0)1223 755 776 [Cantab email sig]