[ADMIN] postgres 8.4 authentication with LDAP

2009-10-05 Thread Olivier Nicole
Hi, Is there a way to setup a filter for authentication with LDAP? I would like to allow only users that have a specific attibute set in LDAP. Best regards, Olivier -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [ADMIN] idle connections

2009-10-05 Thread Scott Marlowe
On Mon, Oct 5, 2009 at 5:50 PM, Aras Angelo wrote: > Its a regular pg_connect() > > When i kill the earliest idle process the others stop too. So i dont know > whats wrong really. All our apps use the same footer, with pg_close() at the > end. > > I have done most of the things you guys suggested,

Re: [ADMIN] idle connections

2009-10-05 Thread Scott Marlowe
On Mon, Oct 5, 2009 at 5:50 PM, Aras Angelo wrote: > Its a regular pg_connect() > > When i kill the earliest idle process the others stop too. So i dont know > whats wrong really. All our apps use the same footer, with pg_close() at the > end. > > I have done most of the things you guys suggested,

Re: [ADMIN] idle connections

2009-10-05 Thread Aras Angelo
Its a regular pg_connect() When i kill the earliest idle process the others stop too. So i dont know whats wrong really. All our apps use the same footer, with pg_close() at the end. I have done most of the things you guys suggested, so it seems to me that something between php-apache-postgresql

[ADMIN] constraints set to deferrable by default

2009-10-05 Thread Lee, Mija
Hi: Is there a way to configure postgres so that constraints are created as deferrable by default for the database server? I didn't see anything in the documentation, but I could have missed it. I'm about to install 8.4.1. Thank you (in advance)! Mija CONFIDENTIALITY NOTICE: This e-mail message,

Re: [ADMIN] idle connections

2009-10-05 Thread Scott Marlowe
On Mon, Oct 5, 2009 at 4:42 PM, Aras Angelo wrote: > Hi, > > Im seeing lots of idle connections (not idle in transaction) to my database > server. My front end is written with PHP and i couldnt find anything that > can cause this. If i do a kill proc-id every few minutes on my server via > cron, w

Re: [ADMIN] idle connections

2009-10-05 Thread Steve Crawford
Aras Angelo wrote: Hi, Im seeing lots of idle connections (not idle in transaction) to my database server. My front end is written with PHP and i couldnt find anything that can cause this. If i do a kill proc-id every few minutes on my server via cron, would this effect anything badly? Than

[ADMIN] compiling postgres with static libraries?

2009-10-05 Thread u235sentinel
Is there a way to compile postgres with static libraries instead of dynamic? I know it will make the binaries bigger but I have a need to do this. I've been reading through the make/automake, cc, gcc and ld man pages AND googling a bit. Not getting it to run properly. When I run the ./config

[ADMIN] idle connections

2009-10-05 Thread Aras Angelo
Hi, Im seeing lots of idle connections (not idle in transaction) to my database server. My front end is written with PHP and i couldnt find anything that can cause this. If i do a kill proc-id every few minutes on my server via cron, would this effect anything badly? Thanks

Re: [ADMIN] LIKE - bug or expected behaviour?

2009-10-05 Thread Tom Lane
"Jan-Peter Seifert" writes: > Strangely the following select: > SELECT table_name FROM information_schema.views WHERE table_schema = > current_schema() AND table_name LIKE '\_%\_username'; > does also match views with names like table_username. Unless you have standard_conforming_strings turne

[ADMIN] LIKE - bug or expected behaviour?

2009-10-05 Thread Jan-Peter Seifert
Hello, we have user specific views with names that follow this pattern: _table_username Strangely the following select: SELECT table_name FROM information_schema.views WHERE table_schema = current_schema() AND table_name LIKE '\_%\_username'; does also match views with names like table_userna