Tagged Questions
1
vote
1answer
150 views
PostgreSQL - using password/md5 authentication with empty password
I have the following role in my system:
CREATE ROLE test LOGIN INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
There is no password. Trying to connect to the db from within the same machine using ...
0
votes
1answer
205 views
Unable to reset the password of users in postgres
Evrytime i run, su - postgres it asks me for a password which I did not set. I simply installed the postgres. I have gone to the pg_hba.conf.
# Database administrative login by Unix domain socket
...
3
votes
1answer
663 views
postgres and passwordless authentication
We have users for out postgres database and none have passwords... Do not know the history behind it.
When I try to use clients to connect to these databases, for instance, pgadmin III, the ...
0
votes
0answers
224 views
Delay after running pg_ctl reload [closed]
Recently, I made changes to my Postgres 8.3 database - added a couple new users and added these roles to the pg_hba.conf file. However, after running pg_ctl reload -D [DB directory], the changes ...
2
votes
2answers
368 views
Transferring concepts - users/groups/permissions of db objects from mysql to postgresql
This seemed like a better fit here than stackoverflow, so here goes:
I've been using mysql for a while since on most of the cheap webhosts it is the provided database. However, now I've started ...
