[GENERAL] auditing pg_hba.conf

table/view that stores pg_hba rules. I'm curious to know if anyone has any suggestions, or has solved a similar problem. Best Regards, JP -- JP Fletcher Database Administrator Afilias Canada voice: 416.646.3304 ext. 4123 fax: 416.646.3305 mobile: 416.561.4763 jpfle...@ca.afilias.info

Re: [GENERAL] prepared statements and DBD::Pg

y with PG, an error in server-side prepare aborts the current transaction, so that any subsequent command will fail until a rollback is issued. Falling back to client-side prepare once in this state would probably not help much. Best regards, -- JP Fletcher Database Administrator Af

[GENERAL] prepared statements and DBD::Pg

to a prepared statement my $prepare_sql =< INSERT INTO foo(1, 1); INSERT INTO foo(2, 2); SQL my $sth = $dbh->prepare($prepare_sql); Is this the expected behaviour? -- JP Fletcher Database Administrator Afilias Canada voice: 416.646.3304 ext. 4123 fax:

Re: [GENERAL] postgresql and LDAP

hould be more information about the problem in the postmaster log. We intentionally don't send details about the conf file's contents to the client... Perhaps we should send a HINT to the client saying to consult the postmaster logs? -- JP Fletcher Database Administrator Afi

[GENERAL] postgresql and LDAP

stmaster | grep ldap libldap_r-2.4.so.2 => /usr/lib/libldap_r-2.4.so.2 (0xb7fd5000) This is on ubuntu linux, and the only configure option besides prefix was '--with-ldap' -- JP Fletcher Database Administrator Afilias Canada voice: 416.646.3304 ext. 4123 fax: 416.64