I'm trying to set my server up and came across some troubles related to Unix domain sockets. I don't have so much experience with Unix, despite the stack for web development: Apache, PHP and SQL. I installed Apache and PostgreSQL, but trying to access the
psql shell I came across the following error:
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist
pg_hbs.confhas this appearence:
|local||all||root/postgres/home (all was tried already)|
The error references the "local" field in the config file. I just opened up some documentation about Unix sockets, it's very interesting, and I will want to know more about but, despite looking like "I'd be to recreating the wheel", I just want to set the environment for development right now.
Any help will be welcome.