Thread: copying database?
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]
> 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. You can pipe the output to gzip (makes the file probably smaller) or split (splits it into smaller pieces). Restore with "cat file1 file2 file2 | psql dbname".
On Mon, Mar 04, 2002 at 12:26:50PM -0100, Holger Marzen wrote: > > pg_dump is nto an option - due to time of inserting >1G data into new > > database. > You can pipe the output to gzip (makes the file probably smaller) or split > (splits it into smaller pieces). Restore with "cat file1 file2 file2 | psql dbname". the problem is not in transferring data, but in insert time. depesz -- hubert depesz lubaczewski http://www.depesz.pl/ ------------------------------------------------------------------------ ... vows are spoken to be broken ... [enjoy the silence] ... words are meaningless and forgettable ... [depeche mode]