netsmithcentral
asked on
First Database?
Hey all,
I've been developing Access/ASP apps for awhile and finally got around to building a Linux box. I'm planning to use Postgres/PHP apps from here on in but... I can't seem to figure out Postgres. I'm running FC5 with what I think are the appropriate postgres packages installed. There's no Graphical interface I can find. If there isn't a graphical interface, that's fine, but I have no idea what commands I'm supposed to be using. I've tried a using psql from the terminal to no avail (I get "psql: FATAL: role "user" does not exist").
My goal (for now) is to get one database running to where PHP can access it. What am I missing?
I've been developing Access/ASP apps for awhile and finally got around to building a Linux box. I'm planning to use Postgres/PHP apps from here on in but... I can't seem to figure out Postgres. I'm running FC5 with what I think are the appropriate postgres packages installed. There's no Graphical interface I can find. If there isn't a graphical interface, that's fine, but I have no idea what commands I'm supposed to be using. I've tried a using psql from the terminal to no avail (I get "psql: FATAL: role "user" does not exist").
My goal (for now) is to get one database running to where PHP can access it. What am I missing?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
that last line is Oracle syntax... use instead
create user YOURUSERNAME password 'YOURPOSTGRESQLPASSWD';
create user YOURUSERNAME password 'YOURPOSTGRESQLPASSWD';
What is the psql command you executed? It seems like you used "user" as the username and that username does not exist in the database. Try something like:
psql -h host_name -p 5432 -d db_name -U user_name
Make sure you have you edit your pg_hba.conf to accept the proper connections. Make sure the postmaster is running.