To reset ActiveRecords id sequence after restoring DB from a dump

id_seq_reset.rb

# TABLE_NAME = the name of the table you need to reset the id sequence for

ActiveRecord::Base.connection.execute(%q{
    select setval('TABLE_NAME_id_seq', m)
    from (
        select max(id) from TABLE_NAME
    ) as dt(m)
})

# OR

ActiveRecord::Base.connection.tables.each do |t|
  ActiveRecord::Base.connection.reset_pk_sequence!(t)
end