Re: how to connect to a remote dbase using psql odbc

Give us some more info:

What version of PostgreSQL are you connecting to?
>From what application/environment are you attempting to connect from?
How did you start PostgreSQL? (Did you use -i ?)
Can you connect locally to PostgreSQL using "psql -Uuser_name database_name" ?
Why did you wait until _1_week_ before your thesis defense to get this working?
:)

My guess is that either you didn't use "-i" or your pg_hba.conf isn't set up
properly. That's actually more important to remote connection than
pg_ident.conf.

for instance:
<snip>
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 10.10.0.1 255.255.255.255 password
host all all 10.10.0.2 255.255.255.255 password
</snip>

All local users don't need a password
All users from 10.10.0.1 and 10.10.0.2 need a password

If you want everyone to connect w/o password, set up their ip address and use
method "trust". If you're using method "ident" that's where pg_ident.conf comes
in. This is all very well documented. There are interactive docs on
www.postgresql.org.

I expect a citation in your revised thesis for the pgsql-odbc list, and for
every person who responds to your help request. :)

CG

--- raymond(dot)chuasing(at)kasal(dot)com wrote:
> how do I connect to a remote dbase using odbc? I've tried changing my dsn
> on the other comp but it won't work ... the error about the user being not
> there always shows up.. I changed the pg_ident but still it won't work...
>
> can anyone help me out I need to solve this asap my thesis defense is next
> week thx...
>
> Raymond
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/