Thread: Mirroring ENTIRE DATABASE.

Mirroring ENTIRE DATABASE.

From
Bhuvan A
Date:
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.



Re: Mirroring ENTIRE DATABASE.

From
"Rajesh Kumar Mallah."
Date:
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.



Re: Mirroring ENTIRE DATABASE.

From
Bhuvan A
Date:
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.
>