Content
View differences
Updated by Jeff Li over 2 years ago
Hi,
This command in [https://www.openproject.org/docs/installation-and-operations/misc/migration/#postgresql-database](https://www.openproject.org/docs/installation-and-operations/misc/migration/#postgresql-database) is error, error,
```bash
# Restore the PostgreSQL dump
pg_restore -h <dbhost> -u <dbuser> -W --dbname <dbname> --clean postgresql-dump-20180408095521.pgdump
```
It should be -U not -u, and missing -p 45432 parameter, correct command should shoud be:
```bash
# Restore the PostgreSQL dump
pg_restore -h <dbhost> -p <dbport> -U <dbuser> -W --dbname <dbname> --clean postgresql-dump-20180408095521.pgdump
```
This command in [https://www.openproject.org/docs/installation-and-operations/misc/migration/#postgresql-database](https://www.openproject.org/docs/installation-and-operations/misc/migration/#postgresql-database) is error,
```bash
# Restore the PostgreSQL dump
pg_restore -h <dbhost> -u <dbuser> -W --dbname <dbname> --clean postgresql-dump-20180408095521.pgdump
```
It should be -U not -u,
```bash
# Restore the PostgreSQL dump
pg_restore -h <dbhost>
```