Difference between revisions of "Postgresql"
From SME Server
Jump to navigationJump to searchUnnilennium (talk | contribs) |
Unnilennium (talk | contribs) |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 13: | Line 13: | ||
|licence= AGPLv3 | |licence= AGPLv3 | ||
|url= https://www.postgresql.org/ | |url= https://www.postgresql.org/ | ||
| − | |category= | + | |category= database |
| − | |tags= | + | |tags=database,db,pgsql |
}} | }} | ||
| Line 24: | Line 24: | ||
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 | ||
| Line 31: | Line 31: | ||
=== Upgrade === | === Upgrade === | ||
| − | yum update {{#var:smecontribname | + | 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 === | ||
Latest revision as of 17:42, 12 December 2022
 | |
| postgresql logo | |
| Url | https://www.postgresql.org/ |
|---|---|
| Licence | AGPLv3 |
| Category | |
| Tags | database, db, pgsql |
Version
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 smeserver-postgresql --enablerepo=smecontribs
Uninstall
yum remove smeserver-postgresql postgresql*
Manually restore db
after you upgraded you server or migrate, here how to restore db
using psql
exec chpst -u postgres /usr/pgsql-13/bin/psql < /home/e-smith/db/pgsql/pgsql.dump
using pg_restore
exec chpst -u postgres /usr/pgsql-13/bin/pg_restore < /home/e-smith/db/pgsql/pgsql.dump
Bugs
Please raise bugs under the SME-Contribs section in bugzilla and select the smeserver-postgresql component or use this link
Below is an overview of the current issues for this contrib:
| ID | Product | Version | Status | Summary (3 tasks) ⇒ |
|---|---|---|---|---|
| 12366 | SME Contribs | 10.0 | UNCONFIRMED | datestyle on en_US needs to be mdy, not dmy. |
| 12355 | SME Contribs | 10.0 | UNCONFIRMED | Shutdown errors detected and logged during shutdown of Postgres 13. |
| 12083 | SME Contribs | 10.0 | CONFIRMED | NFR rewrite contrib to be able to run multiple pgsql version at once |
Changelog
Only released version in smecontrib are listed here.
smeserver-postgresql Changelog: SME 10 (smecontribs)
2022/12/26 Jean-Philippe Pialasse 0.2.0-4.sme
- fix failing pgsql.init service preventing restore [SME: 12290]
- fix failing pgsql.init service preventing restore [SME: 12290]
2022/12/12 Jean-Philippe Pialasse 0.2.0-3.sme
- fix pre-backup event fails error 256 [SME: 12264]
- fix pre-backup event fails error 256 [SME: 12264]
2022/12/02 Jean-Philippe Pialasse 0.2.0-2.sme
- fix preset OUT missing
- fix preset OUT missing
2021/11/17 Michel Begue 0.2.0-1
- First import to Sme 10 (postgresql13)
- First import to Sme 10 (postgresql13)
2007/09/11 Charlie Brady 0.0.1-24
- Add support for localhost/private/public access settings to
