I've deleted database from PostgreSQL and after this I can do nothing. Here what i receive with createuser
$ createuser -D new_user
createuser: could not connect to database postgres: FATAL: role "postgres" does not exist
And this when try to run psql
$ psql
psql: FATAL: role "postgres" does not exist
I've tried above with root
, postgres
, custom
users. Still same output
Also I searched for pg_hba.conf
like this find / -name 'pg_hba.conf'
and got this
/var/lib/postgres-xc/DN2/pg_hba.conf
/var/lib/postgres-xc/DN1/pg_hba.conf
/var/lib/postgres-xc/CN/pg_hba.conf
/etc/postgres-xc/coordinator/CN/pg_hba.conf
/etc/postgres-xc/datanode/DN2/pg_hba.conf
/etc/postgres-xc/datanode/DN1/pg_hba.conf
/etc/postgresql/9.3/main/pg_hba.conf
I've changed connection method to trust
for localhost
and IPv4
in /etc/postgresql/9.3/main/pg_hba.conf
.
What should I do get rid of this error?
Does connection method in other files above should be edited too?
Aucun commentaire:
Enregistrer un commentaire