| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | sarlav kumar <sarlavk(at)yahoo(dot)com> |
| Cc: | pgsqlnovice <pgsql-novice(at)postgresql(dot)org>, pgsqlperform <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Postgres version change - pg_dump |
| Date: | 2004-12-20 15:47:49 |
| Message-ID: | 20041220154749.GA1603@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
On Mon, Dec 20, 2004 at 06:40:34 -0800,
sarlav kumar <sarlavk(at)yahoo(dot)com> wrote:
>
> I would like to do a pg_dump on the test database, and restore it in the new database on Postgres 7.4.6. I would like to know if there would be any problem due to the postgres version/OS change. If so, could someone tell me what precautions I can take to avoid any problems?
You should use the 7.4.6 version of pg_dump to dump the old database. Note
you still need to be running the 7.3.2 server for the old database.
pg_dump will be just acting like a client connecting over the network
and will work with older versions of the server.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kretschmer Andreas | 2004-12-20 15:51:11 | Re: pg_dumpall with oids/blobs |
| Previous Message | Marcin Gil | 2004-12-20 15:25:31 | Re: create user with password |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Weiss | 2004-12-20 17:07:47 | Re: [PERFORM] Postgres version change - pg_dump |
| Previous Message | Andreas Kretschmer | 2004-12-20 14:54:16 | Re: [despammed] Postgres version change - pg_dump |