Re: Mirroring ENTIRE DATABASE.

From: Bhuvan A <bhuvansql(at)linuxfreemail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Mirroring ENTIRE DATABASE.
Date: 2002-06-03 08:30:24
Message-ID: Pine.LNX.4.20.0206031355380.21122-100000@Larry
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Rajesh Kumar Mallah,

Thankx for your response and sorry for my late response. Here find the
link for pgreplicator user discussion.

http://sourceforge.net/forum/forum.php?forum_id=60248

I wasn't aware of usogres & rserv forums and would be better if
someone point those links.

regards,
bhuvaneswaran.

On May 30, Rajesh Kumar Mallah. wrote:

> Dear Bhuvan,
>
> Advanceded replication features although important
> are not currently available with postgresql.
>
>
> Some solutions do exists like pgreplicator, usogres
> rserv etc, but not sure of their status.
>
> Also i would like to ask the list if there exists
> some place where these are discussed,..
>
>
> regds
> Mallah.
>
>
> On Wednesday 29 May 2002 12:54 pm, Bhuvan A wrote:
> > Hi,
> >
> > How can we mirror an ENTIRE DATABASE? I have came across pgreplicator
> > and it seems that it will mirror ONLY TABLES. Then how about views,
> > functions, triggers, sequences, etc.(somebody correct me if wrong)
> >
> > So am i unable to mirror a ENTIRE DATABASE in postgres? Else shall i
> > do this way on per day basis.
> >
> > $ pg_dump -h localhost dbname user | psql -h hostname dbname user
> >
> > Or is there any other better option than this one. Ofcourse i am
> > planning to mirror within LAN. Expecting your valuable suggestions.
> >
> > regards,
> > bhuvaneswaran.
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> --
> 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.
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Juan Rojas 2002-06-03 15:59:27 drop table failed to drop associated sequence
Previous Message Bruce Momjian 2002-06-03 01:06:18 Re: configure datatype name > 31?