If the rest of your queries are working properly, you might want to log into postgresql to see if the sequence "sec_id_seq" exists.
db_name# d sec_id_seq
The correct response should be:
Sequence "sec_id_seq"
Attribute | Type
---------------+---------
sequence_name | name
last_value | integer
increment_by | integer
max_value | integer
min_value | integer
cache_value | integer
log_cnt | integer
is_cycled | "char"
is_called | "char"
If you don't see that, then the sequence doesn't exist; that would explain your error message. The next step would be to grep your dumpfile for the proper creation command:
CREATE SEQUENCE "sec_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
If the sequence didn't get properly restored, you can manually create it using the command above, replacing the "minvalue" with some value higher than your current highest index value.
