johnkn63 wrote: [can connect as superuser but not as regular user] > I tried - the results where as predicted whilst a non-superuser does not > work but once altered to superuser does work. > > So what next?
Hmm, I'm running out of ideas here. You still get "password authentication failed" in the log? Can you run these three queries and post the result: SELECT usesuper, count(*) FROM pg_stat_activity JOIN pg_user USING (usesysid) GROUP BY usesuper; SHOW superuser_reserved_connections; SHOW max_connections; Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
