Importing database file into psgs

Support - Assistance technique
1

Can some one help how to import back up database file into PostgreSQL??

1 Like
2

Hi @DaniGilbert,

you can do this from your terminal:

psql -d <database> -U <user> -f <path-to-file>

Make sure your database is set up beforehand with postgis if required.

1 Like
3

thx

1 Like
4

psql: FATAL: Peer authentication failed for user “tb1”
This what i got

1 Like
5

@DaniGilbert,

that error means you are unable to authenticate the user you provided. Please make sure your postgres and user configuration is correct.

Please note that this is not a DHIS2 related issue, but a postgres issue. It might be easier for you to google the issue.

1 Like
6

Thx a lot @ Stian

1 Like