Como Gestionar Varios Servidores de Bases de Datos desde IGU

Héctor Louzao, Rafael Fontenelle Versión F38 Last review: 2023-01-04

Para gestionar base de datos, es más usuario-amistoso para emplear herramientas gráficas:

  • MySQL/MariaDB:

    • phpMyAdmin.noarch : Un interfaz de web para MySQL y MariaDB

sudo dnf install phpMyAdmin

  • Específico de MySQL:

    • MySQL Workbench es una herramienta visual unificada para arquitectos de bases de datos, desarrolladores y administradores de bases de datos.

  • Mezclado:

    • Comunidad DBeaver Gestor Universal de Base de Datos.

flatpak install io.dbeaver.DBeaverCommunity

  • PostgreSQL client for DBeaver Community

flatpak install io.dbeaver.DBeaverCommunity.Client.pgsql

  • MariaDB client for DBeaver Community

flatpak install io.dbeaver.DBeaverCommunity.Client.mariadb

  • PostgreSQL:

    • pgadmin3 Graphical client for PostgreSQL

sudo dnf install pgadmin3

  • phpPgAdmin - A web interface for PostgreSQL

for Fedora ⇐ 32

sudo dnf install phpPgAdmin

for Fedora >= 33

Instalación

The installation of the postgresql GUI web-server is a little bit different in comparison to older Fedora because the package is out of the repo.

  1. We assume you have php installed on your server and Working.

  2. Download the latest from GitHub repo:

https://github.com/phppgadmin/phppgadmin/releases

sudo tar xf phpPgAdmin-x.y.z.tar.bz2 -C /var/www/phpPgadmin

In order to make phpPgAdmin navigable, we create a configuration file for the web service (Apache in this case):

sudo nano /etc/httpd/conf.d/phpPgAdmin.conf

The content will be an alias that will point to the installation path of the application:

Alias /phppgadmin /var/www/phpPgAdmin

Save the file and Reload the Web Service:

sudo systemctl reload httpd

phpPgAdmin requires the presence in Fedora 31 of certain PHP extensions, mainly the one that allows the connection with the database service, which we will install from the system repositories:

sudo dnf install -y php-pgsql

To access the web installer of phpPgAdmin in Fedora from a browser we will indicate the IP address or DNS name of the server followed by the alias we have defined and follow the steps requested.

¿Ve algún error tipográfico, algo desaparecido u obsoleto o algo que pueda ser mejorado? Edite este documento en https://pagure.io/fedora-docs/quick-docs.

Want to help? Learn how to contribute to Fedora Docs ›