I have setup a lot of mysql servers on different linux server configurations, particularly on debian and ubuntu and on several occassions I am required to setup postgresql as well. Setting up postgresql, well, I must say, a little bit complex in comparison to mysql. At first I thought that it would be easy and straightforward. I was wrong. I mean, it is not complex, it is just different. There are many tutorials on this but I haven’t found any “dummy” step-by-step tutorial that covers setting up superuser, creating database, creating user and granting privileges for postgresql.
There is an administration tool (pgadmin) to do all of this but I have found that the tool is badly designed for first time users. The tool will not give you any guidance on how to do things with it.Read on →