Difference between revisions of "Phppgadmin"
Unnilennium (talk | contribs) |
Unnilennium (talk | contribs) |
||
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:// | + | | url = https://github.com/phppgadmin/phppgadmin/ |
− | |category= | + | | video = |
− | |tags= | + | | category = databases |
+ | | tags = pgsql,Postgresql | ||
}} | }} | ||
Revision as of 07:56, 27 December 2022
phppgadmin logo | |
Maintainer | Unnilennium |
---|---|
Url | https://github.com/phppgadmin/phppgadmin/ |
Licence | GNU General Public License |
Category | |
Tags | pgsql, Postgresql |
Maintainer
Version
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:
Changelog
Only released version in smecontrib are listed here.
- initial release for SME 10
- Remove http templates after rpm removal
- Fix bad sudoers permission
- cockpit. added to legacy apps
- Restart httpd service on trusted-network