[Linux-bruxelles] problème postgres

Stan Pinte stanpinte at fastmail.fm
Mer 24 Mar 22:32:01 CET 2004


Stan Pinte wrote:

> hello,
>
> j'essaye de me connecter à postgres, via un tunnel ssh...
>
> ssh -p 333 -l userX -L 5000:localhost:5432 monhostpostgres
>
> le tunnel s'ouvre bien...
>
> mais
>
> psql -h localhost -p 5000 -d dbx -U userX
>
> reste bloqué...et n'avance pas!!!!!
>
> quelqu'un aurait-il une idée?
>
> Merci mille fois!
>
> pour info::
>
> tail pg_hba.conf:
>
> # This default configuration allows any local user to connect as any
> # PostgreSQL username, over either UNIX domain sockets or IP:
>
> local        all                                           trust
> host         all         127.0.0.1     255.255.255.255     trust
>
> # If you want to allow non-local connections, you will need to add more
> # "host" records (and don't forget to start the postmaster with "-i"!).
>
> # CAUTION: if you are on a multiple-user machine, the above default
> # configuration is probably too liberal for you --- change it to use
> # something other than "trust" authentication.
>
> host         all         132.147.101.0     255.255.255.0     trust
> host         all         132.148.101.0     255.255.255.0     trust
> host         all         132.150.101.0     255.255.255.0     trust
> host         all         139.165.84.0      255.255.255.0     trust
> host         all         127.0.0.1         255.255.255.0     trust
>
>
> Stan.
>
des précisions: quand je lance mon tunneling en verbose, il me dit:

Opening forwarded connection to localhost:5432
Forwarded connection refused by server




Plus d'informations sur la liste de diffusion Linux-bruxelles