Re: SCRAM question

2018-10-30 Thread Joshua D. Drake
On 10/30/18 10:51 AM, MichaelDBA wrote: I am using pgadmin4 version 3.4 with PG 11.0 and I get this error when I try to connect with scram authorization: User "myuser" does not have a valid SCRAM verifier. How do I get around this? And also how would I do this for psql? You need to update th

Re: Multi-second pauses blocking even trivial activity

2018-09-07 Thread Joshua D. Drake
On 09/07/2018 11:12 AM, Andreas Kretschmer wrote: Intermittently (one or two times a week), all queries on that host are simultaneously blocked for extended periods (10s of seconds). The blocked queries are trivial & not related to locking - I'm seeing slowlogs of the form: please check if TH