[Pgcluster-general] Pgcluster pgcluster-1.5.0rc14 installquestions

[Diego Gutierrez]

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