Re: Default timezone changes in 9.1

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Default timezone changes in 9.1
Дата
Msg-id kb3rnu$bad$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Default timezone changes in 9.1  (Terence Ferraro <terencejferraro@gmail.com>)
Ответы Re: Default timezone changes in 9.1
Список pgsql-general
On 2012-12-16, Terence Ferraro <terencejferraro@gmail.com> wrote:

> With the exception of a few parameters (max_connections and the ssl related
> variables that we enable), the default configuration file (circa 9.0) has
> worked extremely well across 100+ machines so far over the last two years
> and counting. However, we are simply deploying these on commodity machines
> ($300-400 off the shelf). Spec wise such machines have not changed
> significantly (I suppose the shift away from higher clock speeds to more
> cores can be thanked for that).

You cam possibly get some of what you want using "SQL" like:

 alter database "DB_NAME" set timezone = 'localtime';

 You can do the similarly with other connection parameters on a
per-user or per-database basis too.

--
⚂⚃ 100% natural

В списке pgsql-general по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Allow a streaming replication standby to follow a timeline switc
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Any experience with Drobo SAN and PG?