Commit5113054

authored

docs: Add steps to migrate from the built-in database to an external database (#7614)

1 parentef2411e commit5113054Copy full SHA for 5113054

File tree

+11

-0

lines changed

+11

-0

lines changed

Lines changed: 11 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -65,6 +65,17 @@ coder server postgres-builtin-url`
`65`	`65`	`psql "postgres://coder@localhost:49627/coder?sslmode=disable&password=feU...yI1"`
`66`	`66`	```
`67`	`67`
	`68`	`+###Migrating from the built-in database to an external database`
	`69`	`+`
	`70`	`+To migrate from the built-in database to an external database, follow these steps:`
	`71`	`+`
	`72`	`+1. Stop your Coder deployment.`
	`73`	+2. Run`coder server postgres-builtin-serve` in a background terminal.
	`74`	+3. Run`coder server postgres-builtin-url` and copy its output command.
	`75`	+4. Run`pg_dump <built-in-connection-string> > coder.sql` to dump the internal database to a file.
	`76`	+5. Restore that content to an external database with`psql <external-connection-string> < coder.sql`.
	`77`	+6. Start your Coder deployment with`CODER_PG_CONNECTION_URL=<external-connection-string>`.
	`78`	`+`
`68`	`79`	`##System packages`
`69`	`80`
`70`	`81`	`If you've installed Coder via a[system package](../install/packages.md) Coder, you can`

Comments

(0)