Change Database

[KokoNuts3]

Hi guys,

currently i have 12GB database on my computer but the thing is i have no more free memory. i do have an external hard drive wich has infinit space.

i downt want to change the curent database. the only thing i want to do is that my future hands will be saved in my external hard drive.

i tried some things but my english is not the best and i did not suceed.

[Flag_Hippo]

First you will need to backup the existing database:

Guide: Backup & Restore

however PostgreSQL requires free space on your disc drive when actioning a database backup and the free space required will need to be around the same size as the database being backed up. If you do not have this you will either need to free up the space required or have Windows use another location for temorary files:

How to Move Windows Temporary Folders to Another Drive

After you have a backup file you can then uninstall PostgreSQL, reinstall it on the other drive and then restore your database backup:

Download PostgreSQL

Do not install a major version of PostgreSQL that is lower than the one you are currently using and do not install anything higher than v12.