Instalar postgresql Ubuntu 18.04
referencia https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04
bext@bext-G3-3779:~$ sudo apt install postgresql postgresql-contrib Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libapr1 libaprutil1 libserf-1-1 libsvn1 Use 'sudo apt autoremove' to remove them. The following additional packages will be installed: postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common sysstat Suggested packages: postgresql-doc locales-all postgresql-doc-10 libjson-perl isag The following NEW packages will be installed: postgresql postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common postgresql-contrib sysstat 0 upgraded, 7 newly installed, 0 to remove and 16 not upgraded. Need to get 5 185 kB of archives. After this operation, 20.5 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 postgresql-client-common all 190 [29.5 kB] Get:2 http://mx.archive.ubuntu.com/ubuntu bionic-updates/main amd64 postgresql-client-10 amd64 10.10-0ubuntu0.18.04.1 [935 kB] Get:3 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 postgresql-common all 190 [157 kB] Get:4 http://mx.archive.ubuntu.com/ubuntu bionic-updates/main amd64 postgresql-10 amd64 10.10-0ubuntu0.18.04.1 [3 758 kB] Get:5 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 postgresql all 10+190 [5 784 B] Get:6 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 postgresql-contrib all 10+190 [5 796 B] Get:7 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 sysstat amd64 11.6.1-1 [295 kB] Fetched 5 185 kB in 11s (480 kB/s) Preconfiguring packages ... Selecting previously unselected package postgresql-client-common. (Reading database ... 188463 files and directories currently installed.) Preparing to unpack .../0-postgresql-client-common_190_all.deb ... Unpacking postgresql-client-common (190) ... Selecting previously unselected package postgresql-client-10. Preparing to unpack .../1-postgresql-client-10_10.10-0ubuntu0.18.04.1_amd64.deb ... Unpacking postgresql-client-10 (10.10-0ubuntu0.18.04.1) ... Selecting previously unselected package postgresql-common. Preparing to unpack .../2-postgresql-common_190_all.deb ... Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' Unpacking postgresql-common (190) ... Selecting previously unselected package postgresql-10. Preparing to unpack .../3-postgresql-10_10.10-0ubuntu0.18.04.1_amd64.deb ... Unpacking postgresql-10 (10.10-0ubuntu0.18.04.1) ... Selecting previously unselected package postgresql. Preparing to unpack .../4-postgresql_10+190_all.deb ... Unpacking postgresql (10+190) ... Selecting previously unselected package postgresql-contrib. Preparing to unpack .../5-postgresql-contrib_10+190_all.deb ... Unpacking postgresql-contrib (10+190) ... Selecting previously unselected package sysstat. Preparing to unpack .../6-sysstat_11.6.1-1_amd64.deb ... Unpacking sysstat (11.6.1-1) ... Setting up sysstat (11.6.1-1) ... Creating config file /etc/default/sysstat with new version update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar (sar) in auto mode Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /lib/systemd/system/sysstat.service. Setting up postgresql-client-common (190) ... Setting up postgresql-common (190) ... Adding user postgres to group ssl-cert Creating config file /etc/postgresql-common/createcluster.conf with new version Building PostgreSQL dictionaries from installed myspell/hunspell packages... en_us Removing obsolete dictionary files: Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. Setting up postgresql-client-10 (10.10-0ubuntu0.18.04.1) ... update-alternatives: using /usr/share/postgresql/10/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode Setting up postgresql-10 (10.10-0ubuntu0.18.04.1) ... Creating new PostgreSQL cluster 10/main ... /usr/lib/postgresql/10/bin/initdb -D /var/lib/postgresql/10/main --auth-local peer --auth-host md5 The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locales COLLATE: en_US.UTF-8 CTYPE: en_US.UTF-8 MESSAGES: en_US.UTF-8 MONETARY: es_MX.UTF-8 NUMERIC: es_MX.UTF-8 TIME: es_MX.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /var/lib/postgresql/10/main ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default timezone ... America/Mexico_City selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok Success. You can now start the database server using: /usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/main -l logfile start Ver Cluster Port Status Owner Data directory Log file 10 main 5432 down postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log update-alternatives: using /usr/share/postgresql/10/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode Setting up postgresql (10+190) ... Setting up postgresql-contrib (10+190) ... Processing triggers for man-db (2.8.3-2ubuntu0.1) ... Processing triggers for ureadahead (0.100.0-21) ... ureadahead will be reprofiled on next reboot Processing triggers for systemd (237-3ubuntu10.29) ...
Verificar status
bext@bext-G3-3779:~$ service postgresql status ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor prese Active: active (exited) since Sun 2019-09-15 11:28:07 CDT; 1h 39min ago Process: 2696 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Main PID: 2696 (code=exited, status=0/SUCCESS) sep 15 11:28:07 bext-G3-3779 systemd[1]: Starting PostgreSQL RDBMS... sep 15 11:28:07 bext-G3-3779 systemd[1]: Started PostgreSQL RDBMS.
Arrancar y Detener el servicio
bext@bext-G3-3779:~$ service postgresql stop bext@bext-G3-3779:~$ service postgresql status ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor prese Active: inactive (dead) since Sun 2019-09-15 13:10:57 CDT; 8s ago Process: 2696 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Main PID: 2696 (code=exited, status=0/SUCCESS) sep 15 11:28:07 bext-G3-3779 systemd[1]: Starting PostgreSQL RDBMS... sep 15 11:28:07 bext-G3-3779 systemd[1]: Started PostgreSQL RDBMS. sep 15 13:10:57 bext-G3-3779 systemd[1]: Stopped PostgreSQL RDBMS. bext@bext-G3-3779:~$ service postgresql start bext@bext-G3-3779:~$ service postgresql status ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor prese Active: active (exited) since Sun 2019-09-15 13:11:22 CDT; 3s ago Process: 10277 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Main PID: 10277 (code=exited, status=0/SUCCESS) sep 15 13:11:22 bext-G3-3779 systemd[1]: Starting PostgreSQL RDBMS... sep 15 13:11:22 bext-G3-3779 systemd[1]: Started PostgreSQL RDBMS.
Configurando postgresql
Referencia https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04
verificamos los usuarios de linux
bext@bext-G3-3779:~$ cat /etc/passwd root:x:0:0:root:/root:/bin/bash daemon:x:1:1:daemon:/usr/sbin:/usr/sbin/nologin bin:x:2:2:bin:/bin:/usr/sbin/nologin sys:x:3:3:sys:/dev:/usr/sbin/nologin sync:x:4:65534:sync:/bin:/bin/sync games:x:5:60:games:/usr/games:/usr/sbin/nologin man:x:6:12:man:/var/cache/man:/usr/sbin/nologin lp:x:7:7:lp:/var/spool/lpd:/usr/sbin/nologin mail:x:8:8:mail:/var/mail:/usr/sbin/nologin news:x:9:9:news:/var/spool/news:/usr/sbin/nologin uucp:x:10:10:uucp:/var/spool/uucp:/usr/sbin/nologin proxy:x:13:13:proxy:/bin:/usr/sbin/nologin www-data:x:33:33:www-data:/var/www:/usr/sbin/nologin backup:x:34:34:backup:/var/backups:/usr/sbin/nologin list:x:38:38:Mailing List Manager:/var/list:/usr/sbin/nologin irc:x:39:39:ircd:/var/run/ircd:/usr/sbin/nologin gnats:x:41:41:Gnats Bug-Reporting System (admin):/var/lib/gnats:/usr/sbin/nologin nobody:x:65534:65534:nobody:/nonexistent:/usr/sbin/nologin systemd-network:x:100:102:systemd Network Management,,,:/run/systemd/netif:/usr/sbin/nologin systemd-resolve:x:101:103:systemd Resolver,,,:/run/systemd/resolve:/usr/sbin/nologin syslog:x:102:106::/home/syslog:/usr/sbin/nologin messagebus:x:103:107::/nonexistent:/usr/sbin/nologin _apt:x:104:65534::/nonexistent:/usr/sbin/nologin uuidd:x:105:111::/run/uuidd:/usr/sbin/nologin avahi-autoipd:x:106:112:Avahi autoip daemon,,,:/var/lib/avahi-autoipd:/usr/sbin/nologin usbmux:x:107:46:usbmux daemon,,,:/var/lib/usbmux:/usr/sbin/nologin dnsmasq:x:108:65534:dnsmasq,,,:/var/lib/misc:/usr/sbin/nologin rtkit:x:109:114:RealtimeKit,,,:/proc:/usr/sbin/nologin cups-pk-helper:x:110:116:user for cups-pk-helper service,,,:/home/cups-pk-helper:/usr/sbin/nologin speech-dispatcher:x:111:29:Speech Dispatcher,,,:/var/run/speech-dispatcher:/bin/false whoopsie:x:112:117::/nonexistent:/bin/false kernoops:x:113:65534:Kernel Oops Tracking Daemon,,,:/:/usr/sbin/nologin saned:x:114:119::/var/lib/saned:/usr/sbin/nologin pulse:x:115:120:PulseAudio daemon,,,:/var/run/pulse:/usr/sbin/nologin avahi:x:116:122:Avahi mDNS daemon,,,:/var/run/avahi-daemon:/usr/sbin/nologin colord:x:117:123:colord colour management daemon,,,:/var/lib/colord:/usr/sbin/nologin hplip:x:118:7:HPLIP system user,,,:/var/run/hplip:/bin/false geoclue:x:119:124::/var/lib/geoclue:/usr/sbin/nologin gnome-initial-setup:x:120:65534::/run/gnome-initial-setup/:/bin/false gdm:x:121:125:Gnome Display Manager:/var/lib/gdm3:/bin/false bext:x:1000:1000:bext,,,:/home/bext:/bin/bash dd-agent:x:122:127::/opt/datadog-agent:/usr/sbin/nologin mysql:x:123:129:MySQL Server,,,:/nonexistent:/bin/false postgres:x:124:130:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash
o solamente el usuario
bext@bext-G3-3779:~$ awk -F':' '{ print $1}' /etc/passwd root daemon bin sys sync games man lp mail news uucp proxy www-data backup list irc gnats nobody systemd-network systemd-resolve syslog messagebus _apt uuidd avahi-autoipd usbmux dnsmasq rtkit cups-pk-helper speech-dispatcher whoopsie kernoops saned pulse avahi colord hplip geoclue gnome-initial-setup gdm bext dd-agent mysql postgres
Entrando a la cuenta postgres y correr el comando y salir
bext@bext-G3-3779:~$ sudo -i -u postgres postgres@bext-G3-3779:~$ psql psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)) Type "help" for help. postgres=# \q postgres@bext-G3-3779:~$ exit logout bext@bext-G3-3779:~$
Entrar sin cambiar de cuenta, y salimos
bext@bext-G3-3779:~$ sudo -u postgres psql psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)) Type "help" for help. postgres=# \q
Creamos un nuevo Rol
bext@bext-G3-3779:~$ sudo -i -u postgres postgres@bext-G3-3779:~$ createuser --interactive Enter name of role to add: bext Shall the new role be a superuser? (y/n) y postgres@bext-G3-3779:~$o
Creamos una nueva base de datos
postgres@bext-G3-3779:~$ createdb miDatabase
postgres@bext-G3-3779:~$
oVerificamos el acceso con usuario postgres
bext@bext-G3-3779:~$ sudo -i -u postgres postgres@bext-G3-3779:~$ \conninfo conninfo: command not found postgres@bext-G3-3779:~$ psql -d miDatabase psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)) Type "help" for help. miDatabase=# \conninfo You are connected to database "miDatabase" as user "postgres" via socket in "/var/run/postgresql" at port "5432". miDatabase=#
...
Cambiamos el password de postgres ya que el pgadmin4 necesita un password, originalmente no tiene.
bext@bext-G3-3779:~$ sudo -u postgres psql psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)) Type "help" for help. postgres=# ALTER USER postgres PASSWORD 'password'; ALTER ROLE postgres=#
Ejecutamos el administrador de postgres pgAdmin4
bext@bext-G3-3779:~$ pgadmin4 Python path: "/usr/lib/python3/dist-packages" Python Home: "" Webapp path: "/usr/share/pgadmin4/web/pgAdmin4.py"
Creamos una simple tabla "personaSimple"
verificamos la tabla creada desde comando de linea
bext@bext-G3-3779:~$ sudo -i -u postgres postgres@bext-G3-3779:~$ psql -d miDatabase psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)) Type "help" for help. miDatabase=# \conninfo You are connected to database "miDatabase" as user "postgres" via socket in "/var/run/postgresql" at port "5432". miDatabase=# \d List of relations Schema | Name | Type | Owner --------+---------------+-------+---------- public | personaSimple | table | postgres (1 row) miDatabase=#
Instalamos el pgAdmin4
Referencia https://wiki.postgresql.org/wiki/Apt
https://www.digitalocean.com/community/tutorials/how-to-install-configure-pgadmin4-server-mode
bext@bext-G3-3779:~$ sudo apt update
bext@bext-G3-3779:~$ sudo apt-get install curl ca-certificates gnugp Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package gnugp bext@bext-G3-3779:~$ curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 4812 100 4812 0 0 4346 0 0:00:01 0:00:01 --:--:-- 4346 OK bext@bext-G3-3779:~$ lsb_release -c Codename: bionic
bext@bext-G3-3779:~$ sudo touch /etc/apt/sources.list.d/pgdg.list
bext@bext-G3-3779:~$ sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
bext@bext-G3-3779:~$ sudo apt-get update
bext@bext-G3-3779:~$ sudo apt-get install pgadmin4 Reading package lists... Done Building dependency tree Reading state information... Done The following additional packages will be installed: alembic fonts-font-awesome fonts-open-sans fonts-roboto-unhinted javascript-common libjs-jquery libjs-sphinxdoc libjs-underscore pgadmin4-common pgadmin4-doc python-babel-localedata python3-alembic python3-babel python3-blinker python3-click python3-colorama python3-flask python3-flask-babelex python3-flask-gravatar python3-flask-htmlmin python3-flask-login python3-flask-mail python3-flask-migrate python3-flask-paranoid python3-flask-principal python3-flask-security python3-flask-sqlalchemy python3-flaskext.wtf python3-htmlmin python3-itsdangerous python3-jinja2 python3-openssl python3-paramiko python3-passlib python3-psutil python3-psycopg2 python3-pyasn1 python3-pyinotify python3-sqlalchemy python3-sqlparse python3-sshtunnel python3-werkzeug python3-wtforms Suggested packages: apache2 | lighttpd | httpd python3-editor python-blinker-doc python-flask-doc python-flask-login-doc python-jinja2-doc python-openssl-doc python3-openssl-dbg python3-gssapi python-psutil-doc python-psycopg2-doc python-pyinotify-doc python-sqlalchemy-doc python3-pymysql python3-fdb python-sqlparse-doc ipython3 python3-lxml python3-termcolor python3-watchdog python-werkzeug-doc python3-django python3-django-localflavor The following NEW packages will be installed: alembic fonts-font-awesome fonts-open-sans fonts-roboto-unhinted javascript-common libjs-jquery libjs-sphinxdoc libjs-underscore pgadmin4 pgadmin4-common pgadmin4-doc python-babel-localedata python3-alembic python3-babel python3-blinker python3-click python3-colorama python3-flask python3-flask-babelex python3-flask-gravatar python3-flask-htmlmin python3-flask-login python3-flask-mail python3-flask-migrate python3-flask-paranoid python3-flask-principal python3-flask-security python3-flask-sqlalchemy python3-flaskext.wtf python3-htmlmin python3-itsdangerous python3-jinja2 python3-openssl python3-paramiko python3-passlib python3-psutil python3-psycopg2 python3-pyasn1 python3-pyinotify python3-sqlalchemy python3-sqlparse python3-sshtunnel python3-werkzeug python3-wtforms 0 upgraded, 44 newly installed, 0 to remove and 15 not upgraded. Need to get 29.2 MB of archives. After this operation, 90.4 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 python3-flask-babelex all 0.9.3-1~pgdg18.04+1 [9 236 B] Get:2 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 python3-flask-htmlmin all 1.3.2-1~pgdg18.04+1 [4 080 B] Get:3 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 python3-psycopg2 amd64 2.7.6.1-3.pgdg18.04+1 [160 kB] Get:4 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 python3-sshtunnel all 0.1.4-1~pgdg18.04+1 [22.7 kB] Get:5 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-sqlalchemy all 1.1.11+ds1-1ubuntu1 [680 kB] Get:6 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 pgadmin4-common all 4.12-1.pgdg18.04+1 [2 738 kB] Get:7 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 pgadmin4 amd64 4.12-1.pgdg18.04+1 [271 kB] Get:8 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64 pgadmin4-doc all 4.12-1.pgdg18.04+1 [16.5 MB] Get:9 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-alembic all 0.9.3-2ubuntu1 [105 kB] Get:10 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 libjs-jquery all 3.2.1-1 [152 kB] Get:11 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 libjs-underscore all 1.8.3~dfsg-1 [59.9 kB] Get:12 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 libjs-sphinxdoc all 1.6.7-1ubuntu1 [85.6 kB] Get:13 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 alembic all 0.9.3-2ubuntu1 [239 kB] Get:14 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 fonts-font-awesome all 4.7.0~dfsg-3 [513 kB] Get:15 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 fonts-open-sans all 1.11-1 [575 kB] Get:16 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 fonts-roboto-unhinted all 2:0~20160106-2 [2 202 kB] Get:17 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 javascript-common all 11 [6 066 B] Get:18 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-colorama all 0.3.7-1 [14.9 kB] Get:19 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-click all 6.7-3 [56.5 kB] Get:20 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-itsdangerous all 0.24+dfsg1-2 [12.0 kB] Get:21 http://mx.archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3-jinja2 all 2.10-1ubuntu0.18.04.1 [95.4 kB] Get:22 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-werkzeug all 0.14.1+dfsg1-1 [174 kB] Get:23 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask all 0.12.2-3 [62.3 kB] Get:24 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python-babel-localedata all 2.4.0+dfsg.1-2ubuntu1 [3 412 kB] Get:25 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-babel all 2.4.0+dfsg.1-2ubuntu1 [79.9 kB] Get:26 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-gravatar all 0.4.2-1 [5 384 B] Get:27 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-htmlmin all 0.1.12-1 [18.6 kB] Get:28 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-login all 0.4.0-2 [15.7 kB] Get:29 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-sqlalchemy all 2.1-3build1 [13.8 kB] Get:30 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-migrate all 2.1.1-2 [10.2 kB] Get:31 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-paranoid all 0.2.0-2 [4 856 B] Get:32 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-blinker all 1.4+dfsg1-0.1 [13.1 kB] Get:33 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-mail all 0.9.1+dfsg1-1 [14.1 kB] Get:34 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-principal all 0.4.0-1build1 [7 586 B] Get:35 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-wtforms all 2.1-1 [61.3 kB] Get:36 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flaskext.wtf all 0.14.2-2 [12.4 kB] Get:37 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-passlib all 1.7.1-1 [347 kB] Get:38 http://mx.archive.ubuntu.com/ubuntu bionic/universe amd64 python3-flask-security all 1.7.5-2 [22.3 kB] Get:39 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-psutil amd64 5.4.2-1 [136 kB] Get:40 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-sqlparse all 0.2.4-0.1 [28.1 kB] Get:41 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-pyasn1 all 0.4.2-3 [46.8 kB] Get:42 http://mx.archive.ubuntu.com/ubuntu bionic-updates/main amd64 python3-paramiko all 2.0.0-1ubuntu1.2 [110 kB] Get:43 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-openssl all 17.5.0-1ubuntu1 [41.5 kB] Get:44 http://mx.archive.ubuntu.com/ubuntu bionic/main amd64 python3-pyinotify all 0.9.6-1 [24.7 kB] Fetched 29.2 MB in 30s (971 kB/s) Extracting templates from packages: 100% Selecting previously unselected package python3-sqlalchemy. (Reading database ... 189182 files and directories currently installed.) Preparing to unpack .../00-python3-sqlalchemy_1.1.11+ds1-1ubuntu1_all.deb ... Unpacking python3-sqlalchemy (1.1.11+ds1-1ubuntu1) ... Selecting previously unselected package python3-alembic. Preparing to unpack .../01-python3-alembic_0.9.3-2ubuntu1_all.deb ... Unpacking python3-alembic (0.9.3-2ubuntu1) ... Selecting previously unselected package libjs-jquery. Preparing to unpack .../02-libjs-jquery_3.2.1-1_all.deb ... Unpacking libjs-jquery (3.2.1-1) ... Selecting previously unselected package libjs-underscore. Preparing to unpack .../03-libjs-underscore_1.8.3~dfsg-1_all.deb ... Unpacking libjs-underscore (1.8.3~dfsg-1) ... Selecting previously unselected package libjs-sphinxdoc. Preparing to unpack .../04-libjs-sphinxdoc_1.6.7-1ubuntu1_all.deb ... Unpacking libjs-sphinxdoc (1.6.7-1ubuntu1) ... Selecting previously unselected package alembic. Preparing to unpack .../05-alembic_0.9.3-2ubuntu1_all.deb ... Unpacking alembic (0.9.3-2ubuntu1) ... Selecting previously unselected package fonts-font-awesome. Preparing to unpack .../06-fonts-font-awesome_4.7.0~dfsg-3_all.deb ... Unpacking fonts-font-awesome (4.7.0~dfsg-3) ... Selecting previously unselected package fonts-open-sans. Preparing to unpack .../07-fonts-open-sans_1.11-1_all.deb ... Unpacking fonts-open-sans (1.11-1) ... Selecting previously unselected package fonts-roboto-unhinted. Preparing to unpack .../08-fonts-roboto-unhinted_2%3a0~20160106-2_all.deb ... Unpacking fonts-roboto-unhinted (2:0~20160106-2) ... Selecting previously unselected package javascript-common. Preparing to unpack .../09-javascript-common_11_all.deb ... Unpacking javascript-common (11) ... Selecting previously unselected package python3-colorama. Preparing to unpack .../10-python3-colorama_0.3.7-1_all.deb ... Unpacking python3-colorama (0.3.7-1) ... Selecting previously unselected package python3-click. Preparing to unpack .../11-python3-click_6.7-3_all.deb ... Unpacking python3-click (6.7-3) ... Selecting previously unselected package python3-itsdangerous. Preparing to unpack .../12-python3-itsdangerous_0.24+dfsg1-2_all.deb ... Unpacking python3-itsdangerous (0.24+dfsg1-2) ... Selecting previously unselected package python3-jinja2. Preparing to unpack .../13-python3-jinja2_2.10-1ubuntu0.18.04.1_all.deb ... Unpacking python3-jinja2 (2.10-1ubuntu0.18.04.1) ... Selecting previously unselected package python3-werkzeug. Preparing to unpack .../14-python3-werkzeug_0.14.1+dfsg1-1_all.deb ... Unpacking python3-werkzeug (0.14.1+dfsg1-1) ... Selecting previously unselected package python3-flask. Preparing to unpack .../15-python3-flask_0.12.2-3_all.deb ... Unpacking python3-flask (0.12.2-3) ... Selecting previously unselected package python-babel-localedata. Preparing to unpack .../16-python-babel-localedata_2.4.0+dfsg.1-2ubuntu1_all.deb ... Unpacking python-babel-localedata (2.4.0+dfsg.1-2ubuntu1) ... Selecting previously unselected package python3-babel. Preparing to unpack .../17-python3-babel_2.4.0+dfsg.1-2ubuntu1_all.deb ... Unpacking python3-babel (2.4.0+dfsg.1-2ubuntu1) ... Selecting previously unselected package python3-flask-babelex. Preparing to unpack .../18-python3-flask-babelex_0.9.3-1~pgdg18.04+1_all.deb ... Unpacking python3-flask-babelex (0.9.3-1~pgdg18.04+1) ... Selecting previously unselected package python3-flask-gravatar. Preparing to unpack .../19-python3-flask-gravatar_0.4.2-1_all.deb ... Unpacking python3-flask-gravatar (0.4.2-1) ... Selecting previously unselected package python3-htmlmin. Preparing to unpack .../20-python3-htmlmin_0.1.12-1_all.deb ... Unpacking python3-htmlmin (0.1.12-1) ... Selecting previously unselected package python3-flask-htmlmin. Preparing to unpack .../21-python3-flask-htmlmin_1.3.2-1~pgdg18.04+1_all.deb ... Unpacking python3-flask-htmlmin (1.3.2-1~pgdg18.04+1) ... Selecting previously unselected package python3-flask-login. Preparing to unpack .../22-python3-flask-login_0.4.0-2_all.deb ... Unpacking python3-flask-login (0.4.0-2) ... Selecting previously unselected package python3-flask-sqlalchemy. Preparing to unpack .../23-python3-flask-sqlalchemy_2.1-3build1_all.deb ... Unpacking python3-flask-sqlalchemy (2.1-3build1) ... Selecting previously unselected package python3-flask-migrate. Preparing to unpack .../24-python3-flask-migrate_2.1.1-2_all.deb ... Unpacking python3-flask-migrate (2.1.1-2) ... Selecting previously unselected package python3-flask-paranoid. Preparing to unpack .../25-python3-flask-paranoid_0.2.0-2_all.deb ... Unpacking python3-flask-paranoid (0.2.0-2) ... Selecting previously unselected package python3-blinker. Preparing to unpack .../26-python3-blinker_1.4+dfsg1-0.1_all.deb ... Unpacking python3-blinker (1.4+dfsg1-0.1) ... Selecting previously unselected package python3-flask-mail. Preparing to unpack .../27-python3-flask-mail_0.9.1+dfsg1-1_all.deb ... Unpacking python3-flask-mail (0.9.1+dfsg1-1) ... Selecting previously unselected package python3-flask-principal. Preparing to unpack .../28-python3-flask-principal_0.4.0-1build1_all.deb ... Unpacking python3-flask-principal (0.4.0-1build1) ... Selecting previously unselected package python3-wtforms. Preparing to unpack .../29-python3-wtforms_2.1-1_all.deb ... Unpacking python3-wtforms (2.1-1) ... Selecting previously unselected package python3-flaskext.wtf. Preparing to unpack .../30-python3-flaskext.wtf_0.14.2-2_all.deb ... Unpacking python3-flaskext.wtf (0.14.2-2) ... Selecting previously unselected package python3-passlib. Preparing to unpack .../31-python3-passlib_1.7.1-1_all.deb ... Unpacking python3-passlib (1.7.1-1) ... Selecting previously unselected package python3-flask-security. Preparing to unpack .../32-python3-flask-security_1.7.5-2_all.deb ... Unpacking python3-flask-security (1.7.5-2) ... Selecting previously unselected package python3-psutil. Preparing to unpack .../33-python3-psutil_5.4.2-1_amd64.deb ... Unpacking python3-psutil (5.4.2-1) ... Selecting previously unselected package python3-psycopg2. Preparing to unpack .../34-python3-psycopg2_2.7.6.1-3.pgdg18.04+1_amd64.deb ... Unpacking python3-psycopg2 (2.7.6.1-3.pgdg18.04+1) ... Selecting previously unselected package python3-sqlparse. Preparing to unpack .../35-python3-sqlparse_0.2.4-0.1_all.deb ... Unpacking python3-sqlparse (0.2.4-0.1) ... Selecting previously unselected package python3-pyasn1. Preparing to unpack .../36-python3-pyasn1_0.4.2-3_all.deb ... Unpacking python3-pyasn1 (0.4.2-3) ... Selecting previously unselected package python3-paramiko. Preparing to unpack .../37-python3-paramiko_2.0.0-1ubuntu1.2_all.deb ... Unpacking python3-paramiko (2.0.0-1ubuntu1.2) ... Selecting previously unselected package python3-sshtunnel. Preparing to unpack .../38-python3-sshtunnel_0.1.4-1~pgdg18.04+1_all.deb ... Unpacking python3-sshtunnel (0.1.4-1~pgdg18.04+1) ... Selecting previously unselected package pgadmin4-common. Preparing to unpack .../39-pgadmin4-common_4.12-1.pgdg18.04+1_all.deb ... Unpacking pgadmin4-common (4.12-1.pgdg18.04+1) ... Selecting previously unselected package pgadmin4. Preparing to unpack .../40-pgadmin4_4.12-1.pgdg18.04+1_amd64.deb ... Unpacking pgadmin4 (4.12-1.pgdg18.04+1) ... Selecting previously unselected package pgadmin4-doc. Preparing to unpack .../41-pgadmin4-doc_4.12-1.pgdg18.04+1_all.deb ... Unpacking pgadmin4-doc (4.12-1.pgdg18.04+1) ... Selecting previously unselected package python3-openssl. Preparing to unpack .../42-python3-openssl_17.5.0-1ubuntu1_all.deb ... Unpacking python3-openssl (17.5.0-1ubuntu1) ... Selecting previously unselected package python3-pyinotify. Preparing to unpack .../43-python3-pyinotify_0.9.6-1_all.deb ... Unpacking python3-pyinotify (0.9.6-1) ... Setting up libjs-jquery (3.2.1-1) ... Setting up python3-werkzeug (0.14.1+dfsg1-1) ... Setting up python3-sqlalchemy (1.1.11+ds1-1ubuntu1) ... Setting up python3-passlib (1.7.1-1) ... Setting up python3-htmlmin (0.1.12-1) ... Setting up libjs-underscore (1.8.3~dfsg-1) ... Setting up python3-sqlparse (0.2.4-0.1) ... Setting up python3-colorama (0.3.7-1) ... Setting up python3-alembic (0.9.3-2ubuntu1) ... Setting up libjs-sphinxdoc (1.6.7-1ubuntu1) ... Setting up fonts-open-sans (1.11-1) ... Setting up python3-psutil (5.4.2-1) ... Setting up fonts-font-awesome (4.7.0~dfsg-3) ... Setting up python3-blinker (1.4+dfsg1-0.1) ... Setting up python3-psycopg2 (2.7.6.1-3.pgdg18.04+1) ... Setting up python3-pyasn1 (0.4.2-3) ... Setting up python3-wtforms (2.1-1) ... Setting up python3-jinja2 (2.10-1ubuntu0.18.04.1) ... Setting up python-babel-localedata (2.4.0+dfsg.1-2ubuntu1) ... Setting up pgadmin4-doc (4.12-1.pgdg18.04+1) ... Setting up python3-openssl (17.5.0-1ubuntu1) ... Setting up javascript-common (11) ... Setting up python3-itsdangerous (0.24+dfsg1-2) ... Setting up alembic (0.9.3-2ubuntu1) ... Setting up python3-pyinotify (0.9.6-1) ... Setting up fonts-roboto-unhinted (2:0~20160106-2) ... Setting up python3-paramiko (2.0.0-1ubuntu1.2) ... Setting up python3-click (6.7-3) ... Setting up python3-sshtunnel (0.1.4-1~pgdg18.04+1) ... Setting up python3-babel (2.4.0+dfsg.1-2ubuntu1) ... update-alternatives: using /usr/bin/pybabel-python3 to provide /usr/bin/pybabel (pybabel) in auto mode Setting up python3-flask (0.12.2-3) ... Setting up python3-flask-sqlalchemy (2.1-3build1) ... Setting up python3-flask-babelex (0.9.3-1~pgdg18.04+1) ... Setting up python3-flask-migrate (2.1.1-2) ... Setting up python3-flask-paranoid (0.2.0-2) ... Setting up python3-flask-htmlmin (1.3.2-1~pgdg18.04+1) ... Setting up python3-flask-gravatar (0.4.2-1) ... Setting up python3-flask-login (0.4.0-2) ... Setting up python3-flaskext.wtf (0.14.2-2) ... Setting up python3-flask-mail (0.9.1+dfsg1-1) ... Setting up python3-flask-principal (0.4.0-1build1) ... Setting up python3-flask-security (1.7.5-2) ... Setting up pgadmin4-common (4.12-1.pgdg18.04+1) ... Setting up pgadmin4 (4.12-1.pgdg18.04+1) ... Processing triggers for mime-support (3.60ubuntu1) ... Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ... Processing triggers for man-db (2.8.3-2ubuntu0.1) ... Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ... Processing triggers for hicolor-icon-theme (0.17-2) ... Processing triggers for fontconfig (2.12.6-0ubuntu2) ...
bext@bext-G3-3779:~$ pgadmin4 Python path: "/usr/lib/python3/dist-packages" Python Home: "" Webapp path: "/usr/share/pgadmin4/web/pgAdmin4.py" NOTE: Configuring authentication for DESKTOP mode. pgAdmin 4 - Application Initialisation ======================================
eot
No hay comentarios:
Publicar un comentario