Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: gbentley on July 16, 2009, 10:42:04 AM

Title: Query on Postgres Howto
Post by: gbentley on July 16, 2009, 10:42:04 AM

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?