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 ==
If you see other packages, such as '''perl''' or '''php''', '''abort the installation'''. This might occur because you have installed '''perl-CGI-Session''' or '''perl-DBD-Pg'''. These two packages might be on your system because you have installed '''otrs''' or another aplication. You can check if they are still needed:
If you see other packages, such as '''perl''' or '''php''', '''abort the installation'''. This might occur because you have installed '''perl-CGI-Session''' or '''perl-DBD-Pg'''. These two packages might be on your system because you have installed '''otrs''' or another aplication. You can check if they are still needed:
rpm -q --whatrequires perl-CGI-Session perl-DBD-Pg
If that answers no packages need ... you can safely remove these packages
If that answers no packages need ... you can safely remove these packages
yum --enablerepo=centosplus install postgresql postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test
yum --enablerepo=centosplus install postgresql postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test
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]]
