on Postgres high availability -- it is also possible to have a
database on one machine act as master, and one or more databases on
other machines act as slaves, updating data from the master. How you
implement this depends on the nature and needs of your application.
You can also use the slave m
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> This question leads me to another one : can we do High Availability using Postgres.
> If one Postgres machine fails, is there a means to have another Postgres
>installation share the same databases, with the lastest data in them ?
> Is it
serve this installation (with a few
minutes gap). Is there something else to do
Nicolas Huillard
-Message d'origine-
De: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
Date: mardi 14 mars 2000 17:03
À: Nicolas Huillard
Cc: Ricardo Kleemann; [EMAIL PROTECTED]
Objet: Re: [ADMIN] pgsql an
Tuesday, March 14, 2000 9:33 AM
> To: 'Bruce Momjian'; Ricardo Kleemann
> Cc: [EMAIL PROTECTED]
> Subject: RE: [ADMIN] pgsql and nfs
>
> Here's my 2 pence worth.
>
> If high availability is important, don't use commodity hardware - it will bre
-Original Message-
From: Nicolas Huillard [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 14, 2000 9:33 AM
To: 'Bruce Momjian'; Ricardo Kleemann
Cc: [EMAIL PROTECTED]
Subject: RE: [ADMIN] pgsql and nfs
Here's my 2 pence worth.
If high availability is i
Huillard
-Message d'origine-
De: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
Date: mardi 14 mars 2000 04:26
À: Ricardo Kleemann
Cc: [EMAIL PROTECTED]
Objet: Re: [ADMIN] pgsql and nfs
> Hello folks,
>
> Can anyone tell me if pgsql is nfs-friendly? For example if I have
there is, but even Sun doesn't do NFS locking properly, and they are the
ones that originally designed it ... amongst other problems with NFS :(
On Tue, 14 Mar 2000, Jeff MacDonald wrote:
> just to throw a wrench into the conversation,
>
> isn't thre a tcp/ip nfs that does more error checking
> just to throw a wrench into the conversation,
>
> isn't thre a tcp/ip nfs that does more error checking
> than the standard udp nfs ?
>
> or am i just blowing smoke ?
Still, you are not running with the same shared buffers on two machines.
Just connect to the machine running a single server.
just to throw a wrench into the conversation,
isn't thre a tcp/ip nfs that does more error checking
than the standard udp nfs ?
or am i just blowing smoke ?
jeff
On Mon, 13 Mar 2000, Bruce Momjian wrote:
> > Hello folks,
> >
> > Can anyone tell me if pgsql is nfs-friendly? For example if I h
> Hello folks,
>
> Can anyone tell me if pgsql is nfs-friendly? For example if I have the
> database shared over NFS and multiple db servers in a cluster?
>
> I'm used to mysql but mysql doesnt really support the db over NFS.
>
> Will postgresql allow me to do so?
Don't use NFS. I would recomm
> Hello folks,
>
> Can anyone tell me if pgsql is nfs-friendly? For example if I have the
> database shared over NFS and multiple db servers in a cluster?
>
> I'm used to mysql but mysql doesnt really support the db over NFS.
>
> Will postgresql allow me to do so?
>
NFS is stateless, and ther
11 matches
Mail list logo
