0

I have a postgresql database accessed from pgadmin3 and libreoffice. When it is accessed from multiple clients, it seems like only one client can actively access the database. Like there was an exclusive lock. Other clients do freeze. The database is accessed using ssl authentication.

Árpád Magosányi
  • 1,394
  • 2
  • 19
  • 35
  • 1
    What version of postgresql? it's straightforward to confirm an exclusive lock is causing the problem, but the names of the columns in the `pg_stat_activity` query depends on the PG version – AdamKG Oct 01 '18 at 19:44
  • It must be Libreoffice or its driver that locks the tables, because pgAdmin sure doesn't. – Laurenz Albe Oct 02 '18 at 06:35

0 Answers0