T
T
Tils steel2020-09-19 13:23:19
PostgreSQL
Tils steel, 2020-09-19 13:23:19

Lost data after fixing the error with entering the role?

During the time when I did not use the user in the docker-compose file, I got an error, but I could manage the database, and manipulate data from the PostgreSQL database tables on the AWS server.
Mistake:

database |      Connection matched pg_hba.conf line 94: "host all all 0.0.0.0/0 md5"
database | 2020-09-16 00:40:28.127 UTC [55303] FATAL:  password authentication failed for user "postgres"
database | 2020-09-16 00:40:28.127 UTC [55303] DETAIL:  Password does not match for user "postgres".

But then I fixed it by defining the user and password through docker-compose.yml, and from that moment on, the tables in my database were updated, and the data in the tables turned out to be empty! So, after all this, I had 2 new databases in pgAdmin4 (template0 and template1) and I could not connect to one of them! But then they disappeared altogether!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question