PostgreSQL public access to database

Question

I recently created a test database but I would like it to be accessible to all users.

I created the database as user postgres then use the command

GRANT ALL ON DATABASE dbname TO public;

But when I log out and try to connect to it with a different user I get this error

psql -d dbname
psql: FATAL:  role "username" does not exist

I don't want to have to create a user for each person who will be accessing the database which is the reason i wanted to make it public. Is there a permission that I am still missing?

ckruse · Accepted Answer · 2015-02-24 10:18:40Z

4

Although access to everybody (public) is granted, the user you connect with has to exist. The default for psql is the username of your system account. You can, of course, create a passwordless anonymous user everybody can use to connect:

psql -U anonymous dbname

answered Feb 24, 2015 at 10:18

ckruse

9,7701 gold badge27 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Andomar Over a year ago

Or the equivalent psql dbname anonymous, +1

TheLovelySausage Over a year ago

doesn't that defeat the point of granting public access to the database, it's not really public if you have to be a user to connect to it

ckruse Over a year ago

Public in this context means "every user the DBMS knows about"

Collectives™ on Stack Overflow

PostgreSQL public access to database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related