Thread: pgAdmin - pgAgent schema

Hi,I would like to install the pgAgent schema in my own database so that
when I dump it I backup all the jobs as well. Is there a way to
configure pgAdmin to look for pgAgent schema in a database different
than "postgres" ?

Thanks in advance,
Paolo Saudin

> ------- Original Message -------
> From: "Paolo Saudin" <paolosaudin@gmail.com>
> To: pgadmin-support@postgresql.org
> Sent: 26/11/07, 19:56:55
> Subject: [pgadmin-support] pgAdmin - pgAgent schema
> 
> Hi,
>     I would like to install the pgAgent schema in my own database so that
> when I dump it I backup all the jobs as well. Is there a way to
> configure pgAdmin to look for pgAgent schema in a database different
> than "postgres" ?

In the properties dialog for the server, change the maintenance db to the on you want to use, and modify the pgAgent
connectionstring accordingly.
 

Regards, Dave