I'm using pg_dump to dump my database version 12.5 (RDS), pg_dump version 12.6 but I have a the following table
CREATE TABLE public.projects_historydata ( id bigint NOT NULL DEFAULT nextval('projects_historydata_id_seq'::regclass), [...] this table make references to the sequence projects_historydata_id_seq -- SEQUENCE: public.projects_project_id_seq
At the moment to do a pg_dump the pg_dump doesn't make the script for the sequence, then the restore fail to create the table.
Please see that the id value for the table (the value handle by the sequences is not an integer is biginteger)
I'm confused regarding the complaint. I see that the sequence used by the history table is different from the single sequence shown in the email. Is the script in the email the entire dump script? What dump command did you use?
The sequence you show is a bigint sequence since that is the default and there is nothing overriding it. Though since you seem to be showing mis-matched information that observation is only a general one.
