Thread: Correction for the Binary Replication Tutorial

Correction for the Binary Replication Tutorial

From
"Michael Smith"
Date:
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.


Re: Correction for the Binary Replication Tutorial

From
Josh Berkus
Date:
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
 


Re: Correction for the Binary Replication Tutorial

From
Robert Haas
Date:
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


Re: Correction for the Binary Replication Tutorial

From
Magnus Hagander
Date:
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/


Re: Correction for the Binary Replication Tutorial

From
"Michael Smith"
Date:
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/


Re: Correction for the Binary Replication Tutorial

From
Josh Berkus
Date:
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