Re: Can't connect to socket in Debian distribution

Thank you, Tom, for your suggestions. I think it moved me in the right direction, but I'm still not there yet.

You are right about the '-p' option. It gets so confusing to me switching back and forth from MySQL to PostgreSQL. In
MySQL,'-p' is how you prompt for the password. In PostgreSQL, it's '-W'. However, now, running as root, I just get: 
www2:/home/kevinz# psql -W mnogosearch mnogosearch
Password:
psql: FATAL 1:  IDENT authentication failed for user "mnogosearch"

www2:/home/kevinz# psql -W -U mnogosearch mnogosearch
Password:
psql: FATAL 1:  IDENT authentication failed for user "mnogosearch"

Just before I tried this, I used the ALTER USER command to set the password for mnogosearch to something I was sure of,
soI'm pretty confident in that. 

When I 'su mnogosearch' I can then 'psql mnogosearch' , never get asked for a password, and get into psql immediately
andwithout a problem. 

One thing I don't understand is the difference between:
psql -W <dbname> <username>
and:
psql -W -U <username> <dbname>
My reference book leads me to believe that there's no difference. Is there?

Thanks, again, Tom.

-Kevin

>>> Tom Lane <tgl@sss.pgh.pa.us> 11/27/02 01:52PM >>>
"KEVIN ZEMBOWER" <KZEMBOWER@jhuccp.org> writes:
> When I try to run psql as root, I get this error:
> www2:/etc/postgresql# psql -p mnogosearch mnogosearch
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.0"?

"-p" is probably not what you want here.  It looks like the code is
failing to notice that the argument of -p doesn't look like an integer...

            regards, tom lane