Jorge Campins wrote:
How can I find which version I'm using? All I could see in pgAdmin is 8.1.
SELECT version();
Which value should I use for timezone in postgresql.conf? I tried select * from pg_timezone_names to get a list of valid time zone names but it failed with "relation pg_timezone_names does not exist."
pg_timezone_names was added in 8.2. (which you really should upgrade to anyway, since 8.1 isn't supported on Windows anymore)
To find it in 8.1, check the files in share/timezone in your PostgreSQL installation.
//Magnus ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend