copying database?
От | hubert depesz lubaczewski |
---|---|
Тема | copying database? |
Дата | |
Msg-id | 20020304120508.A17900@depesz.pl обсуждение исходный текст |
Ответы |
Re: copying database?
|
Список | 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 по дате отправления: