Estriper
Estriper
PostsComments
XXata
Created by Estriper on 7/14/2024 in #help
setting "default_tablespace" is not allowed
Hey, @kostas Thanks for the reply, the dump is creating table, which made me puzzled. I was concerned with this line about_us_id_seq postgres which seems to set wrong owner when creating a sequence But setting --role flag to proper owner fails as it's not supported by Xata
8 replies
XXata
Created by Estriper on 7/14/2024 in #help
setting "default_tablespace" is not allowed
That's the following errors, other are similar: 
pg_restore: creating SEQUENCE "public.about_us_id_seq"

pg_restore: creating SEQUENCE OWNED BY "public.about_us_id_seq"

pg_restore: from TOC entry 3235; 0 0 SEQUENCE OWNED BY about_us_id_seq postgres

pg_restore: error: could not execute query: ERROR:  relation "public.about_us" does not exist

Command was: ALTER SEQUENCE public.about_us_id_seq OWNED BY public.about_us.id;
pg_restore: creating SEQUENCE "public.about_us_id_seq"

pg_restore: creating SEQUENCE OWNED BY "public.about_us_id_seq"

pg_restore: from TOC entry 3235; 0 0 SEQUENCE OWNED BY about_us_id_seq postgres

pg_restore: error: could not execute query: ERROR:  relation "public.about_us" does not exist

Command was: ALTER SEQUENCE public.about_us_id_seq OWNED BY public.about_us.id;
8 replies