PostgreSQL and cluster
Hi.
Anybody know if is possible to install PostgreSQL in cluster mode on a
cluster formed by two windows server 2003 cluster?
Luca
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
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: http://adv.email.it/cgi-bin/foclick.cgi?mid=6907&d=20070808
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
Import Notes
Resolved by subject fallback
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:
Show quoted text
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:41On 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 dependson.
//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/fSponsor:
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