From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>, David Hofmann <mor4321(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Duplication to External Server |
Date: | 2003-12-19 09:38:33 |
Message-ID: | 200312190938.33593.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday 19 December 2003 05:33, Keith C. Perry wrote:
> 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.
>
> 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.
For this particular case, I'd be tempted to pg_dump the local database, use
rsync over ssh to update that dump onto the hosted server, then pg_restore.
If you could stop the local copy of PG, in theory you could just move the
whole data directory, but I'd feel uncomfortable about that.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-12-19 09:42:34 | Re: [GENERAL] CASE in where statement. BUG ?? |
Previous Message | Marek Lewczuk | 2003-12-19 09:02:39 | Re: [GENERAL] CASE in where statement. BUG ?? |