Recreate tables in chaind

  1. Ensure that you run psql as chain user, e.g.
psql -U chain -h localhost

If not you will have to change the owner of the table like so:

ALTER TABLE t_validator_balances_2025_12_11 OWNER to chain;
  1. You need to establish the start and end epoch for each table. This can be found using:
ethdo chain time --timestamp="2025-12-11T00:00:00-0000"

This will return the epoch number for the FROM parameter for the 11th of December 2025. The TO parameter will be the epoch number for the 12th of December 2025, i.e. the end of one day is the start of the next as they are not inclusive.

  1. Recreate the tables using the epoch numbers from the previous step.
CREATE TABLE IF NOT EXISTS t_validator_epoch_summaries_2025_12_11
PARTITION OF t_validator_epoch_summaries
FOR VALUES FROM (412987) TO (413212);


CREATE TABLE IF NOT EXISTS t_validator_balances_2025_12_07
PARTITION OF t_validator_balances
FOR VALUES FROM (412087) TO (412312);