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
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 |