Last night, after an initial failed attempt, I moved FreshPorts and FreshSource to the new webserver. Both websites use the same database, so it makes sense to keep them on the same server.
When I first loaded up the FreshPorts database, I saw some errors that concerned me:
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "commit_log_pkey" for table "commit_log"
ERROR: could not create unique index
DETAIL: Table contains duplicated values.
NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "commit_log_elements_pkey" for table "commit_log_elements"
ERROR: could not create unique index
DETAIL: Table contains duplicated values.
What? Duplicated values? I just dumped this database and reloaded it. How could it have duplicate values?
Granted, I was going from PostgreSQL 7.4.7 to PostgreSQL 8.1.1. Not to mention FreeBSD 4.11 to FreeBSD 6.0 (not that an OS version change should make a difference). How strange.
I tried loading the previous night’s backup into PostgreSQL 8.1.2 and it worked. I tried loading again into 8.1.1. Then I realised what the problem was: database updates while the database is being constructed. This time I turned off the script that processes incoming emails and updates the database. This time the database loaded up without error. I changed the IP addresses in the DNS zone files, and restarted the name servers. Traffic started flowing. No errors. I went to bed.
:)
