Thread: Correction for the Binary Replication Tutorial
To it my concern, 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. I tried it the way that you have it in your tutorial and it did not work, the wal receiver process would not start. Thanks ------------------------------------- Michael Smith, Software Test Engineer PC-Doctor, Inc. 9805 Double R Boulevard, Suite 301 Reno, NV 89521 775-336-4097 michael.smith@pc-doctor.com CONFIDENTIALITY The information contained in this message is confidential. It is intended to be read only by the individual or entity to whom it is addressed or by an authorized designee. If the reader of this message is not the intended recipient, be aware that distribution of this message in any form is strictly prohibited. If you have received this message in error, please immediately notify the sender and destroy any copy of this message.
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
On Sat, Jan 15, 2011 at 5:28 PM, Josh Berkus <josh@agliodbs.com> wrote: > 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? I got the impression he's using a data_directory setting which doesn't point back at the directory containing postgresql.conf? > 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. Does anyone keep an eye on the Discussion pages? Make changes, sure, but I bet editing a talk page is a good way to get ignored for all time. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Mon, Jan 17, 2011 at 03:00, Robert Haas <robertmhaas@gmail.com> wrote: > On Sat, Jan 15, 2011 at 5:28 PM, Josh Berkus <josh@agliodbs.com> wrote: >> 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? > > I got the impression he's using a data_directory setting which doesn't > point back at the directory containing postgresql.conf? Sounds like a debian/ubuntu box to me. >> 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. > > Does anyone keep an eye on the Discussion pages? Make changes, sure, > but I bet editing a talk page is a good way to get ignored for all > time. I've certainly never done it, but I'm no wiki-black-belt :-) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
It is indeed an Ubuntu box, I was just concern that those people reading your wiki and trying it on an Ubuntu box might be interest in my findings. -----Original Message----- From: Magnus Hagander [mailto:magnus@hagander.net] Sent: Sunday, January 16, 2011 10:39 PM To: Robert Haas Cc: Josh Berkus; Michael Smith; pgsql-www@postgresql.org Subject: Re: [pgsql-www] Correction for the Binary Replication Tutorial On Mon, Jan 17, 2011 at 03:00, Robert Haas <robertmhaas@gmail.com> wrote: > On Sat, Jan 15, 2011 at 5:28 PM, Josh Berkus <josh@agliodbs.com> wrote: >> 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? > > I got the impression he's using a data_directory setting which doesn't > point back at the directory containing postgresql.conf? Sounds like a debian/ubuntu box to me. >> 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. > > Does anyone keep an eye on the Discussion pages? Make changes, sure, > but I bet editing a talk page is a good way to get ignored for all > time. I've certainly never done it, but I'm no wiki-black-belt :-) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
On 1/17/11 9:43 AM, Michael Smith wrote:
> It is indeed an Ubuntu box, I was just concern that those people reading
> your wiki and trying it on an Ubuntu box might be interest in my findings.
Yeah, I'd suggest adding a section at the bottom where you give all the
file paths for a standard ubuntu installation. Then people can do the
same for other standard installations, such as Red Hat, One-click
installer, pkgsrc, etc. If you're not sure where to put it, just add it
as its own header and I'll move it later.
-- -- Josh Berkus PostgreSQL Experts Inc.
http://www.pgexperts.com