Re: Need some help creating a database sandbox...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric D(dot) Nielsen" <nielsene(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need some help creating a database sandbox...
Date: 2005-08-03 03:33:44
Message-ID: 27015.1123040024@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Eric D. Nielsen" <nielsene(at)mit(dot)edu> writes:
> ... simplest way I thought would be to have the testing tools drop/create
> the testing database on every test case, and then populate the
> database from a specified file. However I don't want to give the
> test user superuser privileges. Thus I don't think I can restrict it
> to only drop/create a single named DB.

CREATEDB is a pretty restricted privilege --- I don't actually see
the problem here?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message chiranjeevi.i 2005-08-03 03:38:48 How to write jobs in postgresql
Previous Message Eric D. Nielsen 2005-08-03 03:12:08 Need some help creating a database sandbox...