Re: [pg_hba.conf] publish own Python application using PostgreSQL

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [pg_hba.conf] publish own Python application using PostgreSQL
Date: 2015-07-07 05:10:46
Message-ID: 559B5F56.3060208@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/6/2015 9:55 PM, c(dot)buhtz(at)posteo(dot)jp wrote:
> On 2015-07-05 22:16 John R Pierce<pierce(at)hogranch(dot)com> wrote:
>> >at a bare minimum, a database administrator needs to create database
>> >roles (users) and databases for an app like yours.
> The admin don't need to create the db. It is done by the application
> (sqlalchemy-utils on Python3) itself.

an application should not have the privileges to do that. you don't
run your apps as 'root', do you? why would you run them as a database
administrator ?

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pinker 2015-07-07 09:26:16 pg_dump (PostgreSQL) 9.4.1 - delay in checking if file exists
Previous Message c.buhtz 2015-07-07 04:55:16 Re: [pg_hba.conf] publish own Python application using PostgreSQL