PostgresSQL: Allow postgres user to login in Adminer without linux user

[michelroegl-brunner]

This only applys to old installs of PostgresSQL and if you have Adminer installed.

When Adminer is not installed and you need it after running the install script, follow these steps:

apt-get install -y adminer
a2enconf adminer
systemctl reload apache2

If you want to access Adminer with your Postgres User without creating a Linux User you need to to do changes in pg_hba.conf

vim /etc/postgresql/17/main/pg_hba.conf

In this File you need to change the row:

local all all peer
to
local all all md5

After the change you need to restart Postgressql:

systemctl restart postgresql

Now you can access Adminer with your PostgresSQl user.