Re: embedded/"serverless" (Re: serverless postgresql)

Tom Lane wrote:

>Jeff Bowden <jlb@houseofdistraction.com> writes:
>  
>
>>Still, the main problem I, and I suspect others, would like to solve is 
>>installation/configuration.  For my app I don't want the user to have to 
>>understand anything about how keeping data in a shared 
>>system-administered database is different from keeping data in local 
>>files.  Everything should "just work".
>>    
>>
>
>Sure, but most of the existing packagings of PG already try to make this
>automatic (at least Lamar's RPMs and Oliver's Debian package do).  No
>doubt further work could be invested to make it even smoother, but that
>doesn't mean we need a client-started database.
>

So maybe this is a packaging issue.  On Debian when I install postgres 
it is necessary to do root shit in order to enable non-priveledged users 
to create and destroy databases.  My understanding has alwasy been that 
these operations are restricted because it can allow users to 
accidentally or intentionally interefere with each other's use of the 
server.  If there is some way for this to be set up sanely by default to 
allow users to successfully use createdb and dropdb on only their own 
data, then I will file a wishlist bug against the Debian packages to add 
this.  Or is this all a pipe dream?