[Pgcluster-general] Pgcluster pgcluster-1.5.0rc14 installquestions

[a.mitani at sra-europe.com]

Hi all,

I'm afraid that you can not use PGCluster patch to PostgreSQL-8.1.3,
since there is no patch for PostgreSQL-8.1.3.
PGCluster has a patch for PostgreSQL-8.1.2(as 1.5.0rc7), 8.1.4 (as
1.5.0rc8) and later.
The latest version of PGCluster-1.5.0 is rc14.
This version has patch for PostgreSQL-8.1.6.

When the major version numbers are same, PostgreSQL can use each db
cluster (directory of PGDATA) without dump & restore as you know.
And major version number of PostgreSQL is same during all PGCluster-1.5.0.

It means, PGCluster-1.5.0rc14 also can use the db cluster of
PostgreSQL-8.1.3 without dump & restore as well.

Regards,
---------------------
At.Mitani

> Hi Robert.
>
> Not quite. It's a source level patch, so the proper way to use it is to
> get
> the 8.1.3 sources from the PostgreSQL site, untar them and then apply the
> pgcluster patch. They compile and get pgcluster.
>
> Besides (Mr. Mitani would need to confirm this), I don't think you can
> avoid a
> dump/restore routine when going from standard postgresql to pgcluster. (At
> the very least, you need configuration files & options that are not part
> of
> standard postgresql).
>
> Cheers,
>
> DiegoG
>
> On Thursday 25 January 2007 16:00, Given, Robert A wrote:
>> So if I have Postgresql 8.1.3 already installed and working, all I have
>> to do is install the patch, not the full package version?
>>
>> ________________________________
>>
>> From: pgcluster-general-bounces at pgfoundry.org
>> [mailto:pgcluster-general-bounces at pgfoundry.org] On Behalf Of Christian
>> Dannemann
>> Sent: Thursday, January 25, 2007 12:00 PM
>> To: pgcluster-general at pgfoundry.org
>> Subject: Re: [Pgcluster-general] Pgcluster pgcluster-1.5.0rc14
>> installquestions
>>
>>
>> Hi Bob,
>>
>>
>>
>>
>> Greetings,
>>
>> I'm running Postgresql 8.1.3 on Linux 2.6.5-7.282-s390x and
>> tried to install pgcluster-1.5.0rc14 and observed several things.
>>
>> 1. The Pgcluster install created a pgcluster-1.5.0rc14 directory
>> where a lot of binary files were placed. It also replaced several
>> Postgresql binaries in /usr/local/pgsql. Is this necessary or can I
>> create a completely separate directory for PGDATA and LD_LIBRARY_PATH?
>> This caused a problem when I backed out the Pgcluster install and tried
>> to perform a createuser and got "createuser: creation of new role
>> failed: ERROR:  This query is not permitted when all replication servers
>> fell down." I had to restore my /usr/local/pgsql directory from systems
>> backups.
>>
>> your PGDATA can be anywhere you like. You don't want to use createuser
>> when the cluster isn't running - the error message you get tells you why
>>
>> :-)
>>
>> 2. Is pgcluster-1.5.0rc14 the version I should be using with
>> Postgresql 8.1.3? I see that pgcluster-1.7.0rc3 is out, should I use
>> that instead?
>>
>> 1.5.0rc14 is fine - it uses postgresql 8.1.3.
>>
>>
>> 3. If I install pgcluster-1.5.0rc14, do I need to install the
>> pgcluster-1.5.0rc14-patch? Or does this patch just bring older versions
>> of pgcluster-1.5.0 up to patch level 14?
>>
>> No, the patch is for patching postgresql 8.1.3 to get pgcluster.
>>
>> Regards,
>>
>> Christian
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>