Difference between revisions of "Pg dump"
Jump to navigation
Jump to search
(14 intermediate revisions by 4 users 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>--schema-only</code> | ||
+ | |||
+ | * <code>--include-foreign-data (2020 [[PostgreSQL 13]])</code> | ||
+ | |||
+ | |||
+ | 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 == | == Related terms == | ||
− | * <code>[[pg_class]]</code> | + | * <code>[[pg_class]]</code>, <code>[[pg_stat]]</code> |
− | |||
* <code>[[pg_restore]]</code> | * <code>[[pg_restore]]</code> | ||
* <code>[[gcloud sql backups create]]</code> | * <code>[[gcloud sql backups create]]</code> | ||
+ | * [[Restore DB]] | ||
+ | * <code>[[mysqldump]]</code> | ||
+ | * [[Point-in-time recovery (PITR)]] | ||
+ | * [[PgBackRest]] | ||
+ | * <code>[[pg dump --schema-only]]</code> | ||
== See also == | == See also == | ||
+ | * {{pg_dump}} | ||
* {{pg}} | * {{pg}} | ||
* {{DB backup}} | * {{DB backup}} | ||
− | |||
[[Category:Backup]]] | [[Category:Backup]]] | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] |
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: