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•2mo 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•2mo 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•2mo 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•2mo ago

have you launched coder server postgres-builtin-serve?

Greenman999OP•2mo ago

Yea as mentioned in the link i sent

Phorcys•2mo 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•2mo ago

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

Phorcys•2mo ago

nice

Greenman999OP•2mo ago

but i do need to copy the volumes right?

Phorcys•2mo ago

oh yeah sorry about that, you do need to copy over anything persistent that your templates use hey @Greenman999, I assume you've got this one sorted?

Greenman999OP•2mo ago

yes thanks

Phorcys•2mo ago

sounds good, closing the issue then :-)

Codercord•2mo ago

@Phorcys closed the thread.

Gaming

Programming

How to migrate to a new vps?

Did you find this page helpful?