View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 08:24 PM
Dave Page
 
Posts: n/a
Default Re: how to create backup copies



> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailtogadmin-support-owner@postgresql.org] On Behalf Of Andrus
> Sent: 13 April 2006 11:43
> To: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] how to create backup copies
>
> > To be honest for a simple backup on the local machine

> you'll be better
> > off running it from task scheduler. pgAgent is better suited to
> > running batch processing jobs that may run on any one of a

> number of
> > nodes, or SQL jobs that run directly on the database.

>
> Using pgAgent allows me to monitor backup status remotely
> using pgadmin or making sql queries to pgagent schema,
> without need to log-in and open RDP port in server.
>
> So I'd prefer to use pgAgent even for simple backup if possible.
>

Good point.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote