Обсуждение: PgAgent on Windows
Hello,I´m trying use pgAgent on windows 10 and Windows Server 2012 R2.
My version of PostgreSQL is 9.5.1.14
Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow:
"Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied"
My %APPDATA%\postgresql\pg_pass.conf is:
localhost:5490:*:postgres:my_pass
Please, any help?
Thank´s,
Márcio
 | Remetente notificado por Mailtrack 06/11/18 11:36:31 |
On 11/06/2018 07:36 AM, Marcio Meneguzzi wrote:
What do you mean by "run a job"? Can you interactively log in?
I´m trying use pgAgent on windows 10 and Windows Server 2012 R2.My version of PostgreSQL is 9.5.1.14Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow:"Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied"My %APPDATA%\postgresql\pg_pass.conf is:localhost:5490:*:postgres:my_pass
06/11/18 11:36:31
What do you mean by "run a job"? Can you interactively log in?
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
Run a Job is:
In PgAdminit´s right click over the name of job and select option "Run Now".
After, when i open windows log aplication´s, a message like this ""Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied" is generated.
Thank´s.
| | Remetente notificado por Mailtrack 06/11/18 13:23:59 |
Em ter, 6 de nov de 2018 às 11:54, Ron <ronljohnsonjr@gmail.com> escreveu:
On 11/06/2018 07:36 AM, Marcio Meneguzzi wrote:I´m trying use pgAgent on windows 10 and Windows Server 2012 R2.My version of PostgreSQL is 9.5.1.14Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow:"Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied"My %APPDATA%\postgresql\pg_pass.conf is:localhost:5490:*:postgres:my_pass
06/11/18 11:36:31
What do you mean by "run a job"? Can you interactively log in?--
Angular momentum makes the world go 'round.
Le 06/11/2018 à 14:36, Marcio Meneguzzi a écrit :
check
1) the user account who launch pgagent service. %appdata% is relative to this user
2) pg_pass.conf must be in folder %appdata%\roaming\postgresql
3) host parameter in pgagent service command line must match hostname in pg_pass.conf
Stéphane
Hello,I´m trying use pgAgent on windows 10 and Windows Server 2012 R2.My version of PostgreSQL is 9.5.1.14Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow:"Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied"My %APPDATA%\postgresql\pg_pass.conf is:localhost:5490:*:postgres:my_passPlease, any help?Thank´s,Márcio
Remetente notificado por
Mailtrack 06/11/18 11:36:31
check
1) the user account who launch pgagent service. %appdata% is relative to this user
2) pg_pass.conf must be in folder %appdata%\roaming\postgresql
3) host parameter in pgagent service command line must match hostname in pg_pass.conf
Stéphane
Thank´s Stéphane,My pg_pass.conf in database_name parameter was postgres, but when I change for *, then run successful.
Thank´s again,
Márcio.
| | Remetente notificado por Mailtrack 06/11/18 14:32:39 |
Em ter, 6 de nov de 2018 às 14:15, Stéphane Dunand <s.dunand@sirap.fr> escreveu:
Le 06/11/2018 à 14:36, Marcio Meneguzzi a écrit :Hello,I´m trying use pgAgent on windows 10 and Windows Server 2012 R2.My version of PostgreSQL is 9.5.1.14Install and configure pgAgent with sucess, but, when I try run a Job, status is Failed with a message bellow:"Couldn't create the primary connection (attempt 1): fe_sendauth: no password supplied"My %APPDATA%\postgresql\pg_pass.conf is:localhost:5490:*:postgres:my_passPlease, any help?Thank´s,Márcio
Remetente notificado por
Mailtrack 06/11/18 11:36:31
check
1) the user account who launch pgagent service. %appdata% is relative to this user
2) pg_pass.conf must be in folder %appdata%\roaming\postgresql
3) host parameter in pgagent service command line must match hostname in pg_pass.conf
Stéphane