I have a few credentials created in .pgpass that will be accessible to scheduled cron job. chmod 600 and export pgpassfile. Momentarily, the set up will work, but after a failover or restart, the pgpass is wiped out. Only 1 credential remains, which is the replication credential.
Does anyone know why new credential will not be recorded or overridden?
