Questions tagged as 'pgadmin3'

2
answers

PostgreSQL COUNT function does not work

The problem is simple but I can not understand where I am wrong, I need to check the amount of results of the following sql: SELECT f.id,sum(p.valor) as valor_fatura, f.valor_desconto as desconto, (f.numero || '/' || f.ano_fatura ) as numer...
asked by 16.06.2017 / 21:36
0
answers

How to connect to a postgresql database that is in another network?

I have a postgresql database installed on a Raspberry Pi on another network. I made the settings inside pg_hba.conf: host all all 0.0.0.0/0 md5 In postgresql.conf I edited to stay like this listen_adresses ='*' port=80 I downloaded pga...
asked by 16.10.2018 / 14:27
0
answers

Create database

I'm trying to create a database in postgres but I'm getting the following message:    ERROR: can not set transaction read-write mode during recovery I've uninstalled, cleaned the registry, installed a new password, but it always rescues u...
asked by 17.08.2018 / 18:05