Difference between revisions of "Pg dump"
Jump to navigation
Jump to search
(3 intermediate revisions by one other user not shown) | |||
Line 2: | Line 2: | ||
[[wikipedia:pg_dump]] | [[wikipedia:pg_dump]] | ||
* https://www.postgresql.org/docs/current/app-pgdump.html | * https://www.postgresql.org/docs/current/app-pgdump.html | ||
+ | * https://trends.google.com/trends/explore?date=all&q=PgBackRest,pg_dump | ||
+ | |||
* <code>[[pg_dump --help]]</code> | * <code>[[pg_dump --help]]</code> | ||
Line 11: | Line 13: | ||
file your-dump | file your-dump | ||
your-dump: PostgreSQL custom database dump - v1.14-0 | your-dump: PostgreSQL custom database dump - v1.14-0 | ||
+ | |||
+ | pg_dump --version | ||
+ | pg_dump (PostgreSQL) 14.7 (Ubuntu 14.7-1.pgdg22.04+1) | ||
== Related terms == | == Related terms == | ||
Line 19: | Line 24: | ||
* <code>[[mysqldump]]</code> | * <code>[[mysqldump]]</code> | ||
* [[Point-in-time recovery (PITR)]] | * [[Point-in-time recovery (PITR)]] | ||
+ | * [[PgBackRest]] | ||
+ | * <code>[[pg dump --schema-only]]</code> | ||
== See also == | == See also == |
Latest revision as of 07:00, 8 March 2023
- https://www.postgresql.org/docs/current/app-pgdump.html
- https://trends.google.com/trends/explore?date=all&q=PgBackRest,pg_dump
--schema-only
--include-foreign-data (2020 PostgreSQL 13)
file your-dump your-dump: PostgreSQL custom database dump - v1.14-0
pg_dump --version pg_dump (PostgreSQL) 14.7 (Ubuntu 14.7-1.pgdg22.04+1)
Related terms[edit]
pg_class
,pg_stat
pg_restore
gcloud sql backups create
- Restore DB
mysqldump
- Point-in-time recovery (PITR)
- PgBackRest
pg dump --schema-only
See also[edit]
Advertising: