Migrating a PostgreSQL Database

Have more questions? Submit a request
Note: This can take time to accomplish.  The installation of software can take 30+ minutes.  The moving of the data will depend on how large the database is.  So plan on overnight.
  1. Stop PostgreSQL Service using task manager
  2. Locate the PostgreSQL data directory and copy it
  3. Paste it to the new location and rename the old data directory file. 
  4. Uninstall PostgreSQL 18 (This will not remove the database files)

  5. Reinstall PostgreSQL 18

     
  6. When it asks for data directory, point it to the new location from above.


     
  7. Restart windows
 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.