Twenty•2mo ago

Data Migration to another host.

Hey guys I need to migrate my database from testing server to the main one. Can someone actually help me on this?

31 Replies

Do you want to migrate the whole data ? why not using pg_dump / psql to dump and restore?

Hi @Nathan What I do (and I use the same logic to backup my prod server): On old server :

pg_dump postgres://twenty:twenty@localhost:5432/default > db_today.sql

pg_dump postgres://twenty:twenty@localhost:5432/default > db_today.sql

On new server :

dropdb -U twenty -h localhost -p 5432 default
createdb  -U twenty -h localhost -p 5432 default

psql postgres://twenty:twenty@localhost:5432/default < db_today.sql

dropdb -U twenty -h localhost -p 5432 default
createdb  -U twenty -h localhost -p 5432 default

psql postgres://twenty:twenty@localhost:5432/default < db_today.sql

Nathan•2mo ago

yes charles I want to move the whole thing. I'll try it out later today.

greg [iero]•2mo ago

For the record, my backup script :

#!/bin/bash

export DEST="/home/iero/twenty/backup"
export PGPASSWORD="blablabla"

now=`date +"%Y-%m-%d"`

pg_dump postgres://twenty:${PGPASSWORD}@localhost:5432/default | gzip > ${DEST}/db_${now}.sql.gz

#!/bin/bash

export DEST="/home/iero/twenty/backup"
export PGPASSWORD="blablabla"

now=`date +"%Y-%m-%d"`

pg_dump postgres://twenty:${PGPASSWORD}@localhost:5432/default | gzip > ${DEST}/db_${now}.sql.gz

(And yes after I have other scripts that move the files on other locations)

Nathan•2mo ago

Hey guys so first I was trying to upgrade my twenty to 0.22 abd now I'm getting this error.

Nathan•2mo ago

Nathan•2mo ago

followed the upgrade guide https://twenty.com/developers/section/self-hosting/upgrade-guide but same thing any help @charles @greg [iero]

charles•2mo ago

HI @Nathan, sure we can help! you are migrating from 0.21 right? could you tell us more about these errors? what do you see in your server logs when hitting these + what do you see in your network tab (browser dev tools)

Nathan•2mo ago

@charles yes, I was trying to migrate from 0.21 but downgraded to 0.20 right now it's running from 0.20. Here are the server logs and network logs.

141.148.221.115.har

twenty-server-1_logs...

twenty-db-1_logs.txt

Nathan•2mo ago

Let me know what else you need @charles @charles Need your help here! Any help guys!! My twenty is completly dead I tried to downgrade but nothing works

thomast•2mo ago

Hi, will look into this on Monday! And @charles will be back from PTOs as well

Nathan•2mo ago

Hi @thomast any help today

thomast•2mo ago

cc @charles I think you had more context on this one

Nathan•2mo ago

Thanks @thomast only @charles can save me now

charles•2mo ago

I'm back! It seems that your database is not successfully migrated. Would you have a time window tomorrow so we can look together. Looks tricky to solve on the chat

Gaming

Programming

Data Migration to another host.