How to migrate from the built-in postgres database to an external database without losing data. #7058

matifali · 2023-04-09T04:23:00Z

matifali
Apr 9, 2023
Maintainer

Is there a way to migrate to an external database from the built-in database without losing the data?

Answered by kylecarbs

The following steps should work:

Stop your Coder deployment.
Run coder server postgres-builtin-serve in a background terminal.
Run coder server postgres-builtin-url and copy its output command.
Run pg_dump <connection-string> to dump the database contents. Then restore that content to an external database, and start Coder pointing at the new one!

Let me know if something needs to be changed; happy to help!

kylecarbs · 2023-04-12T03:18:34Z

The following steps should work:

Stop your Coder deployment.
Run coder server postgres-builtin-serve in a background terminal.
Run coder server postgres-builtin-url and copy its output command.
Run pg_dump <connection-string> to dump the database contents. Then restore that content to an external database, and start Coder pointing at the new one!

Let me know if something needs to be changed; happy to help!

3 replies

Thanks, Kyle, for the detailed steps. It was swift to move to an external DB.

Moving these steps to our docs.