Обсуждение: PostgreSQL and cluster

----
Email.it, the professional e-mail, gratis per te: clicca qui

Sponsor:
Vivi i MONDIALI di ATLETICA di TOKYO da protagonista. Compra on line i prodotti ufficiali della Nazionale Italiana FIDAL. Vestiti di azzurro
Clicca qui

On Wed, Aug 08, 2007 at 01:03:54PM +0200, luca.ciciriello@email.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

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@hagander.net>
    To:
            Cc: pgsql-general@postgresql.org
    Oggetto: Re: [GENERAL] PostgreSQL and cluster
    Data: 08/08/07 15:41

    >
>
>
> On Wed, Aug 08, 2007 at 01:03:54PM +0200, luca.ciciriello@email.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

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.ciciriello@email.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@hagander.net>
>     To:
>             Cc: pgsql-general@postgresql.org
>     Oggetto: Re: [GENERAL] PostgreSQL and cluster
>     Data: 08/08/07 15:41
>
>     >
>>
>> On Wed, Aug 08, 2007 at 01:03:54PM +0200, luca.ciciriello@email.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