Re: Postgresql setup on Debian system

[Raffaele Morelli <raffaele.morelli@gmail.com>]

2013/12/11 Gary Roach <gary719_list1@verizon.net>

I just switched from using PHP and Mysql to Python / Django and Postgresql. I am having trouble with the setup of Postgresql permissions. I am locked out of some parts of the system and am unsure when to use postgres login vs user login. Most of the Postgresql instructions are written for non-debian like installations. They have one do a bunch of things that Debian does automatically (I think). I found the Debian README confusing, especially in regards to setting up a special shell that I don't think I need. Most of the instructions seem to have already been done automatically.

Debian does not tweak things for you, the special shell you are talking about is just (I guess) the psql terminal interface to postgres.

Postgres permissions administration is not trivial and if you are looking for security on a per database basis you should read carefully how it works.

http://www.postgresql.org/docs/9.1/static/client-authentication.html

BTW you are not clear: what are you trying to achieve?