Rodrigo de Avila

Ferramentas do PostgreSQL

Ajuda com algumas ferramentas do PostgreSQL

Resolvendo o erro Failed to download metadata for repo 'pgdg-common'

sudo dnf remove -y pgdg-redhat*
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Instalando o adminpack no Ubuntu

Se você usa o pgAdmin III, talvez já tenha visto o erro "missing server instrumentation". Se você usa PostgreSQL 8.3 com Ubuntu 8.10, pode executar o seguinte:

sudo apt-get install -y postgresql-contrib
psql -U postgres -d postgres -h localhost < /usr/share/postgresql/8.3/contrib/adminpack.sql

Corrigindo erros do psycopg2 no pg_activity

Se você encontrar erros do psycopg2 ao executar o pg_activity:

pg_activity -U postgres

Traceback (most recent call last):
  File "/bin/pg_activity", line 11, in <module>
    load_entry_point('pg-activity==2.2.1', 'console_scripts', 'pg_activity')()
  File "/usr/lib/python3.6/site-packages/pkg_resources/__init__.py", line 476, in load_entry_point
    return get_distribution(dist).load_entry_point(group, name)
  File "/usr/lib/python3.6/site-packages/pkg_resources/__init__.py", line 2700, in load_entry_point
    return ep.load()
  File "/usr/lib/python3.6/site-packages/pkg_resources/__init__.py", line 2318, in load
    return self.resolve()
  File "/usr/lib/python3.6/site-packages/pkg_resources/__init__.py", line 2324, in resolve
    module = __import__(self.module_name, fromlist=['__name__'], level=0)
  File "/usr/lib/python3.6/site-packages/pgactivity/cli.py", line 8, in <module>
    from psycopg2.errors import OperationalError
  File "/usr/lib64/python3.6/site-packages/psycopg2/__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ImportError: /usr/lib64/python3.6/site-packages/psycopg2/_psycopg.cpython-36m-x86_64-linux-gnu.so: undefined symbol: PQencryptPasswordConn

Talvez estes comandos resolvam o problema para você.

pip3 uninstall psycopg2
pip install --upgrade pip
pip3 install psycopg2-binary