Changes
From SME Server
Jump to navigation
Jump to search
← Older edit
Newer edit →
Postgresql
(view source)
Revision as of 10:00, 4 November 2007
346 bytes added
,
10:00, 4 November 2007
no edit summary
Line 30:
Line 30:
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
Line 50:
Line 50:
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:
Line 74:
Line 74:
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
PicsOne
985
edits
Navigation menu
Page actions
Page
Discussion
View source
History
Page actions
Page
Discussion
More
Tools
In other languages
Personal tools
English
Log in
Koozali SME Server
Main Page
Welcome
Releases
Testimonials
Documentation
SME Server FAQ
Volunteering
Commercial Support
Recent activities
Dashboard
Recent wiki changes
Recent bug changes
Unread Forum posts
Koozali resources
Contribs
How-To's
Forums
Bugzilla
Mailing Lists
Translations
Download
Koozali SME Server wiki
Wiki statistics
Wiki categories
Wiki Help
Koozali Wiki Help
Tools
Special pages
Printable version
Search