Re: Correction for the Binary Replication Tutorial

Michael,

> I was following your 5 minutes to Simple Replication tutorial found here
> http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#5_Minutes_to_S
> imple_Replication, and I notice a mistake. 
> 
> In step 3 you state that the recovery.conf should be placed in the same
> directory that the postgres.conf file is located. While the official
> documentation states to put the recovery.conf in your ${PG_DATA}
> directory, which in the case of your tutorial is /var/lib/postgresql/data,
> where as the postgres.conf file lives at /etc/postgres/path/postgres.conf
> . I understand if your setup is different than mine, but you might want to
> make a note of this on the tutorial.

Actually, I *do* make such a note:

"This 6-step guide, and all of the examples in this tutorial, assume
that you have a master server at 192.168.0.1 and a standby server at
192.168.0.2 and that your database and its configuration files are
installed at /var/lib/postgresql/data. Replace those with whatever your
actual server addresses and directories are."

Are you saying that you put recovery.conf in your PGDATA directory and
it didn't work, or that you put it in your PGCONF directory and it
didn't work?

Anyway, the tutorial is on a *wiki*, so you should go there both to make
edits, and to add notes and questions on the [Discussion] page.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com