Skip to content

Commit 22860b8

Browse files
authored
Merge pull request MicrosoftDocs#36481 from trondhindenes/patch-1
fixed character bug in pg_restore command
2 parents ec5dbcd + a591042 commit 22860b8

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

articles/postgresql/howto-migrate-using-dump-and-restore.md

+1-1
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ pg_dump -Fc -v --host=localhost --username=masterlogin --dbname=testdb > testdb.
3131
## Restore the data into the target Azure Database for PostrgeSQL using pg_restore
3232
After you've created the target database, you can use the pg_restore command and the -d, --dbname parameter to restore the data into the target database from the dump file.
3333
```bash
34-
pg_restore -v --no-owner -host=<server name> --port=<port> --username=<user@servername> --dbname=<target database name> <database>.dump
34+
pg_restore -v --no-owner --host=<server name> --port=<port> --username=<user@servername> --dbname=<target database name> <database>.dump
3535
```
3636
Including the --no-owner parameter causes all objects created during the restore to be owned by the user specified with --username. For more information, see the official PostgreSQL documentation on [pg_restore](https://www.postgresql.org/docs/9.6/static/app-pgrestore.html).
3737

0 commit comments

Comments
 (0)