Changes

== 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:

  rom -q --whatrequires perl-CGI-Session perl-DBD-Pg

  rpm -q --whatrequires perl-CGI-Session perl-DBD-Pg

If that answers no packages need ... you can savely remove these packages  

If that answers no packages need ... you can safely remove these packages  

  yum remove perl-CGI-Session perl-DBD-Pg}}

  yum remove perl-CGI-Session perl-DBD-Pg}}

Enable centosplus repository and install postgres (at the time writen this howto is 8.1.9 version)

Enable centosplus repository and install postgres (at the time of writing this is version 8.1.9)

  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

Start postgres

===Start postgres===

  /etc/init.d/postgresql start

  /etc/init.d/postgresql start

Then make the necesary custom templates:

Then make the necessary custom templates:

  mkdir -p /etc/e-smith/templates/var/lib/pgsql/data

  mkdir -p /etc/e-smith/templates/var/lib/pgsql/data

  host    all    all    0.0.0.0 255.255.255.255  reject

  host    all    all    0.0.0.0 255.255.255.255  reject

Add a plus new 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:

  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:

To ensure everything is all right:

  signal-event post-upgrade

  signal-event post-upgrade

  signal-event reboot  

  signal-event reboot

 

To test if you have set postgres password correctly:

To test if you have set postgres password correctly:

  psql -U postgres -d template1

  psql -U postgres -d template1

and enter the password you have set above. If ok, you can enter at postgres console. Then exit:

and enter the password you have set above. If all is correct, you should enter the postgres console. Then exit:

  \q

  \q

References: [http://forums.contribs.org/index.php?topic=38250.msg173298#msg173298][http://www.issociate.de/board/post/272215/Fwd:_resetting_superuser_password.html]

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>

 

 

 

[[Category:Administration]]