Re: Postgresql setup on Debian system

[Gary Roach <gary719_list1@verizon.net>]

On 12/10/2013 11:13 PM, Raffaele Morelli wrote:

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?

Not too surprising that I wasn't clear. I feel like I'm floundering around. I am trying to build a data archiving system that will have multiple levels of users and has a web page access system. Python, Django, html and _javascript_ will take care of most of the project. I just need to get the permissions setup for Postgresql. Thanks for pointing out Chapter 19 of the manual. I haven’t read it yet but will do so asap. I guess I am primarily struggling with the setting up of accounts and roles; which I guess is about 90% of the database setup. I probably need to just read more and hope for the best.

Gary R.