search

tplagge / benefice

6 stars 2 forks source link

setup script assumes a postgres user exists #5

Open arbylee opened 11 years ago

arbylee commented 11 years ago

I'm not sure what privileges are expected for the user, so I just created a superuser for now. I used the following steps:

psql -d postgres
create role postgres;
alter role postgres SUPERUSER;

Without the postgres user, you'll just see a bunch of "psql: FATAL: role "postgres" does not exist" when running the script

derekeder commented 11 years ago

got an error complaining about granting login access. this line fixes it:

ALTER ROLE postgres WITH login;