error: nextval: reached maximum value of sequence "posts_id_seq" (2147483647)

id SERIAL PRIMARY KEY should probably be a bigint. rinds in production has already hit the limit after like ~a year with its current version of using ints