The other surprise today.
We've moved a few sites to new servers and as always, there are bound to be a few issues here and there. So it wasn't that unusual to get a ticket from a customer complaining about some missing content on their site. From the look of the page, it's the type of content that's dynamically generated, so it's either a database issue (“but we copied all the databases over!”), some configuration problem like different file locations (“but the layout is exactly the same on the new server”) or something easy like that.
The customer in question doesn't have a MySQL [1] database, so I was expecting some file locations to have changed. So imagine my surprise when I found the following:
>
```
$MM_mdtap_HOSTNAME = 'localhost';
$MM_mdtap_DATABASE = 'postgres7:XXXXXXXXXXX_db';
$MM_mdtap_DBTYPE = preg_replace('/:.*$/', '', $MM_mdtap_DATABASE);
$MM_mdtap_DATABASE = preg_replace('/^[^:]*?:/', '', $MM_mdtap_DATABASE);
$MM_mdtap_USERNAME = 'XXXXXXXX';
$MM_mdtap_PASSWORD = 'XXXXXXXX';
```
PostgreSQL [2]?
We have customers using PostgreSQL?
We're have PostgreSQL running?
I guess so.
Well, that explains that problem then.
It then took me a few hours to get the database over and running, not having any experience with PostgreSQL.
It was a very hectic day today.