Re: pg 10.1 missing libpq in postgresql-devel

On 01/27/2018 06:43 PM, Adrian Klaver wrote: On 01/27/2018 04:34 PM, support-tiger wrote: sorry for delay but ran some tests on older version pg gem - still fails With what error message? What Ruby gem? it fails on building the config file with simply missing libpq-fe.h, cannot find

Re: pg 10.1 missing libpq in postgresql-devel

ver wrote: On 01/25/2018 12:20 PM, support-tiger wrote: running postgresql 10.1 on Fedora 27. Cannot install ruby pg gem due to missing libpq-fe.h file.  This is usually found in postgresql-devel but What was the error message returned when you tried to install originally? it is not in fedora 2

pg 10.1 missing libpq in postgresql-devel

running postgresql 10.1 on Fedora 27.  Cannot install ruby pg gem due to missing libpq-fe.h file.  This is usually found in postgresql-devel but it is not in fedora 27 postgresql10-devel. If install postgresql-devel (9.6) the gem installs without problem but afraid this will interfere with 10.1

Re: problems with postgresql 10.1 hba_conf on fedora 27

On 12/20/2017 06:33 PM, David G. Johnston wrote: On Wednesday, December 20, 2017, rob stone > wrote: > local    all   all       postgres                peer > > host    all    all 127.0.0.1/32  md5 > > host    all    all 

problems with postgresql 10.1 hba_conf on fedora 27

can someone please help ? postgresql-10 fedora 27 our hba_conf that worked with pg 9x local    all   all   postgres    peer host    all    all   127.0.0.1/32 md5 host    all    all   ::1/128  md5 now gives error on restart and we cannot find t

pg data backup from vps

To diversify risk, we would like to have a daily or weekly data backup stored in another location besides the VPS service we are using - pg_dump is great for the backup but transferring a growing db across the internet to a local machine disk seems slow - how are others handling this with postg

Re: update field in jsonb

Oleg, hey, thanks so much - if you are in USA visiting Yellowstone Natl Park contact me and the beer is on me (maybe a Wyoming steak too!) On 11/22/2017 11:27 PM, Oleg Bartunov wrote: On Thu, Nov 23, 2017 at 4:45 AM, support-tiger wrote: is there a way to update a single field in jsonb

update field in jsonb

is there a way to update a single field in jsonb without replacing the entire json document - couldn't find an example for example create table test (id primary key, data jsonb); insert into test ({"name":"bill", "age":29});  ?? update test   set data->age = 30 -- Support Dept Tiger Nassau,