Difference between revisions of "Phppgadmin"

From SME Server
Jump to navigationJump to search
Line 7: Line 7:
 
{{#vardefine:lang| {{lc:  {{#titleparts:    {{PAGENAME}} | | -1}}  }} |en }}
 
{{#vardefine:lang| {{lc:  {{#titleparts:    {{PAGENAME}} | | -1}}  }} |en }}
 
{{Infobox contribs
 
{{Infobox contribs
|name={{#var:contribname}}
+
| name = {{#var:contribname}}
|image={{#var:contribname}}.jpg
+
| image = {{#var:contribname}}.jpg
|description_image= {{#var:contribname}} logo
+
| description_image = {{#var:contribname}} logo
|maintainer= Unnilennium
+
| maintainer = Unnilennium
|licence= GNU General Public License  
+
| licence = GNU General Public License
|url= https://wiki.koozali.org
+
| url = https://github.com/phppgadmin/phppgadmin/
|category= Category you want
+
| video =
|tags=File,this,with,a,list,of,tags
+
| category = databases
 +
| tags = pgsql,Postgresql
 
}}
 
}}
  

Revision as of 07:56, 27 December 2022




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.

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