Page 1 of 1

Need to store database on partition "D:" instead of "C:"

PostPosted: Mon May 26, 2008 6:44 am
by Vondur
Im in the midst of converting PT2 Databases to PostgreSQL to PT3. PostgreSQL is currently installed on "C:" (dont remember any option being given) and I want it to store the actual databases on my other partition since C: dont have alot of space. How do I do this when converting the PT2 DB's to PostgreSQL?

edit: What should i choose from in the "ODBC entry to use" and "encoding"?

Re: Need to store database on partition "D:" instead of "C:"

PostPosted: Mon May 26, 2008 1:38 pm
by WhiteRider
I'll let one of the postgres experts answer your main question, but have a look at this topic, which contains info about your edit:
It is possible to use PT2 with postgres 8.3

Re: Need to store database on partition "D:" instead of "C:"

PostPosted: Tue May 27, 2008 1:37 am
by bugsbunny
Assuming you have nothing stored in the DB yet the easiest way to do this is to uninstall postgres. Make surethat you delete the directory completely and remove the postgres user from your system

Download the installer from the postgres site. http://www.postgresql.org/ftp/binary/v8.3.1/win32/
choose postgresql-8.3.1-1.zip
Extract the files and then run the installer (the msi file, without the -int in it). The installer will allow you to choose where to install the various components, so you can point the DB cluster to D: rather than C: (something like D:\pgdata would work).

Re: Need to store database on partition "D:" instead of "C:"

PostPosted: Tue May 27, 2008 8:06 am
by Vondur
Thanks alot, that will solve my problem i think.