From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Hogan, James F(dot) Jr(dot)" <JHogan(at)seton(dot)org> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgagent jobs never start |
Date: | 2006-01-17 16:11:47 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40103D89B@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Hogan, James F. Jr. [mailto:JHogan(at)seton(dot)org]
> Sent: 17 January 2006 15:37
> To: Dave Page
> Subject: RE: [pgadmin-support] pgagent jobs never start
>
> Wow that was a world of help adding the -l 2 switch...
Great, glad to hear it's working.)
> I will post a Blurb about this to my original post and also submit a
> Document update Request to include this "password="
>
> Looks like they indented to as I notice that the string example they
> provided doesn't have the closing double quote.
Not quite :-) The quotes are around the path to the pgAgent executable,
not the options. If you read the next section of the docs, you'll see
why the password= bit is excluded from the example:
Database password - DO NOT be tempted to include a password in the
pgAgent connection string - on *nix systems it may be visible to all
users in 'ps' output, and on Windows systems it will be stored in the
registry in plain text. Instead, use a libpq ~/.pgpass file to store the
passwords for every database that pgAgent must access. Details of this
technique may be found in the PostgreSQL documentation
(http://www.pgadmin.org/docs/1.4/pg/libpq-pgpass.html)
(Now available at http://www.pgadmin.org/docs/1.4/pgagent-install.html
on the new website that just went live :-) ). The pgpass file should be
configured for the Windows user account that the service runs as with
appropriate connection info for the databases/postgresql user &
password.
> Again
>
> THANK YOU
You're welcome.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | hunkybill | 2006-01-17 18:49:52 | pgAdmin Admin Tools Install |
Previous Message | Hogan, James F. Jr. | 2006-01-17 15:43:16 | Re: pgagent jobs never start |