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