Use 7.4.1's pg_dump in 7.2.4?

[Anjan Dave]

Can I use the pg_dump from 7.4.1 on 7.4.2?



I tried copying a couple of libraries that it needed, and I can copy
one-by-one that it looks for, but I am not sure how many does it need in
all for the new version to work...



Purpose is to dump/restore a pretty good-sized db (19GB) on 7.2.4, so I
can upgrade it to 7.4.1.



Thanks,

Anjan

[Peter Eisentraut]

Post by Anjan Dave
Purpose is to dump/restore a pretty good-sized db (19GB) on 7.2.4, so
I can upgrade it to 7.4.1.

pg_dump should be able to dump databases back to about 7.1, so you
should be good to go. As always, if you have problems, we would like
to hear about it.

By the way, the latest version is 7.4.2 already.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Anjan Dave]

I am having some trouble restoring the data back on 7.4.1 (made from
pg_dump on 7.2.4), that's the reason I would like to try dumping using
the pg_dump version of 7.4.1.

I had read in a post somethere by Tom Lane that the pg_dump of 7.4.1 can
be used to dump data on earlier versions, which is what I wanted to try.

-anjan

-----Original Message-----
From: Peter Eisentraut [mailto:***@gmx.net]
Sent: Monday, April 05, 2004 1:36 PM
To: Anjan Dave; pgsql-***@postgresql.org
Subject: Re: [ADMIN] Use 7.4.1's pg_dump in 7.2.4?

Post by Anjan Dave
Purpose is to dump/restore a pretty good-sized db (19GB) on 7.2.4, so
I can upgrade it to 7.4.1.

pg_dump should be able to dump databases back to about 7.1, so you
should be good to go. As always, if you have problems, we would like
to hear about it.

By the way, the latest version is 7.4.2 already.




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match