Обсуждение: 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 ?
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 :
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
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.
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:
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: > 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 ?
On 10/04/2010 06:31 PM, Ben Madin wrote:
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.htmlOn 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