| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | copying database? |
| Date: | 2002-03-04 11:05:09 |
| Message-ID: | 20020304120508.A17900@depesz.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Rae | 2002-03-04 11:28:20 | Re: Aborting transaction on error |
| Previous Message | Gavin M. Roy | 2002-03-04 07:31:32 | Re: ERD or UML tool |