This message was deleted.

Thank you for your feedback, you can check if your username and password are correct, if you really forget your password or username, you can try logging into your database and setting the user's email to empty. Finally, remember to go to

/setup

and reset the yatai.

# forward the postgresql service in k8s to your local
kubectl port-forward --namespace yatai-system svc/postgresql-ha-pgpool 5433:5432 &

# login to postgresql and reset the email field of user
PGPASSWORD=$(kubectl -n yatai-system get secret postgresql-ha-postgresql -o jsonpath='{.data.postgresql-password}' | base64 -d) psql -h localhost -p 5433 -U postgres -d yatai -c "update \"user\" set email = '' where id = 1"

Thank you for your answer, this is my postgres with yatai db and user table, is that correct?

@kurniarahmatt Your SQL is wrong,

user

needs to add quotes:

select * from "user";

oh god, my mistake, now everyting is ok, thanks lot @Xipeng Guan