> 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".