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 s

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-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 i

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

[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