Re: How to view the activity of postgresql

From: richard(at)xentu(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to view the activity of postgresql
Date: 2016-04-29 19:18:31
Message-ID: 08b7b35bf9b1cfa516c653d800d21140@xentu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2016-04-29 09:27, richard(at)xentu(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message richard 2016-04-30 19:14:49 Re: How to view the activity of postgresql
Previous Message richard 2016-04-29 08:27:58 Re: How to view the activity of postgresql