Skip to content
This repository has been archived by the owner on Feb 19, 2022. It is now read-only.

restore fails due to schema creation issues #46

Open
moodgorning opened this issue Aug 16, 2021 · 0 comments
Open

restore fails due to schema creation issues #46

moodgorning opened this issue Aug 16, 2021 · 0 comments

Comments

@moodgorning
Copy link

Hello, we are trying to migrate our pg12 TSDB 2.4 DB to a new cluster running on PG13 & TSDB 2.4. I am currently trying to use the ts-dump & ts-restore apps provided from you folks but am running into some issues:
I can pull a dump with ts-dump without problems, but when I try to restore Into a blank DB it fails complaining that the schema it want’s to install TSDB into doesn’t exist.
If I manually create the schema in the new DB before I run ts-restore, it will startup and do the pre-data part, but fail with
pg_restore run failed in pre-data section: cmd.Run() failed with 'exit status 1'
In the output, I can see that pg_restore also tried to create the schema which produced an error since the schema is already created by me. I am not sure if that is the error that causes the whole thing to crash, but it’s the only thing I can see.
To summarise:
If I run against a vanilla DB ts-restore complains about the schema not being there
If I run against a DB that has the schema it creates an error because it tries to recreate it. Any pointers will be highly appreciated
Versino info:
SourceDB: PG12 + TSDB 2.4
Target DB: PG13 + TSDB 2.4 running on a HA kubernetes custer with Patroni, following the provided Timsecale Helm charts

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant