Thread: Can't connect to the db

Can't connect to the db

From
Judith
Date:
Hello every one I was using my db with an application in perl, but 
something occurs with the application and the pc got frozen  and I had 
to restart my PC, when it boot again I coudn't restart the psql service 
when I do the psql mydb it shows me the next error, the error is in 
spanish but it says something like:
   psql: can't connect to the server: there is no file or directory
   is the server running local and accepting conecctions in the Unix 
domain socket «/tmp/.s.PGSQL.5432»

do I have to reinstall again the postgres or can I do something else?



Re: Can't connect to the db

From
Andrew Sullivan
Date:
Looks like your database didn't start up.  You should look at your
server logs to see why.

A

On Fri, Feb 24, 2006 at 04:17:14PM -0600, Judith wrote:
> Hello every one I was using my db with an application in perl, but
> something occurs with the application and the pc got frozen  and I had
> to restart my PC, when it boot again I coudn't restart the psql service
> when I do the psql mydb it shows me the next error, the error is in
> spanish but it says something like:
>
>    psql: can't connect to the server: there is no file or directory
>
>    is the server running local and accepting conecctions in the Unix
> domain socket «/tmp/.s.PGSQL.5432»
>
> do I have to reinstall again the postgres or can I do something else?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match

--
Andrew Sullivan  | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.    --Alexander Hamilton