Skip site navigation (1) Skip section navigation (2)

Re: Backing up through a database connection (not pg_dump)

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 (view raw or flat)
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

In response to

pgsql-general by date

Next:From: Bret SternDate: 2012-03-27 00:37:10
Subject: Re: Backing up through a database connection (not pg_dump)
Previous:From: Tim UckunDate: 2012-03-27 00:12:04
Subject: Re: Backing up through a database connection (not pg_dump)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group