Thread: really important
it is possible to make a database cluster with postgresql ?
Best regards,
Vergoz Michael
From what I've heard and read postgres does not internally support replication. Their are 3rd party tools to do it though. I've also heard they're rather slow. I was told replication is slated for the next major release (either 7.3 or 8) but I haven't heard anything official. Has anybody else? We're migrating from a mysql world ourselves. Replication is a key part of our disaster recovery procedures. To rely on a backup seems so 1999 to me. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Vergoz Michael Sent: Wednesday, June 05, 2002 2:35 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] really important it is possible to make a database cluster with postgresql ? Best regards, Vergoz Michael
yes, but i can't wait the next release, it's possible to make a module or something else ? i think, the postgres TEAM have to make a clustering system like fiber channel switch.... well, i will find more informations about that ... regards, michael. ----- Original Message ----- From: "Adam Erickson" <adamre@cox.net> To: <pgsql-admin@postgresql.org> Sent: Wednesday, June 05, 2002 10:20 AM Subject: Re: [ADMIN] really important > >From what I've heard and read postgres does not internally support > replication. Their are 3rd party tools to do it though. I've also heard > they're rather slow. > > I was told replication is slated for the next major release (either 7.3 or > 8) but I haven't heard anything official. Has anybody else? > > We're migrating from a mysql world ourselves. Replication is a key part of > our disaster recovery procedures. To rely on a backup seems so 1999 to me. > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Vergoz Michael > Sent: Wednesday, June 05, 2002 2:35 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] really important > > > it is possible to make a database cluster with postgresql ? > > Best regards, > Vergoz Michael > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
hi adam, Why cant' pg_dump become a part OF disaster recovery? I agree replication is very important , but also appriciate that pgsql give us so many other useful features that are not in other open source databases ( no flame war intended ) regds mallah. On Wednesday 05 June 2002 13:50, Adam Erickson wrote: > From what I've heard and read postgres does not internally support > replication. Their are 3rd party tools to do it though. I've also heard > they're rather slow. > > I was told replication is slated for the next major release (either 7.3 or > 8) but I haven't heard anything official. Has anybody else? > > We're migrating from a mysql world ourselves. Replication is a key part of > our disaster recovery procedures. To rely on a backup seems so 1999 to me. > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Vergoz Michael > Sent: Wednesday, June 05, 2002 2:35 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] really important > > > it is possible to make a database cluster with postgresql ? > > Best regards, > Vergoz Michael > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
hi Vergoz, Why cant' pg_dump become a part OF disaster recovery? I agree replication is very important , but also appriciate that pgsql give us so many other useful features that are not in other open source databases ( no flame war intended ) regds mallah. On Wednesday 05 June 2002 14:12, Vergoz Michael wrote: > yes, but i can't wait the next release, it's possible to make a module or > something else ? > i think, the postgres TEAM have to make a clustering system like fiber > channel switch.... > well, i will find more informations about that ... > > regards, > michael. > > ----- Original Message ----- > From: "Adam Erickson" <adamre@cox.net> > To: <pgsql-admin@postgresql.org> > Sent: Wednesday, June 05, 2002 10:20 AM > Subject: Re: [ADMIN] really important > > > >From what I've heard and read postgres does not internally support > > > > replication. Their are 3rd party tools to do it though. I've also heard > > they're rather slow. > > > > I was told replication is slated for the next major release (either 7.3 > > or 8) but I haven't heard anything official. Has anybody else? > > > > We're migrating from a mysql world ourselves. Replication is a key part > > of > > > our disaster recovery procedures. To rely on a backup seems so 1999 to > > me. > > > -----Original Message----- > > From: pgsql-admin-owner@postgresql.org > > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Vergoz Michael > > Sent: Wednesday, June 05, 2002 2:35 AM > > To: pgsql-admin@postgresql.org > > Subject: [ADMIN] really important > > > > > > it is possible to make a database cluster with postgresql ? > > > > Best regards, > > Vergoz Michael > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
At 07:36 AM 6/19/02 , Rajesh Kumar Mallah. wrote:
>Why cant' pg_dump become a part OF disaster recovery?
>
>I agree replication is very important , but also appriciate
>that pgsql give us so many other useful features that are not
>in other open source databases
And, to revisit an earlier issue, we should have point-in-time recovery.
-crl
--
Chad R. Larson (CRL22) chad@eldocomp.com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228