[ADMIN] pg_hba.conf and password authentication problem

couldn't find anything about it in the documentation or online and don't even know where to start. Thanks in advance! Si Chen ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[ADMIN] how to find transaction associated with a lock

ich tables, which statements, etc. etc.? Thanks in advance, Si Chen select * from pg_locks relation database transaction pid mode granted NULL NULL 3422568 21440 ExclusiveLock TRUE 125703 123502 NULL 2188 AccessShareLock TRUE 124863 123502 NULL 2188 AccessShareLock TRUE 125435 123502

[ADMIN] How to identify the transaction of a lock?

resolve it in my code? Thanks! Si Chen ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html