Reset da senha do PostGreSQL

Na pagina do Tiago Passos, achei esta dica que registro aqui para consulta futura.

No terminal, digite o seguinte:

sudo -u postgres psql template1
alter user postgres with password ‘NOVA_SENHA’;
\q (para sair)

Uma resposta para “Reset da senha do PostGreSQL”

  1. Note that the error message does NOT talk about a missing database, it talks about a missing role. Later in the login process it might also stumble over the missing database.

    But the first step is to check the missing role: What is the output within psql of the command \du ? On my Ubuntu system the relevant line looks like this:

    List of roles
    Role name | Attributes | Member of
    ———–+———————————–+———–
    postgres | Superuser, Create role, Create DB | {}

    If there is not at least one role with superuser, then you have a problem 🙂

    If there is one, you can use that to login. And looking at the output of your \l command: The permissions for user on the template0 and template1 databases are the same as on my Ubuntu system for the superuser postgres. So I think your setup simple uses user as the superuser. So you could try this command to login:

    sudo -u user psql user

    If user is really the DB superuser you can create another DB superuser and a private, empty database for him:

    CREATE USER postgres SUPERUSER;
    CREATE DATABASE postgres WITH OWNER postgres;

    But since your postgres.app setup does not seem to do this, you also should not. Simple adapt the tutorial.

Deixe uma resposta

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *