From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
---|---|
To: | Bhuvan A <bhuvansql(at)linuxfreemail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Mirroring ENTIRE DATABASE. |
Date: | 2002-05-30 09:46:13 |
Message-ID: | 200205301516.13707.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Chad R. Larson | 2002-05-30 18:17:30 | Re: databases and RAID ... |
Previous Message | Stephan Szabo | 2002-05-29 15:56:03 | Re: Complex join query |