Hi Jayadevan,
I gave the command
 postmaster -D /usr/local/pgsql/data > logfile 2>&1 &
and it started.
Now I could run the command psql.
Also when I ran the query "select version();"
I got the following result.

 PostgreSQL 7.4.13 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)
It seems it shows the version from which I took the database to dump.
Regards,
Rekha

Jayadevan M wrote:
After installing pgsql 9 and dumping an existing database,
I was able to run the psql command and run sql queries as
well.
Today when I gave the psql command I came across this error.
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Can you please help me to run the pgsql.
    
How do you usually start the server? Is it likely the server failed to 
restart and you were getting the errors because the server was not up?
Check status of server
-bash-3.2$ pg_ctl status
pg_ctl: server is running (PID: 11456)
/usr/local/pgsql/bin/postgres

Start the server using 
pg_ctl start

Regards,
Jayadevan





DISCLAIMER: 

"The information in this e-mail and any attachment is intended only for 
the person to whom it is addressed and may contain confidential and/or 
privileged material. If you have received this e-mail in error, kindly 
contact the sender and destroy all copies of the original communication. 
IBS makes no warranty, express or implied, nor guarantees the accuracy, 
adequacy or completeness of the information contained in this email or any 
attachment and is not liable for any errors, defects, omissions, viruses 
or for resultant loss or damage, if any, direct or indirect."





  


Business Disclaimer
____________________________________________________________
This e-mail message and any files transmitted with it are intended solely
for  the use  of the  individual or entity  to which they  are  addressed. It
may  contain confidential,  proprietary or legally  privileged  information.
If  you  are  not  the  intended recipient please be advised that you have
received  this  message in error and any use is strictly prohibited. Please
immediately  delete it  and all copies of it from your system, destroy any
hard  copies  of  it and  notify  the  sender  by return mail. You must not,
directly or indirectly, use,  disclose,  distribute, print, or copy any part of
this message if you are not the intended recipient.
___________________________________________________________