Dear Sai, Why do you want to update at nite only. You can setup streaming replication with pgsql9.0 and have it updated almost instantly.
However if you would want it that way only read about various backup options in the link that was provided. regds mallah. On Mon, Oct 4, 2010 at 4:02 PM, Sairam Krishnamurthy <kmsram...@gmail.com>wrote: > Hi all. > > I am trying to create two databases in two different machines connected > over the lan. Both the databases have similar tables and fields in them. I > will be updating database A always. I want the update to be backed up to > database B automatically during the night when no one will be using the > databases. > > Can some one tell if if this can be done and if yes how ? > > -- > Thanks, > Sairam Krishnamurthy > +1 612 859 8161 > >
