PDA

View Full Version : postgres database on seperate drive



dan233
01-30-2010, 10:11 PM
hi
how can i install the postgres database on a seperate drive during the installation process?
I dont have postgres nor hem installed yet so I m not about to "move" an already existing database here.
seems like the combo installer doesnt allow you to install the database anywhere else than on C: drive which is too small.
the "one klick" installer doesnt seem to allow for this either

Terminator
01-31-2010, 12:33 AM
Well Ive used One click installer for postgre and I could do that. Just look carfully on every step in the beginning and youll find it.

good luck.

dan233
01-31-2010, 12:53 AM
Well Ive used One click installer for postgre and I could do that. Just look carfully on every step in the beginning and youll find it.

good luck.


but this installs the entire postgres app to the chosen HDD, right? not just the database..?
can the entire postgres application be installed on a seperate drive? or does it need to be on the same drive as the os?

Terminator
01-31-2010, 03:11 AM
It worked for me just installing it under another drive. Doing exactly that.

netsrak
01-31-2010, 07:55 AM
Another solution is to create a new "tablespace" via pgadmin which locates on another partition. Then create a new database using this tablespace.
But this needs some Postgresql knowledge.

dan233
01-31-2010, 03:20 PM
Another solution is to create a new "tablespace" via pgadmin which locates on another partition. Then create a new database using this tablespace.
But this needs some Postgresql knowledge.
thanks for the reply:)
what do you think about these instructions?:
http://faq.holdemmanager.com/questions/336/How+do+I+setup+Holdem+Manager+to+share+one+databas e+between+two+computers%3F

would it accomplish the same thing?(the part about moving the database and changing the "path" in registry) if not, what is the difference?

fozzy71
01-31-2010, 06:45 PM
I am actually working on new FAQ's for this and a couple of similar situations, when using the 8.4 version. All of our old/current FAQs reference 8.3.


but this installs the entire postgres app to the chosen HDD, right? not just the database..?
can the entire postgres application be installed on a seperate drive? or does it need to be on the same drive as the os?

If you use one of these one-click installers from Enterprise DB, it allows you to pick the Install path and the Data Directory path during installation.

http://www.holdemmanager.com/downloads/postgresql_8.4.2.1.exe

http://www.holdemmanager.com/downloads/postgresql_8.4.1.1.exe


In the past I have always uninstalled PostgreSQL, moved the \data folder to the new drive, and picked the new Data Directory path during installation.


thanks for the reply:)
what do you think about these instructions?:
http://faq.holdemmanager.com/questions/336/How+do+I+setup+Holdem+Manager+to+share+one+databas e+between+two+computers%3F

would it accomplish the same thing?(the part about moving the database and changing the "path" in registry) if not, what is the difference?

For some reason I had never tried it this way. I followed all the steps in Part B, and it worked perfect for me. I will be using this process whenever possible now.