Re: Syncing Data to Production DB Server

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(dot)sharma(at)orkash(dot)com <mailto:adarsh(dot)sharma(at)orkash(dot)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