D
D
DamskiyUgodnik2020-02-26 11:33:23
PostgreSQL
DamskiyUgodnik, 2020-02-26 11:33:23

How to make a partitioned dump in PostgreSql?

Hello.
What we have:
A database with a bunch of tables (some of them are partitioned)

What we are doing:
I am trying to dump via pg_dump with the following command (the table is partitioned)

pg_dump -t table_name --encoding=utf8 -v > dump.sql

Problem:
Partitions and data from them do not get into the dump, but it is necessary that they do .

Question:
Please tell me how to make a "full" dump of one table, with all partitions, data, etc., using pg_dump.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question