985
edits
Changes
From SME Server
Jump to navigationJump to searchno edit summary
psql -U postgres -d template1
psql -U postgres -d template1
alter user postgres with encrypted password 'xxxxx';
alter user postgres with encrypted password 'add_your_pass_here';
\q
\q
exit
exit
Edit the file '''/etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf''' and change the following settings:
Edit the file '''/etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf''' and change the following settings:
local all all md5
local all all md5
host all all 127.0.0.1/32 md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
host all all ::1/128 md5
and add at the end:
and add at the end:
ln -s /etc/init.d/postgresql /etc/rc.d/rc7.d/S56postgresql
ln -s /etc/init.d/postgresql /etc/rc.d/rc7.d/S56postgresql
ln -s /etc/init.d/postgresql /etc/rc.d/rc6.d/K03postgresql
ln -s /etc/init.d/postgresql /etc/rc.d/rc6.d/K03postgresql
To ensure are all ok:
signal-event post-upgrade
signal-event reboot
To test if you have set postgres password correctly:
su postgres
psql -U postgres -d template1
and enter the password you have set above. If ok, you can enter at postgres console. Then exit:
\q
and exit from postgres user:
exit
