Coder.com•2mo ago

How to migrate to a new vps?

Hello I want to migrate my existing coder instance to a new vps. Old installation is using install script and systemd. On the new server i would like to install it in docker (compose). Are there any guides on this?

16 Replies

Codercord•2mo ago

<#1346567206170791937>

Category

Help needed

Product

Coder (v2)

Platform

Linux

Logs

Please post any relevant logs/error messages.

Phorcys•2mo ago

hey, all you need to do is migrate the postgres database

Greenman999OP•2mo ago

using pg_dump ? and nothing more? no configs or anything else? uhh i dumped the db but the dump contains nothing

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.7
-- Dumped by pg_dump version 13.19 (Debian 13.19-0+deb11u1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- PostgreSQL database dump complete
--

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.7
-- Dumped by pg_dump version 13.19 (Debian 13.19-0+deb11u1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- PostgreSQL database dump complete
--

Phorcys•5w ago

you do need to copy your env/config files too, but templates and everything else is stored in-database are you sure you dumped the coder db? and not some built-in postgres database or similar?

Greenman999OP•5w ago

I followed these instructions https://coder.com/docs/admin/setup#migrating-from-the-built-in-database-to-an-external-database

Setup | Coder Docs

Configure user access to your control plane.

Greenman999OP•5w ago

And from the logs and env vars of coder it seems like it uses the builtin db Hmm it seems like this db gets used /home/coder/.config/coderv2/postgres/bin/bin/postgres but i found no way to connect to it @Phorcys do you have an idea?

Phorcys•5w ago

have you launched coder server postgres-builtin-serve?

Greenman999OP•5w ago

Yea as mentioned in the link i sent

Phorcys•5w ago

after doing this you'll want to use the psql CLI, you might have to install it or use it from /home/coder/.config/coderv2/postgres/bin/bin, not sure whether it exists in there though

Greenman999OP•5w ago

Okay it worked now after starting the builtin server with the right user and then using pg_dump

Phorcys•5w ago

nice

Greenman999OP•5w ago

but i do need to copy the volumes right?