On Thu, Dec 1, 2016 at 10:17 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
>Given that the location of pg_xlog is not "configurable"On Thu, Dec 1, 2016 at 5:55 AM, Robert Inder <robert@xxxxxxxxxxxxxxxxx> wrote:I'd really like to read an explicit discussion of this in the official
documentation, rather than just glean what I can from answers to
questions.The official documentation cannot have a dissertation on every combination of hardware, OS, file-system type, version of that file-system, and your usage pattern. That is inherently the realm of the wiki or the blogs.The documentation has enough information at this level of detail that I wouldn't object to adding commentary addressing the above should someone take the time to write it.Given that the location of pg_xlog is not "configurable" placing such commentary in Server Configuration would be a no-go, however. At a quick glance a new section under "Server Setup and Operation - Creating a Database Cluster" would probably be a better home. It already discusses Secondary File Systems and in many ways this is just an extension of that discussion.David J.
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
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
