{"id":3517,"date":"2022-06-18T14:26:10","date_gmt":"2022-06-18T19:26:10","guid":{"rendered":"https:\/\/linuxitos.com\/main\/?p=3517"},"modified":"2022-11-20T01:34:42","modified_gmt":"2022-11-20T07:34:42","slug":"instalar-pgadmin4-fedora-36","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/instalar-pgadmin4-fedora-36\/","title":{"rendered":"Instalar pgAdmin4 | Fedora 36"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-00.png\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"600\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-00.png\" alt=\"\" class=\"wp-image-3519\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-00.png 750w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-00-300x240.png 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><figcaption class=\"wp-element-caption\">Imagen 1<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Introducci\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">B\u00e1sicamente es una aplicaci\u00f3n gr\u00e1fica desarrollada con python que implementa las siguientes tecnolog\u00edas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Flask para el Backend.<\/li>\n\n\n\n<li>Soporte Python en sus versiones: 2.7.x y 3.0 a 3.4<\/li>\n\n\n\n<li>Javascript\/Jquery\/Backbone para el FrondEnd<\/li>\n\n\n\n<li>Bootstrap<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">A diferencia a su versi\u00f3n anterior que est\u00e1 desarrollada con C++. \u00c9sta aplicaci\u00f3n sirve para gestionar el gestor de BD de PostgreSQL, y es considerada una de las m\u00e1s completas y populares con licencia Open Source y est\u00e1 disponible en diferente idiomas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PgAdmin 4 nos permite acceder a todas las funcionalidades de la base de datos, consulta, manipulaci\u00f3n y gesti\u00f3n de datos, incluso opciones avanzadas como manipulaci\u00f3n del motor de replicaci\u00f3n Slony-I. Esta puede ser ejecutas en m\u00faltiples plataformas como:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Linux<\/li>\n\n\n\n<li>FreeBSD<\/li>\n\n\n\n<li>Solaris<\/li>\n\n\n\n<li>Mac OS X<\/li>\n\n\n\n<li>Windows<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Su interfaz gr\u00e1fico soporta todas las caracter\u00edsticas de PostgreSQL y facilita de gran manera la administraci\u00f3n ya que nos permite desde hacer b\u00fasquedas SQL hasta desarrollar toda nuestra base de datos de forma muy f\u00e1cil e intuitiva: directamente desde la interfaz gr\u00e1fica.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"559\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38-1024x559.png\" alt=\"\" class=\"wp-image-3187\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38-1024x559.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38-300x164.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38-768x420.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38-1536x839.png 1536w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38-1600x874.png 1600w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-35-38.png 1922w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\">Imagen 2<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Instalaci\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Previo a la instalaci\u00f3n de pgAdmin4 es necesario instalar postgresql, por lo que, si no lo tienen instalado a\u00fan, aqu\u00ed les dejo un enlace de c\u00f3mo realizar la instalaci\u00f3n en Fedora: <a href=\"https:\/\/blog.linuxitos.com\/post\/instalar-postgresql-14-fedora-36\">https:\/\/blog.linuxitos.com\/post\/instalar-postgresql-14-fedora-36<\/a><\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo rpm -i https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/yum\/pgadmin4-fedora-repo-2-1.noarch.rpm<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Versi\u00f3n de escritorio<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Instala una aplicaci\u00f3n de escritorio, para el caj\u00f3n de aplicaciones llamada pgadmin4, en lo personal es la que m\u00e1s me gusta<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36-1024x576.png\" alt=\"\" class=\"wp-image-3520\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36-1024x576.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36-300x169.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36-768x432.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36-1536x864.png 1536w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36-1600x900.png 1600w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-14-05-36.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo dnf -y install pgadmin4-desktop<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Una vez instalada, corroborar que los servicios de postgresql est\u00e9n iniciados y despu\u00e9s abrir la aplicaci\u00f3n e iniciar con la configuraci\u00f3n del servidor:<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo systemctl start postgresql.service<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">1.- Configurar una contrase\u00f1a maestra<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29-1024x576.png\" alt=\"\" class=\"wp-image-3522\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29-1024x576.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29-300x169.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29-768x432.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29-1536x864.png 1536w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29-1600x900.png 1600w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-28-29.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">2.- Configurar los accesos que hayan establecido para la conexi\u00f3n a postgresql<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27-1024x576.png\" alt=\"\" class=\"wp-image-3523\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27-1024x576.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27-300x169.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27-768x432.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27-1536x864.png 1536w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27-1600x900.png 1600w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-29-27.png 1920w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3.- Y listo, se iniciar\u00e9 el panel de administraci\u00f3n<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"612\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22-1024x612.png\" alt=\"\" class=\"wp-image-3521\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22-1024x612.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22-300x179.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22-768x459.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22-1536x918.png 1536w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22-1600x956.png 1600w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2022\/06\/Screenshot-from-2022-06-18-13-30-22.png 1685w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Versi\u00f3n web<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Para la versi\u00f3n web, tambi\u00e9n se requiere tener previamente instalado postgresql, adem\u00e1s, es necesario configurar algunas reglas en el firewall, e iniciar el servicio de httpd para el servicio web.<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo dnf -y install pgadmin4-web<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Una vez instalado, iniciar el servicio web:<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo systemctl start httpd<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">A\u00f1adir las reglas en el firewall:<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo firewall-cmd --permanent --add-service=http<\/pre>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo firewall-cmd --reload<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Iniciar la apliaci\u00f3n web:<\/p>\n\n\n\n<pre style=\"background: rgb(54, 63, 72); border-radius: 6px; border: 0px; box-sizing: border-box; color: white; font-family: menlo, monaco, monospace; font-style: inherit; font-weight: inherit; line-height: 15.68px; margin-bottom: 1.1em; max-width: 100%; outline: 0px; overflow: auto; padding: 13.125px 16.4062px; vertical-align: baseline; white-space: pre-wrap; word-wrap: break-word;\">sudo \/usr\/pgadmin4\/bin\/setup-web.sh<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ingresar correo electr\u00f3nico y contrase\u00f1a, y listo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-28-45.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-28-45-1024x442.png\" alt=\"\" class=\"wp-image-3189\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-28-45-1024x442.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-28-45-300x129.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-28-45-768x331.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2021\/06\/Screenshot-from-2021-06-30-20-28-45.png 1180w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Ahora, para utilizar la aplicaci\u00f3n, ir a la url que se indic\u00f3 o bien, en la ruta local <a href=\"http:\/\/127.0.0.1\/pgamin4\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/127.0.0.1\/pgamin4<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introducci\u00f3n B\u00e1sicamente es una aplicaci\u00f3n gr\u00e1fica desarrollada con python que implementa las siguientes tecnolog\u00edas: A diferencia a su versi\u00f3n anterior que est\u00e1 desarrollada con C++. \u00c9sta aplicaci\u00f3n sirve para gestionar el gestor de BD de PostgreSQL, y es considerada una de las m\u00e1s completas y populares con licencia Open Source y est\u00e1 disponible en diferente [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3519,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1233,1494,754,122,1511],"tags":[1764,1767],"class_list":["post-3517","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-start-postgresql","category-instalacion-postgresql","category-instalar-postgresql","category-postgresql","category-server","tag-pgadmin","tag-pgadmin4"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/3517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=3517"}],"version-history":[{"count":5,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/3517\/revisions"}],"predecessor-version":[{"id":3761,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/3517\/revisions\/3761"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media\/3519"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=3517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=3517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=3517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}