3,250
edits
Changes
Jump to navigation
Jump to search
Line 13:
Line 13: − + − + Line 24:
Line 24: − signal-event post-upgrade;signal-event reboot+ Line 31:
Line 31: − + − + + + + + + + + + + + +
→Version
|licence= AGPLv3
|licence= AGPLv3
|url= https://www.postgresql.org/
|url= https://www.postgresql.org/
|category= databases
|category= database
|tags=databases
|tags=database,db,pgsql
}}
}}
yum install smeserver-extrarepositories-pgsql -y
yum install smeserver-extrarepositories-pgsql -y
yum --enablerepo=smecontribs,pgsql13 install smeserver-postgresql
yum --enablerepo=smecontribs,pgsql13 install smeserver-postgresql
enable repo to allow further updates
enable repo to allow further updates
=== Upgrade ===
=== Upgrade ===
yum update {{#var:smecontribname}} {{#var:contribname}} --enablerepo=smecontribs
yum update {{#var:smecontribname}} --enablerepo=smecontribs
=== Uninstall ===
=== Uninstall ===
yum remove {{#var:smecontribname}} {{#var:contribname}}
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 ===
=== Bugs ===