From: | David Gaudine <davidg(at)alcor(dot)concordia(dot)ca> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Cloning databases using rsync |
Date: | 2006-02-17 19:41:42 |
Message-ID: | 43F626F6.1090302@alcor.concordia.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-02-17 20:15:32 | Re: Cloning databases using rsync |
Previous Message | Michael Fuhr | 2006-02-17 17:09:57 | Re: Writing Python triggers and the TD dictionary value |