copying database? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject copying database?
Date
Msg-id 20020304120508.A17900@depesz.pl
Whole thread Raw
Responses Re: copying database?  ("Holger Marzen" <holger@marzen.de>)
List pgsql-general
hi
i have working installation of postgresql 7.2 in one location.
then i have devel machine which should have more or less curent database
on it.
problems:
1. database is > 1gigabytes of data
2. devel machine need r/w access, but all changes to this database has
to be overwritten when downloading new version from working installation
3. i cannot shut down working installation even for a moment.

pg_dump is nto an option - due to time of inserting >1G data into new
database.
i tried to copy DATADIR from working to devel, but it didn't help
(problem with pg_xlog and missing data).

any ideas?

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ...                 [enjoy the silence]
... words are meaningless and forgettable ...             [depeche mode]

pgsql-general by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: ERD or UML tool
Next
From: Martina Mostert
Date:
Subject: Arrays in pgsql