Missing accounts, videos and more after VPS migration

PeerTube
1

Hi, I’m having a bit of trouble moving Peertube from our old VPS to our new one. Same domain name, and DNS is all propogated.

I followed the instructions ( PeerTube platform migration | PeerTube documentation ) and seemed to successfully dump and restore the databases. Peertube UI is visible, logs are printing ActivityPub stuff like “Crawling ActivityPub data… fetching… sync like of video” etc.

But I can’t log in, and there are no videos or channels visible – none of our info. I’m using:

  • Docker, with latest docker-compose.yml and .env
  • Debian Trixie VPS
  • I ran migration script for 8.0 to 8.1.1
  • nginx reverse proxy, using the example config from the repo.
  • object storage: exact working config from old instance

Does anyone have an idea what went wrong? How should I troubleshoot?

sudo -u postgres psql -d peertube -c "SELECT count(*) FROM video;"

This is showing thousands of videos, not sure how many are local. This is off my VPS’s postgres, not sure if that was the right thing to do.

docker compose exec postgres psql -U peertube -d peertube -c "SELECT id,name FROM account ORDER BY "account" DESC LIMIT 5;"

This shows data as well, again not sure how to target local accounts there but federated ones are showing up.

Thanks :slight_smile:

2

OK, I found the problem: the database dump was not properly copied inside the postgres container and not properly restored.

It took dropping the peertube database and recreating it. First I had to connect to the postgres database because it wouldn’t let me drop the currently open one.