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 по дате отправления: