Re: Database mirroring

Lists: pgsql-admin
From: "Rommel B(dot) Abaya" <rommel(dot)abaya(at)kfc(dot)ph>
To: pgsql-admin(at)postgresql(dot)org
Subject: Database mirroring
Date: 2002-04-18 07:40:38
Message-ID: 3CBE7876.9737BABD@kfc.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi,

I'm trying to find out if database mirroring could be done with
PostgreSQL. What i mean is that when my applications
insert/delete/update records in my production server, it will also
insert/delete/update the same in my development server such that my
production server and development server always contain the same data.
Is this possible with PostgreSQL ?

-- I'm using PostgreSQL version 7.2

--
#########################################
Most people are willing to adapt
not because they see the light
but because they feel the heat


From: "Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database mirroring
Date: 2002-04-19 09:42:58
Message-ID: 200204190945.g3J9jMR0016686@artemis.cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

On 18 Apr 2002 at 15:40, Rommel B. Abaya wrote:

> Hi,
>
> I'm trying to find out if database mirroring could be done with
> PostgreSQL. What i mean is that when my applications
> insert/delete/update records in my production server, it will also
> insert/delete/update the same in my development server such that my
> production server and development server always contain the same data.
> Is this possible with PostgreSQL ?
>
> -- I'm using PostgreSQL version 7.2

I think the keyword you want to look for is replication. AFAIK this
isn't officialy a part of 7.2, but somewhere in the contribs.

--
Jules Alberts


From: "Rommel B(dot) Abaya" <rommel(dot)abaya(at)kfc(dot)ph>
To: jules(dot)alberts(at)arbodienst-limburg(dot)nl
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database mirroring
Date: 2002-04-22 00:37:23
Message-ID: 3CC35B43.3B6F3753@kfc.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Yes,

It's replication which is what i'm talking about

Jules Alberts wrote:

> On 18 Apr 2002 at 15:40, Rommel B. Abaya wrote:
>
> > Hi,
> >
> > I'm trying to find out if database mirroring could be done with
> > PostgreSQL. What i mean is that when my applications
> > insert/delete/update records in my production server, it will also
> > insert/delete/update the same in my development server such that my
> > production server and development server always contain the same data.
> > Is this possible with PostgreSQL ?
> >
> > -- I'm using PostgreSQL version 7.2
>
> I think the keyword you want to look for is replication. AFAIK this
> isn't officialy a part of 7.2, but somewhere in the contribs.
>
> --
> Jules Alberts
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

--
#########################################
Most people are willing to adapt
not because they see the light
but because they feel the heat