3,250
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + − + + − {{Warning box|The above command install '''postgres''' and update '''postgres-libs''', and install for dependency '''tcl''' and '''mx''' from '''base''' repository. If you see other packages, such as '''perl''' or '''php''', '''abort the installation now!'''. This occur because maybe you have installed '''perl-CGI-Session''' or '''perl-DBD-Pg'''. These two packages are in your system because you have installed '''otrs''' or another aplication. In my case I have remove these two packages (because I not need '''otrs''' any more), and run again the installation.}}+ − Enable centosplus repository and install postgres (at the time writen this howto is 8.1.9 version)+ + − yum --enablerepo=centosplus install postgresql postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test − Start postgres+ + + − /etc/init.d/postgresql start + + − Then make the necesary custom templates:+ + − mkdir -p /etc/e-smith/templates/var/lib/pgsql/data+ − mkdir -p /etc/e-smith/templates-custom/var/lib/pgsql/data+ − cp /var/lib/pgsql/data/postgresql.conf /etc/e-smith/templates/var/lib/pgsql/data − cp /var/lib/pgsql/data/pg_hba.conf /etc/e-smith/templates/var/lib/pgsql/data − cp /var/lib/pgsql/data/postgresql.conf /etc/e-smith/templates-custom/var/lib/pgsql/data − cp /var/lib/pgsql/data/pg_hba.conf /etc/e-smith/templates-custom/var/lib/pgsql/data − Now login as postgres user:+ + + − su postgres+ + + − Then access to superuser database, set a password and exit. + + + − psql -U postgres -d template1+ − alter user postgres with encrypted password 'add_your_pass_here'; − \q − exit − Edit the file '''/etc/e-smith/templates-custom/var/lib/pgsql/data/postgresql.conf''' remove # and change the following settings:+ + − superuser_reserved_connections=2+ − ssl = on − password_encryption = on − listen_addresses = 'localhost' − Then copy your server SSL keys: − cd /var/lib/pgsql/data+ − cp /etc/httpd/conf/ssl.crt/server.crt . + − cp /etc/httpd/conf/ssl.key/server.key .+ − chown postgres:postgres server.*+ − + − Edit the file '''/etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf''' and change the following settings:+ − − local all all md5 − host all all 127.0.0.1/32 md5 − host all all ::1/128 md5 − − and add at the end: − − host all all 0.0.0.0 255.255.255.255 reject − − Add a plus new white line at the end. − − Expand template: − − expand-template /var/lib/pgsql/data/pg_hba.conf − expand-template /var/lib/pgsql/data/postgresql.conf − − Restart with new settings: − − /etc/init.d/postgresql stop − /etc/init.d/postgresql start − − and add the symlinks to start automatically: − − ln -s /etc/init.d/postgresql /etc/rc.d/rc7.d/S56postgresql − 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
→Version
== How to install Postgres 8 ==
{{Languages}}
<!-- here we define the contrib name variable -->
<!-- we get the page title, remove suffix for translated version; if needed you can define there with the value you want-->
{{#vardefine:contribname| {{lc: {{#titleparts: {{BASEPAGENAME}} |1}} }} }}
{{#vardefine:smecontribname| smeserver-{{lc: {{#titleparts: {{BASEPAGENAME}} |1}} }} }}
<!-- we define the language -->
{{#vardefine:lang| {{lc: {{#titleparts: {{PAGENAME}} | | -1}} }} |en }}
{{Infobox contribs
|name={{#var:contribname}}
|image=Postgresql.png
|description_image= {{#var:contribname}} logo
|maintainer=
|licence= AGPLv3
|url= https://www.postgresql.org/
|category= database
|tags=database,db,pgsql
}}
{{Note box|This howto are created with information extracted from forums. Proceed at your own risk. Work for me.}}
===Version===
{{#smeversion:smeserver-postgresql}}
===Install Postgresql 13===
yum install smeserver-extrarepositories-pgsql -y
yum --enablerepo=smecontribs,pgsql13 install smeserver-postgresql
enable repo to allow further updates
db yum_repositories setprop pgsql13 status enabled
signal-event yum-modify
=== Upgrade ===
yum update {{#var:smecontribname}} --enablerepo=smecontribs
=== Uninstall ===
yum remove {{#var:smecontribname}} {{#var:contribname}}*
=== Manually restore db ===
after you upgraded you server or migrate, here how to restore db
using psql<syntaxhighlight lang="bash">
exec chpst -u postgres /usr/pgsql-13/bin/psql < /home/e-smith/db/pgsql/pgsql.dump
</syntaxhighlight>using pg_restore
<syntaxhighlight lang="bash">
exec chpst -u postgres /usr/pgsql-13/bin/pg_restore < /home/e-smith/db/pgsql/pgsql.dump
</syntaxhighlight>
=== Bugs ===
Please raise bugs under the SME-Contribs section in [http://bugs.contribs.org/enter_bug.cgi bugzilla]
and select the {{#var:smecontribname}} component or use {{BugzillaFileBug|product=SME%20Contribs|component={{#var:smecontribname}}|title=this link}}
Below is an overview of the current issues for this contrib:{{#bugzilla:columns=id,product,version,status,summary|sort=id|order=desc|component={{#var:smecontribname}} |noresultsmessage=No open bugs found.}}
===Changelog===
Only released version in smecontrib are listed here.
{{#smechangelog: {{#var:smecontribname}} }}
===References===
<ol><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:Contrib]]
[[Category:Administration]]