PDA

View Full Version : Postgresql question.



Boglord
01-27-2010, 12:47 AM
I have my current Postgresql installed on my main HD which is rather small.

I am planning to buy a new bigger HD and was wondering if I can set it up such that postgresql saves it's info on the new HD without affecting the old DBs.

Thank you,

netsrak
01-27-2010, 05:05 AM
The easiest is to backup your database, uninstall postgresq, reinstall it to the new partition and restore your backup.

There are other solutions around but they require some system knowledge.

Boglord
01-27-2010, 08:22 AM
Perhaps you can suggest the other solutions?

The database is rather huge, I believe around 125-150 gb?

netsrak
01-27-2010, 12:50 PM
Solution 1: create a postgresql folder structure on the new partition and copy your existing data folder to this folder. Rename your original data folder to data.backup or sth. like that. Uninstall postgresql. Install the same postgresql version to the new postgresql folder and follow this hints: http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database

Solution 2: use google to search for "move postgresql to a new partition" or sth. like that. We don't have it in our FAQ but you should see lots of hits.