Hi On Mon, 21 Feb 2022 at 17:57, <frank77-postg...@spamfreemail.de> wrote:
> Hello all, > > I installed pgadmin4 using "pip install" on a 64bit Raspbian system. > > Everything worked well, except for the error message when trying to > authenticate to my Postgres server on the same machine. > > Here are the steps I followed: > > sudo pip3 install pgadmin4 > sudo mkdir /var/log/pgadmin4 /var/lib/pgadmin4 > sudo adduser pgadmin --disabled-password > sudo chown pgadmin:pgadmin /var/log/pgadmin4 /var/lib/pgadmin4 > sudo vim /etc/pgadmin/config_system.py # set paths accordingly > sudo su - pgadmin > pgadmin$ python3 > /usr/local/lib/python3.9/dist-packages/pgadmin4/setup.py > pgadmin$ pgadmin4 & > > The app boots up fine, and I can access it using a web browser, and log in > fine. > > NOTE: Configuring authentication for SERVER mode. > Enter the email address and password to use for the initial pgAdmin user > account: > Email address: u...@e.mail > Password: > Retype password: > Starting pgAdmin 4. Please navigate to http://0.0.0.0:5050 in your > browser. > 2022-02-20 23:28:30,069: WARNING werkzeug: WebSocket > transport not available. Install simple-websocket for improved performance. > * Serving Flask app 'pgadmin' (lazy loading) > * Environment: production > WARNING: This is a development server. Do not use it in a production > deployment. > Use a production WSGI server instead. > * Debug mode: off > 2022-02-20 23:28:30,071: WARNING werkzeug: * Running on all > addresses. > WARNING: This is a development server. Do not use it in a production > deployment. > > Only actually logging into a Postgres server fails. > > But I have libpq 14 installed and not libpq 10: > > pi@raspberry64 $ dpkg -l|grep libpq > ii libpq-dev 14.2-1.pgdg110+1 > arm64 header files for libpq5 (PostgreSQL library) > ii libpq5:arm64 14.2-1.pgdg110+1 > arm64 PostgreSQL C client library > > What am I missing? And how can I fix this? (Except changing the auth > method serverside, which I would like to avoid) > It sounds like psycopg2-binary on your machine is including an older version of libpq - though on my rpi it doesn't include any version which is quite odd (as that's the whole point of the -binary version). You could try "pip3 uninstall psycopg2-binary && pip3 install psycopg2" -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com