Re: How to view the activity of postgresql - Mailing list pgsql-novice

On 2016-04-29 09:27, richard@xentu.com wrote:
> $ pg_activity -U postgres -h myserver.com
> FATAL: password authentication failed for user "postgres"
>
> I'm offered no opportunity to enter the postgres user's password and
> there seems to be no command line option to supply it.

Apologies, I've got it!
It expects a PGPASSWORD environment variable.

I'll have a play with it to see if it does what I'm needing.