I cannot recall it has been a while, is it possible to do that now?
I'm under the impression that you should still be able to do it if you un-register the agent and re-register it. Even if you didn't provide the password at register time, I think you should be able to make it work with the .pgpass file. As per the documentation section 188.8.131.52 (https://www.enterprisedb.com/docs/en/7.1/peminstguide/installation_guide.1.12.html), you should be able to make it work with 1 of the 3 options.
I think there might be more details required here (i.e., how old is this installation? sounds like you've had it running for a while now) -- did you recently try to do an upgrade or something? Also, which OS user does your pemagent/pemworker process belong to? That might give a clue into which OS user's homedir needs the .pgpass file.
You may also want to get a more comprehensive view (i.e., look at all the Postgres logs on servers 6,14,25, as well as the PEM Server's Postgres logs) to see if any patterns surface.
thanks for the info
attempted to run this
Thanks for the update. You need to execute the pemworker binary, Could you please try to register the PEM agent with below syntax :
Please get back t us in case of any issues/queries.
[root@servername bin]# ./pemworker --register-agent
Postgres Enterprise Manager Server Hostname: xx.xx.xx.xxx
Postgres Enterprise Manager Server Username: postgres
Wed Feb 6 14:04:23 2019 : WARNING: unable to connect to PEM database: fe_sendauth: no password supplied
Wed Feb 6 14:04:23 2019 : ERROR: Unable to connect to Postgres Enterprise Manager Server
note i have created a .pgpass file in the home directory for the postgres user with an entry for the pem server, but it doesnt seem to be reading it.
Below might be the possible causes that .pgpass is not invoking while registring the PEM agnet.
1) Could you please check .pgpass file has 0600 permission and owner should be postgres.
2) .pgpass file should have entries in below sequence order.
3) .pgpass file should be created on the machine where your registring the PEM agent.
And also you can follow the below methods as well.
When invoking the pemworker utility, you must provide the password associated with the PEM server administrative user role (postgres). There are three ways to specify the administrative password; you can:
1) Set the PEM_SERVER_PASSOWRD environemnt variable
EX: export PEM_SERVER_PASSWORD=postgres
2) Provide the password on the command line with the PGPASSWORD keyword.
EX: export $PGPASSWORD=postgres
3) Create an entry in the .pgpass file.
Failure to provide the password will result in a password authentication error; you will be prompted for any other required but omitted information. When the registration is complete, the server will confirm that the agent has been successfully registered.