| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Venkata B Nagothi <nag1010(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can postgresql ignore DST ? |
| Date: | 2017-12-14 08:28:10 |
| Message-ID: | 1513240090.2442.25.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Venkata B Nagothi wrote:
> On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Venkata B Nagothi <nag1010(at)gmail(dot)com> writes:
> > > To rule out any application issues, is it possible to get postgresql to
> > > ignore DST and render all the timestamps with timezone offsets of +11 ?
> >
> > set timezone = 11
>
> We have Timezone configured to Australia/Sydney, we can change that to 11 and do we need to foresee any issues ?
That configuration parameter defines how the client will format
timestamps to strings and vice versa.
It should not have any other effects.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-12-14 10:38:37 | Re: Logical replication blocking alter/drop |
| Previous Message | Venkata B Nagothi | 2017-12-14 05:23:58 | Re: Can postgresql ignore DST ? |