Unable to connect to Postgres - role 'postgres' doesn't exist


  • | 2043 points

    I downloaded binaries for PG 13 and decompress under bin\postgres\postgres...version...

    I restarted Laragon and postgres started well.

    Now I'm on pgadmin and I cannot connect to postgres.

    I'm trying to use postgres as username but it says me that postgres role doesn't exists.

    0_1615374927657_upload-eca56a3e-ff49-4303-a9b6-1a6e6deb3dd8

    0_1615374952956_upload-d64fd969-8434-4c51-aa5c-d16074163ec4

    What's the trick?

    I alkso tried from command line (it's my first time with Postgresql since a lot of years)

    0_1615375446499_upload-d7952d73-09a1-4d9f-8738-a82cf05c23a8

    It looks for a db named 'mirko' ... I don't know why it's looking a db with my personal name as db name ... where does is this setup?


  • | 2043 points

    i still canot understand defaults ...

    0_1615375572255_upload-4bac72ad-ef35-44b8-a51e-67bebc4ab762

    But using mirko as username works from pgadmin

    Still I cannot login from command line

    I will delete pgsql instllation dir and data and restart .

    Is there anofficial guide to first run of pg under laragon?


  • | 12 points

    I've the same issue, have you managed to resolve?


  • administrators
    | 132019 points

    @realtebo , @Deca : Database & Username is your Windows username.
    For example if your Windows username is deca.
    Database: deca
    Username: deca
    No password as you are using local user.
    After connecting, you can create another super user with password.


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.