Re: [GENERAL] Permissions to connect to postgres database

You can turn on connection logging by setting the following in postgresql.conf file:log_connections = onlog_disconnections = onand this will log all the connections and disconnections to your database server in the db server log files. Thanks,-- Shoaib MirEnterpriseDB (www.enterprisedb.com)On 7/27/

Re: [GENERAL] Permissions to connect to postgres database

Jasbinder Bali wrote: How do i turn on the connection logging and then how do you actually check it? Log settings are in your postgresql.conf file and are detailed in this part of the manual: http://www.postgresql.org/docs/8.1/static/runtime-config-logging.html Where your logfiles are stored

Re: [GENERAL] Permissions to connect to postgres database

How do i turn on the connection logging and then how do you actually check it?On 7/27/06, Richard Huxton wrote:Jasbinder Bali wrote:> Hi,> I have a database in postgres and i've given trusted permissions to all > making required changes> in pg_hba.conf.>> Now, I'm trying to conn

Re: [GENERAL] Permissions to connect to postgres database

Jasbinder Bali wrote: Hi, I have a database in postgres and i've given trusted permissions to all making required changes in pg_hba.conf. Now, I'm trying to connect to the database using ECPG. Unfortunately after EXEC SQL CONNECT dbxyz gives me error -402 that means i don't have permissions to t