Re: [GENERAL] converting older databases

2009-03-05 Thread Scott Marlowe
On Thu, Mar 5, 2009 at 5:56 PM, Sathish Duraiswamy wrote: > Thanks for ur reply John > > For information , We have Novell SuSe 11.0 server ON x86_32 and we have > installed from source code Then all you need to do is run ./configure with the same --prefix switch as you did before, and then make ;

Re: [GENERAL] converting older databases

2009-03-05 Thread Sathish Duraiswamy
Thanks for ur reply John For information , We have Novell SuSe 11.0 server ON x86_32 and we have installed from source code Regards sathish On Fri, Mar 6, 2009 at 1:46 AM, John R Pierce wrote: > Sathish Duraiswamy wrote: > >> hai >> >> Recently we migrated our database from 8.2.4 to 8.2.12 , w

Re: [GENERAL] converting older databases

2009-03-05 Thread John R Pierce
Sathish Duraiswamy wrote: hai Recently we migrated our database from 8.2.4 to 8.2.12 , went through manuals and followed the below steps 1.pg_dumpall to take data dump of current database 2.stopped database 3.moved the pgsql to backup folder 4.downloaded 8.2.12 , configured - gmake - gmake i

Re: [GENERAL] converting older databases

2009-03-05 Thread Sathish Duraiswamy
hai Recently we migrated our database from 8.2.4 to 8.2.12 , went through manuals and followed the below steps 1.pg_dumpall to take data dump of current database 2.stopped database 3.moved the pgsql to backup folder 4.downloaded 8.2.12 , configured - gmake - gmake install 5.recreated cluster dir

Re: [GENERAL] converting older databases

2009-03-05 Thread John R Pierce
Heine Ferreira wrote: Hi When you install a newer version of Postgres how do you upgrade your database to the new format? Apparantly you can't just backup the old database and restore it on the new software. How do you do this on Windows? you pg_dump >dumpfile.sql the old one, psql -f dumpf

[GENERAL] converting older databases

2009-03-05 Thread Heine Ferreira
Hi When you install a newer version of Postgres how do you upgrade your database to the new format? Apparantly you can't just backup the old database and restore it on the new software. How do you do this on Windows? Thanks H.F.