Re: psql \copy

2020-04-24 Thread Steve Clark
On 04/24/2020 12:15 PM, Adrian Klaver wrote: On 4/24/20 9:12 AM, Steve Clark wrote: On 04/24/2020 11:59 AM, Steve Crawford wrote: On Fri, Apr 24, 2020 at 8:55 AM Steve Clark mailto:steve.cl...@netwolves.com> <mailto:steve.cl...@netwolves.com><mailto:steve.cl...@netwolves

Re: psql \copy

2020-04-24 Thread Steve Clark
On 04/24/2020 11:59 AM, Steve Crawford wrote: On Fri, Apr 24, 2020 at 8:55 AM Steve Clark mailto:steve.cl...@netwolves.com>> 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 d

psql \copy

2020-04-24 Thread Steve Clark
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 is does psql abort the copy if it hits a duplicate key, or does

postgres operational

2019-01-09 Thread Steve Clark
Hi List, Is there a sure fire way to tell if postgres server is up an operational. I was testing to see if the socket at /tmp/.s.PGSQL.5432 existed - but I ran into a recent problem on CentOS 7.5, postgresql 9.2.24, where the socket was there but my script couldn't read from my database yet.

Re: no libpq.pc for Centos 6 or Centos 7

2018-10-24 Thread Steve Clark
On 10/24/2018 09:38 AM, Adrian Klaver wrote: > On 10/24/18 6:28 AM, Steve Clark wrote: >> Hello List, >> >> I can't seem to find a pkgconfig file for postgresql on centos 6 or centos >> 7. >> >> Centos packages installed >> $ rpm -qa|grep postgres

no libpq.pc for Centos 6 or Centos 7

2018-10-24 Thread Steve Clark
Hello List, I can't seem to find a pkgconfig file for postgresql on centos 6 or centos 7. Centos packages installed $ rpm -qa|grep postgresql postgresql-server-9.2.24-1.el7_5.x86_64 postgresql-9.2.24-1.el7_5.x86_64 postgresql-devel-9.2.24-1.el7_5.x86_64 postgresql-libs-9.2.24-1.el7_5.x86_64