Home

Welcome to the Avalonia-Postgres-DB-Restore wiki!

For linux users: if having issue on restoring database in linux then refer to this link https://www.vultr.com/docs/how-to-install-configure-backup-and-restore-postgresql-on-ubuntu-20-04-lts/ or if you having connection problem on peer then

$ sudo nano /etc/postgresql/12/main/pg_hba.conf

Locate the line local all postgres peer as shown in the below content.

...

# Database administrative login by Unix domain socket
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only

...

Change the authentication method from peer to md5 so that the line reads local all postgres md5.

...

Database administrative login by Unix domain socket

local all postgres md5

TYPE DATABASE USER ADDRESS METHOD

"local" is for Unix domain socket connections only

...

Save and close the file by pressing CTRL + X, then Y and ENTER. Then, restart the postgresql service to load the new settings.

$ sudo systemctl restart postgresql