Cloning databases using rsync
От | David Gaudine |
---|---|
Тема | Cloning databases using rsync |
Дата | |
Msg-id | 43F626F6.1090302@alcor.concordia.ca обсуждение исходный текст |
Ответы |
Re: Cloning databases using rsync
|
Список | pgsql-novice |
I regularly copy all my postgresql data onto another computer and access it locally there. This works if I use pg_dump, transfer the output file, and feed that file into psql. However, I would prefer to copy the databases using rsync instead of pg_dump, because it's simpler and faster. (I know the server has to be down to avoid corruption.) rsync -avx --delete 132.205.86.95:/var/lib/postgresql /var/lib After doing this, when I run psql I get psql: FATAL: database "xxxxx", OID 12345, has disappeared from pg_database where "xxxxx" and 12345 depend on the database. /var/lib/postgresql is identical on both systems, and so is /etc/postgresql other than host-specific things like IP addresses. The version is the same (8.0). The directory "12345" exists. Any ideas of what else might have to be copied? David
В списке pgsql-novice по дате отправления: