Re: Having two simultaneous and similar database

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 <kmsram420(at)gmail(dot)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
>
>