Quoting David Hofmann <[EMAIL PROTECTED]>: > 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 [EMAIL PROTECTED]) >
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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
