Re: PostgreSQL and cluster

Probably the easiest way is to unregister the server using pg_ctl
unregister, and then re-register it with the other data directory.

The other option is to edit the registry under Services and change the
commandline used to start the PostgreSQL service. Note that you will
have to reboot your server if you go with this method.

Normally, you'd point out the cluster directory when you originally
install PostgreSQL and the installer will take care of it.

//Magnus

luca(dot)ciciriello(at)email(dot)it wrote:
> Thanks, setting it up as generic service make the clustering procedure to
> work fine, but I'm still unable to relocate the data directory. We have
> copied the DATA directory in the right path, but which variables I must
> change? I've changed the variable about the path (now I'm not in the office
> and don't remember the name) in the file PostgreSQL.conf, but nothing is
> changed.
>
> Luca
>
> --------- Original Message --------
> Da: Magnus Hagander <magnus(at)hagander(dot)net>
> To:
> Cc: pgsql-general(at)postgresql(dot)org
> Oggetto: Re: [GENERAL] PostgreSQL and cluster
> Data: 08/08/07 15:41
>
> >
>>
>> On Wed, Aug 08, 2007 at 01:03:54PM +0200, luca(dot)ciciriello(at)email(dot)it wrote:
>>> Hi.
>>> Anybody know if is possible to install PostgreSQL in cluster mode on a
>>> cluster formed by two windows server 2003 cluster?
>> Yes. Set it up as a generic service, and make sure you store the data
>> directory (and any other tablespaces) on disks that the service depends
> on.
>> //Magnus
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>>
>>
> --
> Email.it, the professional e-mail, gratis per te: http://www.email.it/f
>
> Sponsor:
> Non perderti nella giungla di facili promesse, Logos ti da credito sempre!
>
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6559&d=20070808