Re: [GENERAL] use superuser connection from php

2007-04-04 Thread [EMAIL PROTECTED]
Martijn van Oosterhout wrote: To use the superuser connections you need to login as superuser... Eh... OK. I feel a bit stupid :) Thanks ;) Iv ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] use superuser connection from php

2007-04-04 Thread [EMAIL PROTECTED]
Albe Laurenz wrote: You can connect as superuser on a different connection and issue that SELECT statement. OK But I wouldn't do that. What if there is a problem and all availaible superuser connections are exhausted? You would not be able to connect to the database any more, even as

[GENERAL] use superuser connection from php

2007-04-02 Thread [EMAIL PROTECTED]
hello, we have a php application which gets from time to time database errors which look like there are not enough connections (we have 100 connections allowed to postgresql) - i read that there are two db connections reserved for su. is there a way to use them from php in order to check if

Re: [GENERAL] use superuser connection from php

2007-04-02 Thread Martijn van Oosterhout
On Mon, Apr 02, 2007 at 11:33:50AM +0200, [EMAIL PROTECTED] wrote: i read that there are two db connections reserved for su. is there a way to use them from php in order to check if the database is really out of connections (with - 'SELECT count(*) FROM pg_stat_activity') or the problem is

Re: [GENERAL] use superuser connection from php

2007-04-02 Thread Albe Laurenz
we have a php application which gets from time to time database errors which look like there are not enough connections (we have 100 connections allowed to postgresql) - i read that there are two db connections reserved for su. is there a way to use them from php in order to check if the