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