PostgreSQL Backup: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(→Links) |
(→Backup) |
||
| Zeile 1: | Zeile 1: | ||
== Backup == | == Backup == | ||
=== im SQL-Format === | |||
<pre> | <pre> | ||
pg_dump [-h 10.2.0.123] -U postgres -Fc testdb > testdb.dump | |||
</pre> | |||
=== komprimiert === | |||
<pre> | |||
pg_dump [-h 10.2.0.123] -U postgres -Fc testdb > testdb.dump | |||
</pre> | </pre> | ||
Version vom 10. Juni 2019, 10:06 Uhr
Backup
im SQL-Format
pg_dump [-h 10.2.0.123] -U postgres -Fc testdb > testdb.dump
komprimiert
pg_dump [-h 10.2.0.123] -U postgres -Fc testdb > testdb.dump
Restore
Links
https://www.postgresql.org/docs/9.1/backup-dump.html
http://postgresguide.com/utilities/backup-restore.html
https://www.postgresql.org/docs/9.3/app-pgdump.html
https://dba.stackexchange.com/questions/161857/how-to-backup-restore-in-postgresql-pgadmin-4
Zurück zu PostgreSQL