[pgadmin-support] pgAgent and pgpass

2010-04-26 Thread Barry Schatz
First post here, hello all. I've run into a vexing problem where pgagent log reports: DEBUG: Creating primary connection DEBUG: Creating DB connection: hostaddr=xx.xx.xxx.xxx port=6543 dbname=postgres user=postgres WARNING: Couldn't create connection: fe_sendauth: no password supplied DEBUG: Clea

Re: [pgadmin-support] database restore problem

2010-04-26 Thread Fernando Hevia
Hi Chris. It seems you preformed a data-only backup as the log provided doesn't show DDL sentences. Having done so could face you with two problems: 1. The destination database schema is different than the one where you performed the backup. The error reported on table alert_request seems to confir