Let's asume I got convinced by your advocacy and decided to install and play a bit with PostgreSQL to discover it's features and how I can use them.
Installation went fine. I decided to read the long version.. at some point I was told to create a user postgres.
I didn't find recommended settings for this user like if it needs a shell and where the users homedir is supposed to be.. I mean.. I can understand that PostgreSQL would require something simular to MySQL.. if it does.. then I would expect it to be in the docs->installation->long version.
Here I find myself behind a Linux box that can't connect via PHP.. solved that one too.. Found the solution quicker on PHP.net then on postgresql.org.. even searched for postmaster -i (and other keywords I could think of) on postgresql.org.. no results.. FWIW.. seaching for the keyword postmaster did turn up the app_postmaster page..
Long story short, in order to get things going a newcomer needs to search a lot (preferrable Google) and doesn't find all the information in the getting started section... or at the first place he/she looks: the docs found at postgresql.org.. I'm quite sure the information is there but the way to it is not always logical.... IMHO :-)
I'm not assuming to be spoon fed but a more clear/accessible manual would certainly help..
Would be nice if there was a table showing the commands used in MySQL (mysql) and the commands with the same result used in PostgreSQL (psql)..
Just my EUR 0,02
B.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
