R
R
Roman Rakzin2017-10-03 15:33:19
PostgreSQL
Roman Rakzin, 2017-10-03 15:33:19

How to easily and quickly create a dump of a postgresql database with schemas and data, then add the dump to another server?

How to easily and quickly create a dump of a postgresql database with schemas and data, then add the dump to another server?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander, 2017-10-03
@agolub

https://www.postgresql.org/docs/9.1/static/backup-...

K
ky0, 2017-10-03
@ky0

pg_dump, ssh, pg_restore. It is possible in one line using pipes. If the base is healthy, I would do it not through a dump / restore, but through pg_basebackup.
Relevant discussion on SO - https://stackoverflow.com/questions/1237725/copyin...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question