| From: | "Holger Marzen" <holger(at)marzen(dot)de> |
|---|---|
| To: | depesz(at)depesz(dot)pl |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: copying database? |
| Date: | 2002-03-04 13:26:50 |
| Message-ID: | 60853.62.181.135.97.1015241210.squirrel@bluebell.marzen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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".
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-03-04 13:46:09 | Re: postgre performance question |
| Previous Message | Gregory Wood | 2002-03-04 12:52:14 | Re: Arrays in pgsql |