Re: Automating Backup & Restor
От
Mikko Partio
Тема
Re: Automating Backup & Restor
Дата
Msg-id
2ca799770710241020t57c01508p7ee36a218b28f215@mail.gmail.com
Ответ на
Automating Backup & Restore (smiley2211)
Список
Дерево обсуждения
Automating Backup & Restore smiley2211 <smiley2211@yahoo.com>
Re: Automating Backup & Restore Jan de Visser <jdevisser@digitalfairway.com>
Re: Automating Backup & Restore brian <brian@zijn-digital.com>
Re: Automating Backup & Restore smiley2211 <smiley2211@yahoo.com>
Re: Automating Backup & Restor "Mikko Partio" <mpartio@gmail.com>
On 10/24/07, smiley2211 <smiley2211@yahoo.com> wrote:
server1$ pg_dump mydb | psql -h server2 -d mydb
Regards
M
Hello all,
Does someone have a script that backups a database from one server and
restores it to another server??? I am NEW to Postgresql so I am starting
from scratch...
so, in essence - what I want to do is (I CURRENTLY DO THIS MANUALLY):
Server1 (IS IT POSSIBLE TO DUMP DIRECTLY TO SERVER2??)
pg_dump > filename.dmp
scp filename.dmp to SERVER2
Server2
psql -d mydb -f filename.dmp
vacuum
reindex
server1$ pg_dump mydb | psql -h server2 -d mydb
Regards
M
В списке pgsql-general по дате отправления
