On Tue, Mar 27, 2012 at 12:05:00PM +1300, Tim Uckun wrote:
> Is there a way to backup a database or a cluster though a database
> connection? I mean I want to write some code that connects to the
> database remotely and then issues a backup command like it would issue
> any other SQL command. I re
At 01:05 27/03/2012, Tim Uckun wrote:
Is there a way to backup a database or a cluster though a database
connection? I mean I want to write some code that connects to the
database remotely and then issues a backup command like it would issue
any other SQL command. I realize the backups would nee
>
> We're also using libpq to trigger backups using NOTIFY from a client
> app.
Do you have an example of how this is done?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 2012-03-26 at 16:16 -0700, John R Pierce wrote:
> On 03/26/12 4:05 PM, Tim Uckun wrote:
> > Is there a way to backup a database or a cluster though a database
> > connection? I mean I want to write some code that connects to the
> > database remotely and then issues a backup command like i
* Tim Uckun (timuc...@gmail.com) wrote:
> On Tue, Mar 27, 2012 at 1:00 PM, David Boreham 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 woul
On Tue, Mar 27, 2012 at 1:00 PM, David Boreham 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 wan
fwiw we run db_dump locally, compress the resulting file and scp or
rsync it to the remote server.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/26/12 4:05 PM, Tim Uckun wrote:
Is there a way to backup a database or a cluster though a database
connection? I mean I want to write some code that connects to the
database remotely and then issues a backup command like it would issue
any other SQL command. I realize the backups would nee
Is there a way to backup a database or a cluster though a database
connection? I mean I want to write some code that connects to the
database remotely and then issues a backup command like it would issue
any other SQL command. I realize the backups would need to reside on
the database server.
--
