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

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

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

Postby Vondur » Mon May 26, 2008 6:44 am

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"?
Vondur
 
Posts: 39
Joined: Mon May 26, 2008 5:36 am

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

Postby WhiteRider » Mon May 26, 2008 1:38 pm

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
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby bugsbunny » Tue May 27, 2008 1:37 am

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).
bugsbunny
 
Posts: 65
Joined: Sun Feb 10, 2008 9:29 am

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

Postby Vondur » Tue May 27, 2008 8:06 am

Thanks alot, that will solve my problem i think.
Vondur
 
Posts: 39
Joined: Mon May 26, 2008 5:36 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests