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
  2. Locate data directory and copy it
  3. Paste it to the new location
  4. Uninstall PGAdmin
  5. Reinstall PGAdmin
  6. When it asks for datadirectory, 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.