Обсуждение: Having two simultaneous and similar database

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

http://www.postgresql.org/docs/8.4/interactive/backup.html

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 8:46 PM, Rajesh Kumar Mallah
<mallah.rajesh@gmail.com> wrote:
> 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.

They could have something where they need a stable unchanging version
for testing, or they're load testing and need to write to the salve,
etc.

Ben,

Thanks for the pointer. I did had a look at this b4 posting this. It
seems more of a back up rather than maintaining two databases. So i
basically have to set up a continuous archive and use the raw file to
update the other database.

I was rather looking for a direct way to maintain to synchronous databases.



On Mon, Oct 4, 2010 at 6:31 PM, Ben Madin
<lists@remoteinformation.com.au> wrote:
> I think you want something like :
> http://www.postgresql.org/docs/8.4/interactive/backup.html
> On 05/10/2010, at 7:02 AM, Sairam Krishnamurthy 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
>
>

Scott, Thanks to answering the question. Thats exactly the reason.

Also any operation on the tables is going to be huge. LIke 10s of
thousands of rows inserted of deleted. This basically locks the table
and that y we wanted to update a database and sync it with the
production database when no one will be using the system.



On Mon, Oct 4, 2010 at 9:55 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Oct 4, 2010 at 8:46 PM, Rajesh Kumar Mallah
> <mallah.rajesh@gmail.com> wrote:
>> 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.
>
> They could have something where they need a stable unchanging version
> for testing, or they're load testing and need to write to the salve,
> etc.
>

All,

Is there a way to do this other than using the backup feature?
__________________________________________________________________

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

On 10/04/2010 06:31 PM, Ben Madin wrote:

I think you want something like :

http://www.postgresql.org/docs/8.4/interactive/backup.html

On 05/10/2010, at 7:02 AM, Sairam Krishnamurthy 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