Thread: 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
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: 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