Phppgadmin

Languages:

English

phppgadmin

phppgadmin logo
Maintainer	Unnilennium
Url	https://github.com/phppgadmin/phppgadmin/
Licence	GNU General Public License
Category	databases
Tags	pgsql, Postgresql

Maintainer

JP Pialasse

Version

Contrib 10:

1.5.0-1

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

For SME 10

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