Another option is to leave PostgreSQL on the original disk and have it copy the existing database into a new tablespace on the new hard drive although I haven't tried this with such a large database and I am not sure whether this would need to use free space on the disk where PostgreSQL is installed or in your %TEMP% directory. You would also need to take care not to unintentionally change anything in your registry while making the necessary changes. Making a backup and reinstalling PostgreSQL would be the most straightforward method but if you choose the change the default PGDATA directory on Windows I'd still recommend making a backup before you move the data directory in case you cannot connect to your original database again.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |