New to PostgreSQL.. not to databases.. or Linux in general..
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.