Postgresql cannot restore partial pg_dump "relation "public.my_table_seq" does not exist"
I had also a similar case and I solved it via doing theese steps:


First of all I made an initial psql_dump with the tables I wanted to dump:


 pg_dump -t my_table1 -t mytable2 &gt; my_dump.sql



Then I listed any sequence existing by filtering them, from the existing dump I made. In case of larger dumps use tools offered in bash or in powershell in order to filter them out. In other words you need to search any lines having DEFAULT nextval( and keep only the sequence name.
Once found the all the sequences do an another pg_dump as the one follows:


     pg_dump -O -x -t my_table_seq -t another_table_seq -t my_table1 -t mytable2 &gt; my_dump.sql


In the command above the my_table_seq and the another_table_seq are sequences used. Also with the -x and -O parameters I ewxclude dumping any permission/role related sql so in the new database will contain only the tables and their respective data.