February 20th, 2001, 04:28 PM
I can log in to psql, having granted myself superuser privileges, but pgaccess doesn't recognize me as a valid user. I'm confused about this. With mysql, I gave a username, and password, which I could use for things like perl DBI,and PHP scripts, but Postgresql didn't prompt me for a password. Instead it just used my login in linux to let me in. This is fine until I need to actually tie postgresql into a web page.
The hostname of my computer is frogman, and postgres seems to be looking for localhost, but if I put in frogman with pgaccess, it gives me an error asking if the postmaster is running (with -i) at 'localhost' and accepting connections on TCP/IP port '5432'? Any help with this is appreciated. Thank you.
February 28th, 2001, 07:19 PM
re: '-i' message:
this is the generic message indicating that Postgres is listening only for connections to localhost. If you need it to listen for connections using any other machine name you have to start the Postmaster with something like:
postmaster -i mydomain.notyours.com -D /path/to/the/data
Note the capital D and lowercase i...
With regard to passwords you should look for the file named pg_hba.conf in the data folder; Postgres does things a bit different and it can be somewhat confusing. It's worth the effort, though.
Finally - there are some really good documents on the Postgres homesite, I think you can find most of your answers there to questions like these. And, there is at least one book available on Postgres that are pretty well written.
Could you pass along the name of that PostgreSQL book?
PostgreSQL Bookk title
The book I bought is:
'PostgreSQL - Introductions and concepts' by Bruce Momjian