Corrupted database repair

hi all, we use Gitea under docker and it connects to its own seperate postgresDB running in another container.

We had to physically re-locate our servers at our office earlier, and after shutting down the servers and containers etc… the Gitea one seems to have lost all of its data. Is there a way that this database can be rebuilt? I can see in the volume that is mapped to Gitea that there is still repos etc in there. But when we try to login, it just fails with a “user does not exist” error.

I do have a sql dump from 12 months ago (there has been little change config wise in the last 12 months) but there have been a heap of new repos and code in that time. So im not sure what will happen if i do a restore of that sqldump and there is a mismatch of information so to speak.

somewhat specifically in this section of the sqldump

as thats where some of the repos we have are listed, but there are alot more now than whats there. What is shown is mostly valid still, a couple of them have been removed. but there are many more that we want to get back not in there.

Any suggestions?