R
R
romaro2021-12-06 23:50:23
PostgreSQL
romaro, 2021-12-06 23:50:23

How to make a selective backup in Postgres?

I use a built-in utility to dump the logical structure, a command of the form:

pg_dump -s test > /var/lib/pgsql/14/backups/logic_06_12_2021.dump


Is it possible to create a config for pg_dump that will list tables that need not only a logical structure, but also all the data contained in them? These are tables that store application settings (for example, order statuses).

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
ky0, 2021-12-07
@ky0

Of course. Look at options -tand -T pg_dump `a.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question