Postgresql

Languages:

English

postgresql

postgresql logo
Url	https://www.postgresql.org/
Source:	smeserver-postgresql
Licence	AGPLv3
Category	database
Tags	ONLYOFFICE, database

Version

smecontribs 11:

0.2.0-6

smecontribs 10:

0.2.0-4

smeserver-postgresql

The latest version of smeserver-postgresql is available in the SME repository, click on the version number(s) for more information.

version	publication date	EOL date
18	25 Sep 2025	14 Nov 2030
17	26 Sep 2024	08 Nov 2029
16	14 Sep 2023	09 Nov 2028
15	13 Oct 2022	11 Nov 2027
14	30 Sep 2021	12 Nov 2026

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 (5 tasks) ⇒
13460	SME Contribs	11.0	CONFIRMED	pgsql13 not available anymore
12976	SME Contribs	11.0	CONFIRMED	create a superuser and few fixes
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 11 (smecontribs)

2024/09/08 fix-e-smith-pkg.sh by Trevor Batley 0.2.0-6.sme
- Fix e-smith references in smeserver-postgresql [SME: 12732]

2024/09/07 cvs2git.sh aka Brian Read 0.2.0-5.sme
- Roll up patches and move to git repo [SME: 12338]

2024/09/07 BogusDateBot
- Eliminated rpmbuild "bogus date" warnings due to inconsistent weekday,

by assuming the date is correct and changing the weekday.

2022/12/26 Jean-Philippe Pialasse 0.2.0-4.sme
- 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]

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]

2022/12/12 Jean-Philippe Pialasse 0.2.0-3.sme
- fix pre-backup event fails error 256 [SME: 12264]

2022/12/02 Jean-Philippe Pialasse 0.2.0-2.sme
- fix preset OUT missing

2021/11/17 Michel Begue 0.2.0-1
- First import to Sme 10 (postgresql13)

2007/09/11 Charlie Brady 0.0.1-24
- Add support for localhost/private/public access settings to

determine which network interfaces to bind to.

References

1. RE: How do I install postgreSQL 8+ by hedererjs
2. Resetting the postgres superuser password

---