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
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:
Show quoted text
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
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@gmail.com>wrote:
Show quoted text
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
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:
Show quoted text
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.
Show quoted text
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
Show quoted text
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