PDA

View Full Version : Moving a postgresql database to another drive?



remiremi
12-17-2009, 01:37 PM
I isntalled postgresql on my c:\ drive, but the db is getting to big now and i would like to move it to the d:\ drive..

what is the simplest way of doing this?

doing a backup then reinstalling postgresql on d: and restoring it? would that even work?

netsrak
12-17-2009, 03:02 PM
Yes thats the best way.

There is another way but it needs registry patches and changes in configuration files.