Volvo C30 1.6D 2009 Momentum - Remove overhead console

I came up with the idea of replacing stock courtesy lightning bulbs with 501 LED Extreme Power 1.5W in my Volvo C30. The problem was that I thought it would take about 30 minutes and it took much longer than that. Actually it takes about 1.5 hours if you know what you're doing - luckily with this little tutorial you'll know exactly what to do.

Removing the overhead console from the headliner
To remove the overhead console from the headliner just pull the console FIRMLY downward. The Volvo manual DOES not specify how to do this (only says that a trained Volvo technician can do it) and VIDA only says to pull the console downward. I'll attach some pictures to show you how it's done - I didn't want to break my new ride so I hesitated whether to change the courtesy lightning on my own.
If the console has never been removed you NEED to apply some force to remove it. Don't worry about breaking the console - this should not happen.

The transparent plastic cover can be removed by teasing it out with a screwdriver.

After the console has been removed you should see the plastic framework in the roof with ONLY one connector and a few latches. I have marked the connector and one of the latches in the picture.

The console looks like the one in the fourth picture. The problem you'll have with it is that is HAS CUSTOM VOLVO bulb holders. So you need to either buy these from a certified Volvo shop, buy these online on ebay OR do some soldering yourself. I had no time to wait for the bulbs to arrive in a package so I chose the latter option.

Soldering out old bulbs and soldering the new LED lightning in

To remove holder from the console just twist it out. You'll not be able to remove the bulb from the holder easily, however. You need to somehow break the bulb's wires to pull it out.

The rest of the soldering process includes pulling out LED bulbs from their holders and putting them into the old VOLVO's holders, soldering the LED's wires to the old Volvo's metal connectors and putting the holders again into the console.

I leave the decision as whether to buy the holders from ebay or customize them yourself to you.

Import postgresql dump file on windows

Importing dump file from pgAdmin III's "restore" option is not intuitive. It can be done easily from console, however. Just call psql from postgres bin directory located in your installation folder.

c:\Program Files\PostgreSQL\9.1\bin\psql --username=your_username --file=your_dump_file.txt --dbname=your_database