Skip site navigation (1) Skip section navigation (2)

Re: Postgres version change - pg_dump

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 (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-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.

In response to

Responses

pgsql-novice by date

Next:From: Kretschmer AndreasDate: 2004-12-20 15:51:11
Subject: Re: pg_dumpall with oids/blobs
Previous:From: Marcin GilDate: 2004-12-20 15:25:31
Subject: Re: create user with password

pgsql-performance by date

Next:From: Stefan WeissDate: 2004-12-20 17:07:47
Subject: Re: [PERFORM] Postgres version change - pg_dump
Previous:From: Andreas KretschmerDate: 2004-12-20 14:54:16
Subject: Re: [despammed] Postgres version change - pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group