If you were thinking of some ALTER command which will just alter the boundaries of the incorrect partition and make it correct , I don't think there exists any such. You may have to create a whole new table and run the partman.create_parent block with the UTC time zone set so that all the subsequent partitions will be created with correct boundaries and then move the data into it from the existing table.