...
> Yeah, I'm definitely interested in keeping as much of the DST stuff
> outside my code as possible. I guess my concern is that I think there are
> other places where this database is being used in my codebase that may rely
> on the database time setting being UTC (or really, GMT, though I don
On Tue, Oct 3, 2023 at 7:33 PM Lincoln Swaine-Moore
wrote:
> Hi all,
>
> I'm attempting to generate some reports using user-driven timezones for
> UTC data, and I'm having trouble writing a query that meets the following
> criteria:
>
> 1) Data should be averaged at one of daily, hourly, or 15 mi
My 2-cents.
"Time stamp with time zone" is a terrible name for the data type. "Point in
time" would be better but we are stuck with historical baggage in that
regard. The following are equivalent points in time (AKA timesamptz):
2021-09-21 12:34:56-07
Tue 21 Sep 2021 12:34:56 PM PDT
2021-09-21 12:
>From a security audit point of view, also consider the fact that 9.6 is
end-of-life in 3 months.
-Steve
On Fri, Aug 6, 2021 at 9:46 AM Tom Lane wrote:
> Ehtesham Pradhan writes:
> > Our client is using Version : PostgreSQL 9.6.17 , they have done
> vulnerability
> > assessment and found that
On Fri, Apr 24, 2020 at 8:55 AM Steve Clark
wrote:
> Hello,
>
> I am using psql to copy data extracted from an InfluxDB in csv format into
> postgresql.
> I have a key field on the time field which I have defined as a bigint
> since the time I get
> from InfluxDB is an epoch time.
>
> My question
On Wed, Apr 15, 2020 at 11:06 AM Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> What is the exact format of the timestamp in the CSV? As long as it is in
> a "fully qualified" format, i.e. includes the time-zone offset, then you
> will have no problem as the d
What is the exact format of the timestamp in the CSV? As long as it is in a
"fully qualified" format, i.e. includes the time-zone offset, then you will
have no problem as the data represents a point in time.
It is easier to conceptualize "time stamp with time zone" (timestamptz) as
actually repres
On Thu, Nov 21, 2019 at 8:48 AM Jason L. Amerson
wrote:
> 1) I am not sure if Postgres server is listening on port 5432. How do I
> check?
>
> 2) I have tried "psql -h xx.xx.xx.xx" and "psql -h xx.xx.xx.xx -U
> postgres."
> I even tried to telnet to it using the static IP and port 5432 but it wou
FWIW, the second process (110181) is a child of the main process (33438). I
can't recall if any maintenance process that gets automatically activated
(autovacuum, checkpoint, stats, etc.) shows with the same name as the main
process.
Cheers,
Steve
On Tue, Aug 20, 2019 at 1:32 PM chiru r wrote:
(sorry for the top-post - blame GMail)
-Steve
>
On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj wrote:
> Hi All,
>
> We have recently noticed in our development environment pg_log with
> flooded message.
>
> [64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:
> pg_getnameinfo_all() failed: Temporary failure in name resolution...
>
First th
On Wed, Feb 27, 2019 at 12:59 PM Julie Nishimura
wrote:
> Hello Steve,
> Thanks a lot for your info yesterday, it was very useful. If I run this
> command on some of the servers and the results look like this, what would
> it tell you?
>
> select * from pg_extension ;
>extname| extowner
Ouch. I'm sure others will have ideas to add but here are a few to start
with. I would start by cataloging the instances. I hope you at least have a
list of the servers - if not you may need to do network scans with nmap and
even then may not locate all of them.
On each instance I'd use some combi
On Fri, Nov 30, 2018 at 8:05 AM Chris Mair wrote:
>
> > We're kind of pulling out our hair here, any ideas?
>
> You might try issuing the command
>
>analyze;
>
> right *before* the command that hangs.
>
>
You might consider trying the "auto_explain" module (
https://www.postgresql.org/docs/cu
On Tue, Nov 6, 2018 at 2:54 PM David Gauthier
wrote:
> Hi:
>
> I'm trying/failing to write a recursive plpgsql function where the
> function tries to operate on a hierary of records in a reflexive table.
> parent-child-grandchild type of recursion.
>
> I tried with a cursor, but got a "cursor alr
On Fri, Oct 19, 2018 at 7:34 AM Adrian Klaver
wrote:
> On 10/18/18 3:36 PM, Steve Crawford wrote:
> > No, the *link* exists. The package doesn't (404 errors on, for example,
> > Centos 7 x86_64 and several others).
>
> According to this:
>
>
> ht
No, the *link* exists. The package doesn't (404 errors on, for example,
Centos 7 x86_64 and several others).
Cheers,
Steve
On Thu, Oct 18, 2018 at 3:22 PM Adrian Klaver
wrote:
> On 10/18/18 3:02 PM, Steve Crawford wrote:
> > While looking to install version 11 I discovered tha
While looking to install version 11 I discovered that the PGDG Yum
repository page at https://www.postgresql.org/download/linux/redhat/ includes
repository RPMs for RHEL7 (x86_64 and ppc64Ie), and RHEL6 (x86_64 and
i386).
However there are no RPMs for version 6 of any derivatives (CentOS,
Scienti
It is an unfortunate historical naming.
In these conversations I tell people to just always mentally translate
"timestamp with time zone" to "point in time". How it is stored internally
is entirely irrelevant except to the PostgreSQL developers and can
otherwise be ignored. All that matters is tha
On Thu, May 31, 2018 at 7:35 AM Jamie Specter
wrote:
> ...
> I would love to use it in an Apache-licensed project but unfortunately,
> LGPL licenses are not compatible with Apache 2.0.
>
> ...
> Is there any chance the project can be dual-licensed with a permissive
> option like MIT or BSD? ...
>
On Mon, May 21, 2018 at 2:40 PM Bartosz Dmytrak wrote:
> Hi Gurus,
>
> Looking into my postgresql.log on one of my test servers I found scary
> entry:
>
>
>
> --2018-05-19 05:28:21-- http://207.148.79.161/post0514/post
>
> Connecting to 207.148.79.161:80... connected.
>
> HTTP request sent, awai
Interesting. I was unaware that Resolve used PostgreSQL. I looked at
Resolve a year or two ago but the Linux version was still pricey while the
basic Mac/Windows versions could be downloaded for free. Looks like there
may be a free version for Linux, now. I'll have to check it out.
In any case, yo
22 matches
Mail list logo
