On Thu, Oct 04, 2012 at 12:22:55PM +0530, Swayam Prakash Vemuri wrote:
> Hi
>
> We have an application which uses postgresql 7.4.5.
You have a very large problem. The 7.4 series went out of support two
years ago at 7.4.30, which means that you have known data corruption
and crash bugs, and would even if you were to upgrade to 7.4.30
immediately.
You need to upgrade to a supported version and put systems in place to
do upgrades of every component in the system on a regular basis, as
they all have finite lifetimes.
> Now when we moved to Java 1.6, we are seeing lots of jdbc driver related
> compilation issues like shown at end of this email.
Those appear to be Java issues pretty strictly.
> Question is can we just only upgrade jdbc driver alone or its better to
> move completely to a new postgres version. ?
>
> Are there any docs that explain about how to migrate ?
Use 9.2.1's pg_dump to get your data out of the running 7.4 database
and then restore it to the 9.2.1 database.
For each database on the 7.4 machine, run the following on the 9.2
machine:
pg_dump -h name.of.7.4.machine.com -U postgres -Fc --file=mydb.dump mydb
To restore on the 9.2 machine:
pg_restore -C mydb.dump
Hope this helps.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate