[dserodio]

In chapter 10: Replication and External Data, page 126, it says:

5. Shut down the postgreSQL service and copy all the files in the data folder EXCEPT for the pg_xlog and pg_log folders to the slaves. You should make sure that pg_xlog and pg_log folders are both present on the slaves, but devoid of any files.

I've checked PostgreSQL 9.1 and 9.2 installations and neither of them have a pg_log folder. PostgreSQL's official documentation, in the 55.1. Database File Layout section doesn't mention pg_log either.

Is this a typo, and should say pg_clog instead of pg_log?

This post has been edited by dserodio: 14 September 2012 - 09:05 AM

[Leo Hsu and Regina Obe]

dserodio, on 14 September 2012 - 08:53 AM, said:

In chapter 10: Replication and External Data, page 126, it says:

5. Shut down the postgreSQL service and copy all the files in the data folder EXCEPT for the pg_xlog and pg_log folders to the slaves. You should make sure that pg_xlog and pg_log folders are both present on the slaves, but devoid of any files.

I've checked PostgreSQL 9.1 and 9.2 installations and neither of them have a pg_log folder. PostgreSQL's official documentation, in the 55.1. Database File Layout section doesn't mention pg_log either.

Is this a typo, and should say pg_clog instead of pg_log?

This is not a typo but we should clarify that it may not always reside in the data cluster and is configurable by the postgresql.conf setting: pg_log


That is the default location and it doesn't always exist. For example it may not exist if you don't have logging enabled.