Move data files to different disk ?

[Parket]

I still have my database files just in the normal install directory of PostgreSQL on my C-drive. As I recently plugged in an extra disk, it's worthwhile for both performance and free disk space to move my database to the new disk.
Is this just a matter of moving the 'data' directory to the new disk, and then changing some configuration file of PostgreSQL ? If so, what config do I need to adapt ?

[kraada]

The easiest way to do this is actually to uninstall PostgreSQL, move the data file onto the separate disk, then reinstall PostgreSQL and in the reinstallation choose the target as that separate disk in the location so your data folders match up - then PostgreSQL will use that data folder and everything will be stored on your secondary drive.

[Parket]

Ok thanks. I'll use the opportunity to upgrade to 9.0 as well then.

[Parket]

I realized that just dumping the 8.3 data files in the 9.0 directory was probably a bit risky, so I created an empty database and used Backup/Restore to populate the 9.0 database on the new disk.

[kraada]

Well that wouldn't be risky so much as it just wouldn't work - 9.0 can't read 8.3 database files. But the method you used works in that case.