Postgresql
From SME Server
(Redirected from Postgres)
Jump to navigationJump to search
 | |
| 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
