| From: | Rekha Ravi Pai <rekha(at)softjin(dot)com> |
|---|---|
| To: | Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com> |
| Cc: | pgsql-in-general(at)postgresql(dot)org, pgsql-in-general-owner(at)postgresql(dot)org |
| Subject: | Re: [Fwd: Re: Problem in connecting to database] |
| Date: | 2010-11-09 06:32:02 |
| Message-ID: | 4CD8EAE2.2050807@softjin.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-in-general |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=US-ASCII" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Jayadevan,<br>
I gave the command <br>
<font color="#cc0000">postmaster -D /usr/local/pgsql/data > logfile
2>&1 &<br>
<font color="#000000">and it started.<br>
Now I could run the command psql.<br>
Also when I ran the query "select version();"<br>
I got the following result.<br>
<br>
<font color="#cc0000">PostgreSQL 7.4.13 on i686-redhat-linux-gnu,
compiled by GCC gcc (GCC) 3.4.5 20051201 (Red Hat 3.4.5-2)</font><br>
It seems it shows the version from which I took the database to dump.<br>
Regards,<br>
Rekha<br>
<br>
</font></font>Jayadevan M wrote:
<blockquote
cite="mid:OF9BABADFD(dot)2E546812-ON652577D6(dot)0022DEAB-652577D6(dot)002343F8(at)ibsplc(dot)com"
type="cite">
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap=""><!---->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."
</pre>
</blockquote>
<br>
<pre>
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.
___________________________________________________________
</pre></body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 3.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jayadevan M | 2010-11-09 06:34:56 | Re: [Fwd: Re: Problem in connecting to database] |
| Previous Message | Jayadevan M | 2010-11-09 06:25:11 | Re: [Fwd: Re: Problem in connecting to database] |