From: | <c(dot)buhtz(at)posteo(dot)jp> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | [pg_hba.conf] publish own Python application using PostgreSQL |
Date: | 2015-07-05 10:15:53 |
Message-ID: | 3mPQst2rk5zFpW7@dovecot04.posteo.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 settings I
have to do to make it run.
But the point is I don't want to plague my user to do that.
How could this be solved?
How can I release a application using a local PostgreSQL-database.
I am not sure if the modifications I do are correct or elegant (see
below).
These are the modification I have to do to make my application run with
the connetion string "postgres://puser(at)localhost/FoobarTest".
The settings are about
the /etc/postgresql/9.3/main/pg_hba.conf file.
There I change this line
host all all 127.0.0.1/32 md5
to
host all all 127.0.0.1/32 trust
I have to create a user without a password (beside the admin/postgres),
too.
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Clavadetscher | 2015-07-05 13:11:05 | Re: [pg_hba.conf] publish own Python application using PostgreSQL |
Previous Message | Chris Mair | 2015-07-05 09:04:31 | Re: trouble converting several serial queries into a parallel query |