Phppgadmin

From SME Server
Jump to navigationJump to search




phppgadmin
NeedImage.svg
phppgadmin logo
MaintainerUnnilennium
Urlhttps://github.com/phppgadmin/phppgadmin/
LicenceGNU General Public License
Category

databases

Tags pgsqlPostgresql


Maintainer

JP Pialasse

Version

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


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


Description

phpPgAdmin is a mature web-based administration tool for PostgreSQL, for more information on phpPgAdmin

Installation

yum --enablerepo=smecontribs install smeserver-phppgadmin

then you can point your browser to https://URL/phppgadmin/ and use admin as user and password from

config getprop phppgadmin Password

Configuration

you can list the available configuration with the following command :

config show phppgadmin

Some of the properties are not shown, but are defaulted in a template or a script. Here a more comprehensive list with default and expected values :

property default values
Password GENERATED string for mysql db
access private private, public
status enabled enabled,disabled

you can also alter php-fpm value if needed for php.


allow public access

config setprop phppgadmin access public
signal-event smeserver-phppgadmin-update

disable the web access

config setprop phppgadmin status disabled
signal-event  smeserver-phppgadmin-update

Connect as super user

at your own risks

sudo -Hiu postgres $psql -c "ALTER ROLE admin WITH superuser;"

remove this

sudo -Hiu postgres $psql -c "ALTER ROLE admin WITH nosuperuser;"

Uninstall

yum remove smeserver-phppgadmin  phppgadmin

Bugs

Please raise bugs under the SME-Contribs section in bugzilla

and select the smeserver-phppgadmin component or use this link


Below is an overview of the current issues for this contrib:

No open bugs found.

Changelog

Only released version in smecontrib are listed here.

smeserver-phppgadmin Changelog: SME 10 (smecontribs)
2022/12/26 Jean-Philippe Pialasse 1.5.0-1
- initial release for SME 10
2020/07/05 stephane de Labrusse 1.0.2
- Remove http templates after rpm removal
2020/03/05 stephane de Labrusse 1.0.1-1.ns7
- Fix bad sudoers permission
2019/10/14 Stephane de Labrusse 0.0.4-1.ns7
- cockpit. added to legacy apps
2017/09/10 Stephane de Labrusse - 0.0.3-1.ns7
- Restart httpd service on trusted-network