7
7
7761662017-05-07 14:28:14
PostgreSQL
776166, 2017-05-07 14:28:14

How to kosherly reroll a Postgres database?

Lamersky question, but reading the manuals does not form a complete picture of how to do it right.
Given: postgres, database, a separate user to access this database with a password.
Task: to completely reroll the database dump.
How to do it on behalf of this user?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Swartalf, 2017-05-08
@776166

pg_dump + pg_restore/psql
pg_basebackup.
It all depends on the amount of data, server, access rules, task, etc.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question