3,704
edits
Changes
From SME Server
Jump to navigationJump to searchno edit summary
{{Note box|For SME Server 9.x, 64-bit, we advise you to use [[Software_Collections:PostgreSQL]]}}
== How to install Postgres 8 ==
== How to install Postgres 8 ==
After install, ignore the post-upgrade and restart message
After install, ignore the post-upgrade and restart message
Start postgres
===Start postgres===
/etc/init.d/postgresql start
/etc/init.d/postgresql start
host all all 0.0.0.0 255.255.255.255 reject
host all all 0.0.0.0 255.255.255.255 reject
Be sure to add an extra white line at the end.
'''Be sure to add an extra white line at the end.That why you got an extra line on above box!'''
Expand template:
Expand template:
signal-event post-upgrade
signal-event post-upgrade
signal-event reboot
signal-event reboot
===Testing your environment===
To test if you have set postgres password correctly:
To test if you have set postgres password correctly:
References: <ol></li><li>[http://forums.contribs.org/index.php?topic=38250.msg173298#msg173298 RE: How do I install postgreSQL 8+] by hedererjs</li><li>
References: <ol></li><li>[http://forums.contribs.org/index.php?topic=38250.msg173298#msg173298 RE: How do I install postgreSQL 8+] by hedererjs</li><li>
[http://www.issociate.de/board/post/272215/Fwd:_resetting_superuser_password.html Resetting the postgres superuser password]</li></ol>
[http://www.issociate.de/board/post/272215/Fwd:_resetting_superuser_password.html Resetting the postgres superuser password]</li></ol>
==How to Remove==
rpm -e postgresql.i386 postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-test postgresql-server postgresqlclient7 postgresql-python
----
----
[[Category:Howto]]
[[Category:Howto]]
[[Category:Administration]]
