ola,
*warning - quick and dirty hack to get things up and running*
pra habilitar TCP/IP no pgadmin vc tem que muda sua pg_hba.conf que fica no
/etc/postgresql/8.1/main
muda pra 'trust' assim ->
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database
# super user can access the database using some other method.
# Noninteractive
# access to all databases is required during automatic maintenance
# (autovacuum, daily cronjob, replication, and similar tasks).
#
# Database administrative login by UNIX sockets
local all postgres trust
host samegroup all 127.0.0.1 255.255.255.255 trust
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
host all all 0.0.0.0 0.0.0.0 trust
ele vai funfa agorra mas tem que lembrar que nao tem seguranca *nenhum* entao
tem que criar o
usuario como foi escrito antiguamente no outro respostas...depois isso muda
'trust' no IPv4 e IPv6
para 'md5' assim
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database
# super user can access the database using some other method.
# Noninteractive
# access to all databases is required during automatic maintenance
# (autovacuum, daily cronjob, replication, and similar tasks).
#
# Database administrative login by UNIX sockets
local all postgres trust
host samegroup all 127.0.0.1 255.255.255.255 trust
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
host all all 0.0.0.0 0.0.0.0 md5
e pgadmin vai pedir uma senha do usuario criado
boa sorte
[]' s
Ian
--
.''`.
: :' :
`. `'`
`- Orgulhoso ser MetaRecicleiro
http://manaus.metareciclagem.org/
--
ubuntu-br mailing list
[email protected]
www.ubuntu-br.org
https://lists.ubuntu.com/mailman/listinfo/ubuntu-br
