That does seem to be a problem with Postgres, shutting down the server
to do major 'fills' / 'updates'.
Jason M. Kuhlman wrote:
> Hello
> We would like to expose some data live to the internet, but some of our
> departments are deep in MS SQL. I know it's possible to replicate SQL to
> PostGreSQL. Our data isn't time sensitive so we wouldn't have to have it
> replicate live. What I would like to do is set up a script to
> replicate/dump the tables once a night, but I'm not having any luck.
>
> With this scenario this PostGreSQL database could then be a "sort of" backup
> also. Would it be possible, if needed to push these databases back into MS
> SQL? I have been going through the archives for a couple of days, but most
> posts seem to be about real time replications.
>
> Any help would be appreciated.
>
> Thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>