Questions tagged as 'postgresql'

Tagged questions
0
answers

How do you start pgpool and check its status?

I'm creating a postgres database cluster and I'm using pgpool. I have three machines and I followed the tutorial described in this page: PostgreSQL Replication and Load Balancing with pgpool-II The slave and master are configured correct...
asked by 13.04.2018 / 16:23
0
answers

Return a query taking data from three tables

I need the result of three tables in a query to generate a google charts chart. table 1: // This will be column One SELECT SUBSTRING(dt_vencimento,1,7) as anomes, SUM(vl_valor) as valor_total FROM escola.tb_despesas_administrativas where Y...
asked by 04.04.2018 / 03:35
0
answers

Cursor with PostgreSQL

I have here a process table that activates a trigger when a new process is written. In my case, when someone generates a process for a request that was returned the system must "return" the quantity of items that were requested in that request...
asked by 02.04.2018 / 22:55
1
answer

Connection Pool opens connections but does not close later!

I'm experiencing some problems with my postgresql connection pool with java, where it's called by my DAO methods quietly, but it does not close after the method is executed, and it gets in the way when I do some research and the bank is full of...
asked by 28.03.2018 / 19:51
0
answers

Postgresql - active (exited)

I followed all the tips, the configuration files seem to be in order. I do not know what else to do; but when I try to start postgresql (version 10.3 on kali linux 14.4, debian (32bits) in VirtualBox I get this message, even doing manual startup...
asked by 25.03.2018 / 20:31
1
answer

Error running PostgreSQL admin:

I downloaded Postgre 9.6 and installed everything "default".
asked by 15.03.2018 / 11:20
0
answers

SQL script to fit decimal point of a column - PostgreSQL

I have a table in PostgreSQL that has the field IdProduto and Quantidade . The Quantidade column values were written to the wrong decimal places. Ex: 9000,000 was written when it should be 9,000 . The lack of...
asked by 15.03.2018 / 14:41
0
answers

Error Postgresql schema + Spring Jpa + @Query QuerySyntaxException: #### is not mapped

I have the following problem. My entity: @Entity @Table(schema = "esquema",name="tabela") public class Exemplo{ @Id private Integer exemploid; @ManyToOne @JoinColumn(name = "attid") private Atributo att; ... } My...
asked by 15.03.2018 / 14:25
0
answers

Error: "No Persistence provider for EntityManager"

I have a project in Eclipse with an application that persists in the Postgresql 9.6 database through Hibernate, but Java is not recognizing the persistence-unit name that is set in persistence.xml , even this name by checking with the name pa...
asked by 17.03.2018 / 09:59
0
answers

PostgreSQL handling of DATE

I need to import a .txt file into an sql table (The problem is not that, since I already do this import frequently) where in the .txt file the column that refers to DATAS has some fields with values " Note: I tried with String (characte...
asked by 16.03.2018 / 20:23