All Questions
Tagged with authentication postgresql
62
questions
0
votes
0
answers
15
views
Database connection either cannot authenticate with encryption `md5` or is vulnerable with `trust` [closed]
I write a database helper to manage transactions in a centralized way. When testing it, I encounter following error, even though the credentials are correct. By changing the encryption type from md5 ...
-1
votes
1
answer
223
views
Query postgres db in a Docker container from another container using peer auth
I have two Docker containers with a Postgres db in each. I am exposing the Postgres socket of each container to the other one, using Docker volumes, like so:
docker run --rm -itd --name=containerone -...
0
votes
0
answers
93
views
connection failed: FATAL: role "y" does not exist when .ini has role "x"
I have a Python program for PostgreSQL database management. Today it started throwing
psycopg.OperationalError: connection failed: FATAL: role "role_a" does not exist
Connection parameters ...
- 133
0
votes
2
answers
1k
views
PostgreSQL: Pgbouncer authentication
We are using authentication file mode in pgbouncer. The authentication part of Pgbouncer is so confusing. Would be helpful if anybody can throw some light on my below queries.
Are Pgbouncer ...
- 341
0
votes
1
answer
294
views
PostgreSQL client on Windows to access PostgreSQL server on Linux using Active Directoy Kerberos authentication
TEST 1 - PostgreSQL with Active Directory authentication
I have installed PotgreSQL Server v15.3 on Red Hat 8.8 and integrate PostgreSQL authentication using Active Directory.
In pg_hba.conf I have ...
- 357
1
vote
0
answers
74
views
PostgreSQL: data retrieval from a private (authentication-based) RESTful web API using a foreign data wrapper
In some cases, one want to feed or populate some PostgreSQL database tables using data fetched from the web, e.g. through a RESTful API (serving JSON features).
I've recently discovered foreign data ...
- 384
0
votes
1
answer
240
views
Passwordless access to psql from Administrator WITHOUT any password (Windows)
Yes, I know there are plenty of answers on how to access psql without password... while specifying password somewhere.
I do not have context this luxurious. I do not have any password. What I do have ...
- 503
0
votes
2
answers
5k
views
How to fix authentication through pgpool?
I have a cluster that consists of:
pgpool
master
slave
Using pgpool-II version 4.3.2 and
Postgres 14.4
Several users have been created, all are authenticated through pgpool.
There was a need to ...
- 131
0
votes
2
answers
1k
views
Store LDAP bind credentials in environment variables for pg_hba.conf
I am working on setting up LDAP authentication for a PostgreSQL database and have added the following in my pg_hba.conf file:
# TYPE DATABASE USER ADDRESS METHOD
host all all ...
- 105
4
votes
1
answer
11k
views
PostgreSQL: Using the .pgpass file
I have been reading up on the .pgpass file, but I can’t get it working for me.
My .pgpass file looks something like this:
127.0.0.1:5432:accounts:fred:p@55w0rd
I set the privilege to 0600 (this is on ...
- 2,869
0
votes
1
answer
7k
views
Does my PostgreSQL instance support kerberos/gssapi authentication?
I installed it following instructions from digital ocean how-to-install-postgresql-on-ubuntu-20-04-quickstart:
% sudo apt install postgresql postgresql-contrib
I also did a 'show all' in psql and ...
- 121
2
votes
1
answer
2k
views
PostgreSQL keeps asking for user password with "trust" authentication enabled
I created a user john with createuser and didn't supply any passwords for it, i.e. no -P option specified. I then proceeded to add the following line above all other lines in the pg_hba.conf file:
...
- 31
0
votes
1
answer
2k
views
PostgreSQL Linux PAM Authentication Error
I'm using PSQL version 12.5 on Ubuntu 20.04.1. My pg_hba.conf file looks like this:
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database superuser can ...
- 103
-1
votes
1
answer
943
views
Best practice for connecting to Postgres from Django [closed]
I recently installed Postgres 11 on my Raspberry Pi 4, and attempted to connect to a database from my Django app:
return psycopg2.connect(dbname="covid")
The connection failed like so:
...
- 109
0
votes
1
answer
4k
views
Connect DBeaver to PostgreSQL 13
I've been using PostgreSQL 10 and 12 on Windows successfully with DBeaver in the past. Now I've set up a new development machine and installed the current PostgreSQL 13.0.1 and the current DBeaver 7.2....
- 253