Contents
Why is my Postgres server unable to login?
I am using Postgres 9.3. I am unable to delete this user to reset it – I get an error “ERROR: role “XXXX” cannot be dropped because some objects depend on it DETAIL: privileges for database DATABASENAME” If I create a new user, that new user has no problems connecting to the database.
Can you create a new user in PostgreSQL?
I can login just fine with the postgres account with the command However, I have thus far been unable to create a new user to log in with. When I do this, it creates the user. I can see this with the \\du command: I have also tried createuser from cmd, this user showed up in the list of users as well, but I was again unable to login as these users.
Why is PostgreSQL unable to delete a user?
I am unable to delete this user to reset it – I get an error “ERROR: role “XXXX” cannot be dropped because some objects depend on it DETAIL: privileges for database DATABASENAME” If I create a new user, that new user has no problems connecting to the database.
Why is myuser in lowercase in PostgreSQL?
You’re trying to connect with myUser but due to case folding rules, you created myuser in lowercase, as the \\du output shows. Per documentation: Quoting an identifier also makes it case-sensitive, whereas unquoted names are always folded to lower case.
How to fix Server Fault in PostgreSQL server?
1) Modify pg_hba.conf, and set the authentication mode to “trust” for both “local” and “host” entries: Thanks for contributing an answer to Server Fault! Please be sure to answer the question. Provide details and share your research! But avoid … Asking for help, clarification, or responding to other answers.
How to make a PostgreSQL role log in?
# TYPE DATABASE USER ADDRESS METHOD # “local” is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 trust what could be the problem? The role you have created is not allowed to log in.
Where can I find a password for PostgreSQL?
There is a link to psql in the folder created at installation but that is no good either. It identically does not ask for a password. Any ideas? Thanks in advance. The password file is documented.