Difference between revisions of "Pg dump"
Jump to navigation
Jump to search
| (26 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | {{ | + | {{lowercase}} |
| + | [[wikipedia:pg_dump]] | ||
| + | * 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_stat]]</code> | ||
| + | * <code>[[pg_restore]]</code> | ||
| + | * <code>[[gcloud sql backups create]]</code> | ||
| + | * [[Restore DB]] | ||
* <code>[[mysqldump]]</code> | * <code>[[mysqldump]]</code> | ||
| − | * <code>[[ | + | * [[Point-in-time recovery (PITR)]] |
| + | * [[PgBackRest]] | ||
| + | * <code>[[pg dump --schema-only]]</code> | ||
== See also == | == See also == | ||
| − | * {{ | + | * {{pg_dump}} |
| − | + | * {{pg}} | |
| + | * {{DB backup}} | ||
| − | |||
[[Category:Backup]]] | [[Category:Backup]]] | ||
| + | [[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_statpg_restoregcloud sql backups create- Restore DB
mysqldump- Point-in-time recovery (PITR)
- PgBackRest
pg dump --schema-only
See also[edit]
Advertising:
