Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] pgaccess - where to store the own data

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Joe Conway" <mail(at)joeconway(dot)com>,"Iavor Raytchev" <iavor(dot)raytchev(at)verysmall(dot)org>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>,"pgsql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [HACKERS] pgaccess - where to store the own data
Date: 2002-08-30 15:58:35
Message-ID: 03AF4E498C591348A42FC93DEA9661B88446@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces

> -----Original Message-----
> From: Joe Conway [mailto:mail(at)joeconway(dot)com] 
> Sent: 30 August 2002 16:52
> To: Iavor Raytchev
> Cc: pgsql-hackers; pgsql-interfaces
> Subject: Re: [HACKERS] [INTERFACES] pgaccess - where to store 
> the own data
> 
> 
> Iavor Raytchev wrote:
> > Hello everybody,
> > 
> > There is an open question we need broad opinion on.
> > 
> > Currently pgaccess stores its own data in the database it 
> works with. 
> > Some people do not like that. To store it elsewhere invokes 
> a number 
> > of issues such as:
> > 
> > - where is this somewhere
> > - converting form all versions to the new
> > - etc.
> > 
> > What do people think about this. Is it so bad that the own data is 
> > stored in the database pgaccess works with?
> > 
> 
> I don't particularly like it. Oracle deals with this by having a 
> database unto itself as a management repository (Oracle Enterprise 
> Manager, OEM, I believe). You register the database you want 
> to manage 
> with the repository, and the metadata is kept there instead 
> of in each 
> managed database.

I thought of using that approach with pgAdmin, but how do you ensure
that new users use the correct database as the repository, or, if you
hard coded it to use a 'pgaccess' database (for example), how do you
deal with security etc on a shared system such as might be run by an
isp?

Of course, in 7.3 you could just create a pgaccess schema in each
database...

Regards, Dave.

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2002-08-30 16:06:25
Subject: Re: contrib features during beta period
Previous:From: Joe ConwayDate: 2002-08-30 15:56:47
Subject: make failure on cvs tip

pgsql-interfaces by date

Next:From: John L. TurnerDate: 2002-08-30 16:57:22
Subject: Re: pgaccess - where to store the own data
Previous:From: Joe ConwayDate: 2002-08-30 15:51:44
Subject: Re: pgaccess - where to store the own data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group