| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Tim Uckun <timuckun(at)gmail(dot)com> |
| Cc: | David Boreham <david_list(at)boreham(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backing up through a database connection (not pg_dump) |
| Date: | 2012-03-27 00:17:27 |
| Message-ID: | 20120327001727.GM3938@tamriel.snowman.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* Tim Uckun (timuckun(at)gmail(dot)com) wrote:
> On Tue, Mar 27, 2012 at 1:00 PM, David Boreham <david_list(at)boreham(dot)org> wrote:
> > fwiw we run db_dump locally, compress the resulting file and scp or rsync it
> > to the remote server.
>
> I wanted to see if I can do that without running pg_dump on the remote
> server. That would involve connecting to the server via ssh and I want
> to see if there is a way to avoid that.
Well, sure, run pg_dump on the local system and have it connect to the
remote server.. The result would end up on the local system, of course.
Thanks,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bret Stern | 2012-03-27 00:37:10 | Re: Backing up through a database connection (not pg_dump) |
| Previous Message | Tim Uckun | 2012-03-27 00:12:04 | Re: Backing up through a database connection (not pg_dump) |