Pessoal...
Eu naw estou conseguindo logar no phppgadmin... como eu crio um usuario com permissao total sobre o postgresql (podendo inclusive acessa-lo de qualquer lugar)?
Existe uma maneira certa de iniciar o postgresql (q nem o mysql... mysql_secure_installation) antes de eu começar a usá-lo?
#/etc/postgresql/pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
# Database administrative login by UNIX sockets
local all postgres ident sameuser
#
# All other connections by UNIX sockets
local all all ident sameuser
#
# All IPv4 connections from localhost
host all all 127.0.0.1 255.255.255.255 ident sameuser
#
# All IPv6 localhost connections
host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff ident sameuser
host all all ::ffff:127.0.0.1/128 ident sameuser
#
# reject all other connection attempts
host all all 0.0.0.0 0.0.0.0 reject
host all all 200.131.219.7 255.255.255.255 ident sameuser