Re: Syncing Data to Production DB Server

[Adarsh Sharma <adarsh.sharma@xxxxxxxxxx>]

Hi Michael,

I think you misunderstood my problem.
I have a demo system and the data is inserted in this system.

Simply I want this newly inserted data to be synk to my production server.
Taking pg_dump of cumbersome daily.

I reserached & find some proprietary solution but I think there may be other solutions too.


Thanks
Michael Nolan wrote:

On Thu, Aug 18, 2011 at 11:03 PM, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> wrote:

I want a simple technique through which I update my production server easily.

What I do with a similar sized database is do a pg_dumpall on the production server and
restore it to the laptop.  Because the production server is around 950 miles from my office, it usually takes me longer to copy the dumpall file across the Internet than it does to restore it on the laptop.

I do this about twice a month.

I find having a test database that is a week or two out of date doesn't affect most development work.  In fact, being able to restore the test database to a known state repeatedly has come in handy for testing some scenarios.  Your situation may be different.  
--
Mike Nolan