You can use Talend or Navicat for syncing the data as per your needs without much complexity in writing a data sync application.
You have to purchase license for navicat but you can talend for free and it also supports many other database systems.
Chaitanya Kulkarni
On Fri, Aug 19, 2011 at 10:18 AM, Adarsh Sharma
<adarsh.sharma@orkash.com> wrote:
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@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