Re: Duplication to External Server

Quoting David Hofmann <mor4321(at)hotmail(dot)com>:

> I'm setting up 2 database servers. The first is on our local network which
> is our staging server. The second is an external server setup at my hosting
> company. On a nightly bases I want to copy all the data from the local
> Postgre database to the production server at hosting company overriding
> whatever was there previously.
>
> Does anyone have any suggestions on an easy was to do this ?
>
> _________________________________________________________________
> Tired of slow downloads? Compare online deals from your local high-speed
> providers now. https://broadband.msn.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

You should check out some of the replication software on gborg.postgresql.org
but off the top of my head I would say that if you truely want to copy the data
up to the server you can use the psql program over an SSL connection. I'm not
quite sure if psql supports SSL natively but you can always tunnel the
connection with ssh if your ISP supports it. If you are using 7.4 you could
even use pg_dump with ssh in a similar manner.

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com