Hi All,
I follwed this howto -
http://wiki.contribs.org/Postgres - and all went _exactly_ as shown apart from ;
alter user postgres with encrypted password 'add_your_pass_here';
needs to be
ALTER USER postgres WITH ENCRYPTED PASSWORD 'yourpass';
I have a minor query though when loging in with ;
# su postgres
# psql -U postgres -d template1
I get minor error message before loging me in
"could not change directory to /root"
Is this just noise or I do I need to investigate?