Hi,
I'm sorry if this question have been asked earlier, but i could not find
any valid result through googling.
I'm running postgresql 9.1 on Windows 7 (64 bit) and i've following
configuration in pg_hba.conf.
host all superuser1127.0.0.1/32 password
host all
PM, David G Johnston wrote:
> Ravi Roy wrote
> > But if I try to connect using pgadmin (from the same machine) it gives
> > acess to database without password, i'm surprised as it does not seem to
> > respect pg_hba.conf or i'm terribly wrong in the configuration s
Hi Guys,
I've created a role named "MyRole" in posgresql with the following :
CREATE ROLE "MyRole" NOSUPERUSER LOGIN NOCREATEDB NOCREATEROLE NOINHERIT
PASSWORD "MyPassword";
ALTER ROLE "MyRole" set default_transaction_read_only = on;
Because I wanted this role to readonly (can not change anythi
I'm sorry, i forgot to mention my environemnt :
Postgresql version 9.1 on Windows 7 (64 bit) and Debian Linux 6.x (64 bit)
Thanks!
Regards
Ravi.
On Sun, May 11, 2014 at 7:47 PM, Ravi Roy wrote:
> Hi Guys,
>
> I've created a role named "MyRole" in posgresql wi
nally, I see no reason why this user should not be able to change it's
> own password. What is the exact command you are using to try to change the
> password? What is the exact error?
>
> Melvin Davidson
>
> Folk Alley - All Folk - 24 Hours a day
> www.folkalley.com
>
&g
: ALTER ROLE MyRole WITH PASSWORD 'myPassword'
It first confirm the existing password which is fine and authorization is
granted.
As soon I try to change the password it give me the error :
ERROR: Can not ALTER ROLE in a read only transaction.
Thanks!
Regards
On Sun, May 11, 2014 at
are currently logged in as user "MyRole"
> with
> SELECT CURRENT_USER;
>
> Good luck and may the bytes be with you.
>
> Melvin Davidson
>
>
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
> Folk All
Thanks a lot Tom, it worked by putting off the read only mode to off before
changing the password and putting it on again.
> SET default_transaction_read_only = off;
Worked for me..
Many thanks to you!
Regards
Ravi
On Sun, May 11, 2014 at 10:26 PM, Tom Lane wrote:
> Ravi Roy
