FATAL: invalid value for parameter “TimeZone”: “America/Los_Angeles” with DBeaver

I got that message when trying to use DBeaver to connect to a PostgreSQL DB.

FATAL: invalid value for parameter "TimeZone": "America/Los_Angeles"

I found the fix here. The first thing to check is the timezone you have set on the Postgres db itself. You can do this by running “SELECT * FROM pg_timezone_names;”.

Here’s an example:

avenger_agent_prod=# SELECT * FROM pg_timezone_names;
name | abbrev | utc_offset | is_dst
UTC | UTC | 00:00:00 | f
(1 row)

The fix is to make a small change the dbeaver.ini file in DBeaver root directory. If you installed this on a Mac, the file is in /Applications/DBeaver.app/Contents/Eclipse/

Just add:

# START: change jre version, not using the one in %JAVA_HOME%
# JVM settings
# time zone
# language

When you restart DBeaver, it should connect.

Adventures in the quest to install Lion on my MacBook Pro …

This was pretty fun. I had to install a new HD in my Mac. Since Lion was out and I was still on Snow Leopard, I figured I might as well upgrade that too. I downloaded and burned it on a dvd. I figured, After swapping out the hard drive, I could install from DVD. Unfortunately, the DVD didn’t read. Damn! It was a pain to swap the disks and I didn’t want to do it again. So I tried booting from USB – attached the old disk to a usb enclosure and it booted! Linux couldn’t do that! Windows couldn’t do that! This was awesome. From there, I was able to just install Lion via the downloaded dmg file and pointed the install to the newly installed disk.

By the way, trying to burn a dmg file on Linux or Windows is a pain in the ass. I tried with both and gave up after about an hour of google searches and trying different converter products.