Difference between revisions of "Pg dump"
Jump to navigation
Jump to search
| (8 intermediate revisions by 2 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 == | ||
| Line 15: | Line 23: | ||
* [[Restore DB]] | * [[Restore DB]] | ||
* <code>[[mysqldump]]</code> | * <code>[[mysqldump]]</code> | ||
| + | * [[Point-in-time recovery (PITR)]] | ||
| + | * [[PgBackRest]] | ||
| + | * <code>[[pg dump --schema-only]]</code> | ||
== See also == | == See also == | ||
| Line 20: | Line 31: | ||
* {{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_statpg_restoregcloud sql backups create- Restore DB
mysqldump- Point-in-time recovery (PITR)
- PgBackRest
pg dump --schema-only
See also[edit]
Advertising:
