i'm new to linux. i started the postgresql 7.4 server
in the root using red hat 9 and it says that
Postmaster already running. but when i used QT
Designer's database connection, in which i wrote
Driver: QPSQL7 database: all user: all, host:
localhost a dialog box appears stating: can not
connect to the database. please ensure that the
database is running and that all the connection
information is correct. [QPSQL: unable to connect
could not connect to server. connection refused. is
the server running on host localhost and accepting
TCP/IP connections on port 5432?

i tried to open the pg_hba.conf and postgresql.conf to
change the tcp/ip from false to true still the problem
persists.


prior to this, when i used $ postmaster -D
/var/lib/pgsql/data, the following message is posted
FATAL: cannot open /var/lib/pgsql/data/PG_VERSION:
Permission denied.

sometime when i type service postgresql start in the
root the following message is posted:
bash: service: command not found


itried to loggin as posgres user and used bash-2.05b$
service postgresql start the same message is posted.
bash: service: command not found


However, i followed the tutorial below and i got it
correct:

Login as user postgres: su - postgres

Initialize PostgreSQL database server:
/usr/bin/pg_ctl -D /var/lib/pgsql/data -p
/usr/bin/postmaster -l logfile start &

Create a database: createdb bedrock
(As Linux user postgres)
Connect to the database: psql bedrock
Execute command as Linux user postgres
You will now be at the PostgreSQL command line prompt.


bedrock=# \c bedrock
You are now connected to database bedrock.
bedrock=# create table employee (Name char(20),Dept
char(20),jobTitle char(20));
CREATE
bedrock=# INSERT INTO employee VALUES ('Fred
Flinstone','Quarry Worker','Rock Digger');
INSERT 18733 1
bedrock=# INSERT INTO employee VALUES ('Wilma
Flinstone','Finance','Analyst');
bedrock=# INSERT into employee values ('Barney
Rubble','Sales','Neighbor');
bedrock=# INSERT INTO employee VALUES ('Betty
Rubble','IT','Neighbor');
bedrock=# SELECT * from employee;



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html