From: | stephane parenton <stephane(at)parenton(dot)com> |
---|---|
To: | pgsql <pgsql-admin(at)postgresql(dot)org> |
Subject: | replication and availability |
Date: | 2003-07-24 13:50:13 |
Message-ID: | 3F1FE415.3040003@parenton.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
hi everyone,
having read the online doc, and a book, i can't find precisely what i'm
looking for, but it's maybe normal.... here it is....
I have a distant postgres database used to store networking info. This
database "may" be unavailable, so i need to have another postgres
database somewhere else (it theory, i should know where...). What can i
do to tell somewhere/postgres to be exactly the same as
elsewhere/postgres... Let's imagine that somewhere/postgres is my
primary database, shall i have to use triggers in order to insert/delete
datas in elsewhere/postgres at the same time as somewhere/postgres ? or
should i have to dump somewhere/postgres regularly and update
elsewhere/postgres with this dump (cron job ?)...
Isn't there a something in postgres to say elsewhere should be the
database image of somewhere/postgres ?
regards
stephane
From | Date | Subject | |
---|---|---|---|
Next Message | Yogesh Bhanu | 2003-07-24 17:32:50 | PG-7.3.2 and tru64 5.1a |
Previous Message | A.Bhuvaneswaran | 2003-07-24 09:23:54 | Re: Using the /var/lib/pgsql/data directory in the absense |