Create user mapping without password

From: Aymen Rahal <aymen(dot)rahal01(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Create user mapping without password
Date: 2023-02-16 10:33:47
Message-ID: CAONGVf3rGv1NfxA0578fEpWLX2=wRbyCY-L1ca_j0Vx4h6RW+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

I am trying to create a user mapping without password like below :

CREATE USER MAPPING for app_user SERVER testmachine02 OPTIONS (user 'test');

I created a pgpass file with th chmod 600 and I added this lines

localhost:5432:local_db:app_user:app_user123

192.168.56.10:5432:admin:admin:admin123

192.168.56.10:5432:remote_db:test:test123

testmachine02:5432:local_db:test:test123

the host 192.168.56.10 is where the remote_db created with user 'test' and
password 'test123'.

the user created but I am having this error message:

local_db=> select * from employee;

ERROR: password is required

DETAIL: Non-superusers must provide a password in the user mapping.

Could you please help me to create the mapping user without password.

Thanks in advance.

Regards,

Aymen Rahal

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2023-02-16 16:03:46 BUG #17797: connection error
Previous Message Tom Lane 2023-02-16 00:08:10 Re: BUG #17794: dates with zero or negative years are not accepted