Re: Replication Across Two Servers?

Carlos,

I would recommend you simply stick with Debian 6 and add the debian
backports repository.  Add the following to your /etc/apt/sources.list:

deb http://backports.debian.org/debian-backports squeeze-backports main

After adding that just do an 'apt-get update' and you will be able to
install the postgresql-9.1 package.

If you would prefer to use Aptitude to install your packages, then do a
search for ^postgres, then when you find the postgresql-8.4 package just
hit the V key to view other available versions, 9.1 should be one of the
additional versions available.

-Brandon

On 11/04/2011 11:58 AM, Carlos Mennens wrote:
> On Fri, Nov 4, 2011 at 11:52 AM, Brandon Phelps<bphelps@gls.com>  wrote:
>> Carlos,
>>
>> Streaming replication was introduced in PostgreSQL 9.0 and should do what
>> you want.
>>
>> http://wiki.postgresql.org/wiki/Streaming_Replication
>
> Oh great! I didn't see that in the 8.4 manual since that is what
> Debian 6 has as the most stable version in it's package manager.
> Anyone know of a stable Linux distribution that offers 9.0+? I know
> Debian Wheezy (testing) has 9.1 but sadly it's testing and not
> recommended for production utilization. RHEL is years behind as far as
> packages go which makes them stable to an annoying degree.
>