Questions tagged as 'postgresql'

Tagged questions
0
answers

Why this error in PostgreSQL if I am not using SSL?

Why am I getting this error:    SSL SYSCALL error: EOF detected The connection is via the local network via Delphi Application - > PosgtreSQL I use the ZEOS component for the connection     
asked by 03.05.2018 / 18:53
1
answer

How to create this view in postgres?

CREATE VIEW grafico AS SELECT AVG(realizacao) , AVG(estima), AVG(fisiologica),AVG(seguranca),AVG(social) FROM necessidade; I'm trying to create a view that brings the average of five columns of the required table, but I can not create this vie...
asked by 26.03.2018 / 20:29
0
answers

Multiple JDBC connections are thread-safe?

I am creating a very simple project in java and postgresql of clients and contacts between clients. There is the clientes table with id and name, and the contatos table with id1 and id2 that refer to clients. What happens if...
asked by 29.03.2018 / 02:56
1
answer

How to get the percentage of Postgre database storage space through EF Core in Asp.net Core

I need to create in my application a feature that checks the database ( PostGreSQL ) for the percentage of storage space used to be displayed on a chart. I have a generic repository, and I thought about creating a GetStorage() fu...
asked by 19.03.2018 / 00:07
0
answers

Too much query delay in MySql only

Here in the company we have PG and MySql databases, these two banks are networked and identical in structure and data, where a "robot" performs this mirroring between them every 10 minutes. So far so good ... It turns out now that the bases ar...
asked by 15.03.2018 / 18:38
1
answer

How to do a certain database replication in postgres for a given port?

Well I have the following scenario, I need to do a replication from bank A to bank B. Well I've been doing this from one machine to another with the following changes: Master Machine - 10.0.0.1 sudo vim /etc/postgresql/9.4/main/postgresql...
asked by 23.04.2018 / 15:11
0
answers

Saving user activity in the database (sql)

I'm creating a chart to analyze the age-appropriate posts access by time on my site. But the site does not yet have this ability to capture user activity and need to do it. My task and change the database so that it is possible, I currently h...
asked by 22.03.2018 / 18:27
1
answer

Date field display

I have a date in the American yyyy-mm-dd format and I would like to put it in the Brazilian dd-mm-yyyy format however I do not want to do as to_char conversion. I need it to continue with the date format because I will need to make filters with...
asked by 16.01.2018 / 20:16
1
answer

Select data even if it does not appear on all tables

I have the following Query : SELECT public.suprimento.suprimento, public.estoque.numeroserie, public.fornecedor.nome as fornecedor, public.estoque.data as dataentrada, public.estoque.numeronotafiscal, public....
asked by 26.02.2018 / 17:51
1
answer

How to delete records automatically with postgreSQL?

Recently get a project that is about a blog, the user will hold the posts of various news, however I am using the server Heroku with the free account that entitles there are only 512 Megas of space, above that limit it starts charging. At t...
asked by 27.02.2018 / 13:59