Re: [pg_hba.conf] publish own Python application using PostgreSQL - Mailing list pgsql-general

From John R Pierce
Subject Re: [pg_hba.conf] publish own Python application using PostgreSQL
Date
Msg-id 559B5F56.3060208@hogranch.com
Whole thread Raw
In response to Re: [pg_hba.conf] publish own Python application using PostgreSQL  (<c.buhtz@posteo.jp>)
Responses Re: [pg_hba.conf] publish own Python application using PostgreSQL  (John McKown <john.archie.mckown@gmail.com>)
List pgsql-general
On 7/6/2015 9:55 PM, c.buhtz@posteo.jp wrote:
> On 2015-07-05 22:16 John R Pierce<pierce@hogranch.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



pgsql-general by date:

Previous
From:
Date:
Subject: Re: [pg_hba.conf] publish own Python application using PostgreSQL
Next
From: pinker
Date:
Subject: pg_dump (PostgreSQL) 9.4.1 - delay in checking if file exists