Answer the question
In order to leave comments, you need to log in
How to restore a PostgreSQL database from two dumps?
The site creates a database dump every night (in plain text format):
sudo -u postgres pg_dump ${DB} | gzip > ../backup/`date +%Y-%m-%d`.${DB}.sql.gz
COPY table1 (id, поля... ) FROM stdin;
1 данные для полей
\.
COPY table1 (id, поля...) FROM stdin;
2 данные для полей
\.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question