all: Move pkg/migrate into pkg/postgres

Since `pkg/migrate` depends on postgres, there's no reason for it to be in a separate package.