[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

[ADMIN] indexing

when they are entered in to the database, Please can you show me how to find this index. Thanks, Si _ Pick up your email anywhere in the world ---> http://www.remail.net

[ADMIN] Postgres Installation Problem

Hello, I have problem installing prostgresql. To be your information, I've never change anything on the setting/configuration. I just follow the REDHAT Linux 6.0 standard installation (I get the postgresql from those REDHAT package). The problem is, every time I start it, there is an error messa