syncronization

From: Ashok Chauhan <ashok(at)kalculate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: syncronization
Date: 2003-11-26 04:57:50
Message-ID: 1069822671.1492.26.camel@chi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi;
i am trying to make a utility that is worked as database
synchronization.

there are 5 offices in different states and all they use same database
means (same structure table).
there is a head office where is central server that is maintained all
offices databases seprately.

now i think following options for that utility :-

1) at the end of the each day all the offices are sent the backup
through pg_dump to the head office and update the central server. (is
it worked on Wide Area Network efficiently)

2) is there any command in postgresql that display all the queries on a
particular day.

or any other option/suggestion that i should follow to make this utility

please help me.
thank you

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2003-11-26 05:23:13 Re: A quick question about domains
Previous Message Grzegorz Dostatni 2003-11-26 04:37:52 Re: Size on Disk