Re: [GENERAL] RESET ROLE and search_path, Connection pool

2010-12-05 Thread Marc Mamin
Hello, > Obviously each "user" could use RESET ROLE and become the super user.  Yes, this is a point not to forget, but isn't an issue in our case. best regards, Marc Mamin From: Derrick Rice [mailto:derrick.r...@gmail.com] Sent: Samstag, 4. Dezember 2010 00:21 To: Marc Mamin Cc: pgsql-gene

Re: [GENERAL] PostgreSQL 9.0 RPMs for RHEL 6 and Fedora 14 released

2010-12-05 Thread Allan Kamau
2010/12/3 Devrim GÜNDÜZ : > On Sun, 2010-11-21 at 12:39 +0300, Allan Kamau wrote: >> >> I am unable to obtain (using yum) a version of pgAdmin3 that can >> connect fruitfully to postgreSQL 9.x. My installation reports that the >> version I do have 1.10.5 is the latest. > > Should be fixed as of yes

Re: [GENERAL] One-click Installers for 9.1 Alpha 2 (ETA)

2010-12-05 Thread Guillaume Lelarge
Le 05/12/2010 14:43, Stefan Keller a écrit : > I've recently installed newest Postgres 9.1 Alpha 1 > (postgresql-9.1alpha1-windows-binaries.zip from > http://www.enterprisedb.com/products/pgbindownload.do ) and got a > similar question around this: > > There's pgAdmin3 v.1.13 included but it still

Re: [GENERAL] PG84 and SELinux

2010-12-05 Thread Greg Smith
Tom Lane wrote: "James B. Byrne" writes: I wrote too soon. What I did was uncomment the ssl option. I neglected to change the setting from off to on. When I try to start the server with ssl=on it fails with this error: Auto configuration failed 29006:error:0E065068:co

Re: [GENERAL] an enhancement idea

2010-12-05 Thread Craig Ringer
On 12/06/2010 04:41 AM, John R Pierce wrote: If you want that level of isolation, you have to give each user his own cluster. as postgresql is currently structured, yes, and further, each cluster needs its own listener port which is, IMHO, rather ugly. My idea of adding an 'instance' layer al

Re: [GENERAL] One-click Installers for 9.1 Alpha 2 (ETA)

2010-12-05 Thread Dave Page
On Sun, Dec 5, 2010 at 1:43 PM, Stefan Keller wrote: > I've recently installed newest Postgres 9.1 Alpha 1 > (postgresql-9.1alpha1-windows-binaries.zip from > http://www.enterprisedb.com/products/pgbindownload.do ) and got a > similar question around this: > > There's pgAdmin3 v.1.13 included but

Re: [GENERAL] an enhancement idea

2010-12-05 Thread John R Pierce
If you want that level of isolation, you have to give each user his own cluster. as postgresql is currently structured, yes, and further, each cluster needs its own listener port which is, IMHO, rather ugly. The amount of work needed to get rid of that small bit of ugliness seems far out of pr

Re: [GENERAL] an enhancement idea

2010-12-05 Thread Tom Lane
John R Pierce writes: > On 12/05/10 12:27 PM, Tom Lane wrote: >> If you want that level of isolation, you have to give each user his own >> cluster. > as postgresql is currently structured, yes, and further, each cluster > needs its own listener port which is, IMHO, rather ugly. The amount of w

Re: [GENERAL] an enhancement idea

2010-12-05 Thread John R Pierce
On 12/05/10 12:27 PM, Tom Lane wrote: John R Pierce writes: one of the reasons PostgreSQL is less popular with shared hosting services is that there is insufficient isolation between database users. For instance, one user leaves a pending due to sloppy programming, and the entire cluster even

Re: [GENERAL] an enhancement idea

2010-12-05 Thread Tom Lane
John R Pierce writes: > one of the reasons PostgreSQL is less popular with shared hosting > services is that there is insufficient isolation between database > users. For instance, one user leaves a pending > due to sloppy programming, and the entire cluster eventually can't be > vacuumed.

Re: [GENERAL] pgadmin3 and pgdesigner source

2010-12-05 Thread Raymond O'Donnell
On 05/12/2010 11:06, Rajinder Yadav wrote: I installed pgsql 9.0 from source on my linux box, where can I get the latest pgadmin3 and pgdesigner source? Dunno about pgDesigner, but pgAdmin is here: http://www.pgadmin.org/download/source.php Ray. -- Raymond O'Donnell :: Galway :: Ireland r

[GENERAL] an enhancement idea

2010-12-05 Thread John R Pierce
one of the reasons PostgreSQL is less popular with shared hosting services is that there is insufficient isolation between database users. For instance, one user leaves a pending due to sloppy programming, and the entire cluster eventually can't be vacuumed. There's numerous other places wh

Re: [GENERAL] Table design - postgresql solution

2010-12-05 Thread rsmogura
> Hi, > > I have a bit of a DB design question, associated with postgresql in > particular, hopefully thinking it could solve my dilemma. > > This is my setup of 3 tables: > > Table_1 > id_t1 > name > date_of_discovery > history > > Table_2 > id_t2 > name > type > size > > Table_3 > id_t3 > name >

Re: [GENERAL] One-click Installers for 9.1 Alpha 2 (ETA)

2010-12-05 Thread Stefan Keller
I've recently installed newest Postgres 9.1 Alpha 1 (postgresql-9.1alpha1-windows-binaries.zip from http://www.enterprisedb.com/products/pgbindownload.do ) and got a similar question around this: There's pgAdmin3 v.1.13 included but it still complains when opening a 9.1alpha db saying: "Warning: T

[GENERAL] pgadmin3 and pgdesigner source

2010-12-05 Thread Rajinder Yadav
I installed pgsql 9.0 from source on my linux box, where can I get the latest pgadmin3 and pgdesigner source? -- Kind Regards, Rajinder Yadav | DevMentor.org | Do Good! ~ Share Freely GNU/Linux: 2.6.35-22-generic Kubuntu x86_64 10.10 | KDE 4.5.1 Ruby 1.9.2p0 | Rails 3.0.1 -- Sent via pgsql-gen

Re: [GENERAL] Looking for auto starting procedures

2010-12-05 Thread mabra
Hello ! With server start, I mean the start of the postgresql engine, not the machine itself. I thought about a stored procedure to come into a LISTEN in a loop, but the loop must be started anyway [avoid a separate daemon {now, I know, I can use a pgsql script}]. LISTEN looks great to me [not tr