Questions tagged [postgresql-9.5]

Specifically for PostgreSQL version 9.5

Filter by
Sorted by
Tagged with
0
votes
1answer
2k views

What is the pgAgent service account?

Im installing pgAgent using Stack Builder. In one step ask me for service account. Should I use PC, Domain or DB user? Or create a new one? I try using my DOMAIN\my.user.name also using the ...
-1
votes
1answer
2k views

Unpivot a table in PostgreSQL [duplicate]

I need to unpivot a table in PostgreSQL. The first dataset is what I have, the second is what I want: Below is my schema with sample dataset: http://www.sqlfiddle.com/#!17/3f45c/1 My understanding ...
-1
votes
1answer
80 views

HOW to find a specific record from column [closed]

If my column has record like this: "0,11.2,2,5,1-2,1,SAMPLE CLOT,',11.2 g/dl,14300,145,negative" and column data type is text. How can I find a record <7 (less than seven) from that column. ...
-1
votes
1answer
31 views

PostgresSQL PITR

I have a master\server setup with pgpool and postgres 9.5. Both servers are running on centOS7. I wanted to setup a point in time recovery with base backups every saturday, eliminating the old xlogs....
-2
votes
2answers
39 views

Plperlu func with column as param [closed]

I have postgres 9.5, and want to use plperlu as lang to get result from curl put My func is: create or replace function langDetect(str text) returns text as $$ use warnings; use strict; my $str = $_[...
-2
votes
1answer
28 views

postgres query to insert data in a table from other table using combination of two common entries of thecolumns in both tables [closed]

I have 2 tables t1 & t2 both containing 3 columns a,b,c the entries in column 'a' and 'b' are same but ordered differently in t1 & t2. I want to use combination of 'a'&'b' entries of t1, ...
-2
votes
1answer
1k views

Need to Delete old row from my table on conflict of the particular column

Spec: Postgresql 9.5 Python3.5 psycopg2 I have table(dummy) column1, column2, column3, column4 & column5. if i have on conflict with column2 which contains phone number i need to ...
-2
votes
2answers
194 views

pg_ctl still pointing to 9.5.4 after upgrade to postgres 10 [closed]

I have updated postgres from 9.5.4 to the latest 10.4 on Ubuntu 14. But after installing postgres 10 I am seeing support@platform1:/usr/bin$ ls -lah pg_ctl lrwxrwxrwx 1 root root 34 Jun 13 08:59 ...
-3
votes
1answer
225 views

Postgres is Throwing a False Foreign Key Constraint Violation? [closed]

I am trying to delete a LocalTax record from Postgres. Currently, I don't think there are any Employee records that reference the LocalTax in question (8). => SELECT COUNT(*) FROM employees WHERE ...
-4
votes
1answer
172 views

Writing a function to insert the rows in a table from some other table [closed]

I have a requirement to write a Postgres function to insert rows into one table from the other tables. But the problem is that only few columns needs to be set from the rows of the other table rest I ...