duplicate key value violates unique constraint "service_order_order_number_key" DETAIL: Key (order_number)=(UT000013) already exists. code example

Example: ERROR: duplicate key value violates unique constraint statuslogs_pkey DETAIL: Key (id)=(1621) already exists.

How to reset postgres' primary key sequence when it falls out of sync?