Re: timetz need more bytes than timestamptz

2023-06-18 Thread Junwang Zhao
timetz stores only the time units within a day, it uses an extra field to store the zone info. typedef int64 TimeADT; typedef struct { TimeADT time; /* all time units other than months and years */ int32 zone; /* numeric time zone, in seconds */ } TimeTzADT; timestamp is a count that star

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-18 Thread Thomas Markus
Hi, Am 16.06.23 um 13:53 schrieb Brainmue: possible solutions: * set up a firewall rule to forward connection * use a tcp proxy (nginx can do that) * check pg_bouncer best regards Thomas Hello Thomas, Thank you for your quick reply. With firewall you mean an additional software, right? Bec

timetz need more bytes than timestamptz

2023-06-18 Thread jian he
Hi, https://www.postgresql.org/docs/current/datatype-datetime.html timetz, timestamptz: same resolution. fractional digits in the seconds field are also the same. > > All timezone-aware dates and times are stored internally in UTC. They are converted to local time in the zone specified by the TimeZ