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.sha...@orkash.com <mailto:adarsh.sha...@orkash.com>> 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