Re: create create of database of a particular name

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Chris Withers <chris(at)simplistix(dot)co(dot)uk>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: create create of database of a particular name
Date: 2016-03-09 14:53:34
Message-ID: 56E038EE.8040403@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/09/2016 05:49 AM, Chris Withers wrote:
> Hi All,
>
> Django, a popular python web framework, runs its unit tests by creating
> a 'test_'-prefixed database and then dropping it at the end of the test
> run.

FYI in Django 1.8+ you can prevent that:

https://docs.djangoproject.com/en/1.8/topics/testing/overview/#the-test-database

" New in Django 1.8:

You can prevent the test databases from being destroyed by adding the
--keepdb flag to the test command. This will preserve the test database
between runs. If the database does not exist, it will first be created.
Any migrations will also be applied in order to keep it up to date.
"
>
> Is there any way I can grant a user in postgres the ability only to
> create a database of a particular name?

Not that I know of.

>
> cheers,
>
> Chris
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Withers 2016-03-09 15:02:45 Re: create create of database of a particular name
Previous Message Wyatt Sanford 2016-03-09 14:35:00 How to setup Active Directory users in Postgres 9.3.11