[GENERAL] 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=6907d=20070808
Re: [GENERAL] PostgreSQL and cluster
On Wed, Aug 08, 2007 at 01:03:54PM +0200, [EMAIL PROTECTED] 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
Re: [GENERAL] PostgreSQL and cluster
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 [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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=6559d=20070808 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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=6559d=20070808 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] PostgreSQL Database cluster with multiple different locale
Mario Weilguni wrote: Am Freitag, 15. April 2005 17:57 schrieb Peter Eisentraut: Mario Weilguni wrote: Is it possible to have a database cluster with one database being UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? No, sorry. Thanks for the reply. Does that mean it's simply impossible, or nobody has ever need such a beast? IMO it should be possible apply different locale settings after forking the backend, or am I wrong here? Some people have asked for it, but because we have some global tables like pg_shadow and pg_database, it is hard to change per database. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] PostgreSQL Database cluster with multiple different locale settings?
Is it possible to have a database cluster with one database being UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? I checked a lot, and currently I found only the initdb way to influence --lc-ctype and --lc-collate Thanks! Mario ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] PostgreSQL Database cluster with multiple different locale settings?
Mario Weilguni wrote: Is it possible to have a database cluster with one database being UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? No, sorry. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] PostgreSQL Database cluster with multiple different locale settings?
Am Freitag, 15. April 2005 17:57 schrieb Peter Eisentraut: Mario Weilguni wrote: Is it possible to have a database cluster with one database being UNICODE/de_AT.utf and another having UNICODE/koi8.utf8 (or whatever)? No, sorry. Thanks for the reply. Does that mean it's simply impossible, or nobody has ever need such a beast? IMO it should be possible apply different locale settings after forking the backend, or am I wrong here? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] PostgreSQL on cluster
Hello All, Does anybody have a live cluster with 2 or more computers running PostgreSQL, connected to single database on shared storage or to replicated database with load balancing between them? -- Best regards, Yury mailto:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] PostgreSQL on cluster
Yury Don wrote: Hello All, Does anybody have a live cluster with 2 or more computers running PostgreSQL, connected to single database on shared storage or to replicated database with load balancing between them? No, because you can't share the same database files between two independent servers. You could run PG on a cluster if it could distribute shared memory, but without specialised hardware it would be very slow. Replication is fine, although load-balancing needs to be thought through. There's been plenty of discussion of this recently, search the archives for cluster or replication or slony. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]