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

2015-07-08 Thread John McKown
On Wed, Jul 8, 2015 at 3:55 AM, Karsten Hilbert wrote: > On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown 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

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

2015-07-08 Thread Karsten Hilbert
On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown 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

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

2015-07-07 Thread John McKown
On Tue, Jul 7, 2015 at 12:10 AM, John R Pierce wrote: > On 7/6/2015 9:55 PM, c.bu...@posteo.jp wrote: > >> On 2015-07-05 22:16 John R Pierce wrote: >> >>> >at a bare minimum, a database administrator needs to create database >>> >roles (users) and databases for an app like yours. >>> >> The admi

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

2015-07-06 Thread John R Pierce
On 7/6/2015 9:55 PM, c.bu...@posteo.jp wrote: On 2015-07-05 22:16 John R Pierce 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-util

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

2015-07-06 Thread c.buhtz
On 2015-07-05 22:16 John R Pierce 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. But I see. I will go ba

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

2015-07-06 Thread Adrian Klaver
On 07/05/2015 09:43 PM, c.bu...@posteo.jp wrote: On 2015-07-05 15:13 Jan de Visser wrote: You could set up a whole new server with a different $PGDATA on a different port. I (and the user) don't want to setup anything - that is the point. Then what you want is an embedded database, in other

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

2015-07-06 Thread Mark Morgan Lloyd
Jan de Visser wrote: On July 6, 2015 06:43:53 AM c.bu...@posteo.jp wrote: On 2015-07-05 15:13 Jan de Visser wrote: You could set up a whole new server with a different $PGDATA on a different port. I (and the user) don't want to setup anything - that is the point. Well, you don't have to set

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

2015-07-06 Thread Jan de Visser
On July 6, 2015 06:43:53 AM c.bu...@posteo.jp wrote: > On 2015-07-05 15:13 Jan de Visser wrote: > > You could set up a whole new server with a different $PGDATA on a > > different port. > > I (and the user) don't want to setup anything - that is the point. Well, you don't have to setup anything.

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

2015-07-05 Thread John R Pierce
On 7/5/2015 9:43 PM, c.bu...@posteo.jp wrote: But isn't there a way to use PostgreSQL without that setup and configuration things? no, not really, as its a generic database server meant to be used by multiple applications across a network, with a wide range of configuration options, plugins a

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

2015-07-05 Thread c.buhtz
On 2015-07-05 15:13 Jan de Visser wrote: > You could set up a whole new server with a different $PGDATA on a > different port. I (and the user) don't want to setup anything - that is the point. > What I'm wondering though is what made you decide to use pgsql for > your project? It seems to me th

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

2015-07-05 Thread Jan de Visser
On July 5, 2015 08:58:17 PM c.bu...@posteo.jp wrote: > On 2015-07-05 15:11 Charles Clavadetscher > > wrote: > > I am not really an expert, but from your description I guess that you > > assume an existing PostgreSQL installation on your customers' server. > > The application is a simple open sou

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

2015-07-05 Thread John R Pierce
On 7/5/2015 3:15 AM, c.bu...@posteo.jp wrote: These are the modification I have to do to make my application run with the connetion string "postgres://puser@localhost/FoobarTest". The settings are about the /etc/postgresql/9.3/main/pg_hba.conf file. There I change this line hostall

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

2015-07-05 Thread c.buhtz
On 2015-07-05 15:11 Charles Clavadetscher wrote: > I am not really an expert, but from your description I guess that you > assume an existing PostgreSQL installation on your customers' server. The application is a simple open source using a local PostgreSQL database. The customer is just any use

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

2015-07-05 Thread Charles Clavadetscher
Hi I am not really an expert, but from your description I guess that you assume an existing PostgreSQL installation on your customers' server. If that is the case you probably won't get around giving instructions to your customer and let them do the change. I would not like to install applica

[GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

2015-07-05 Thread c.buhtz
I have my own Python application using a PostgreSQL database over SQLAlchemy. Currently I pack the application in a deb-file. After installation (on a fresh system! Ubuntu 14.04.2) it doesn't run because of some PostgreSQL-settings. Of course I understand why and I know (a little bit) which settin