On Sat, 2009-08-01 at 19:49 +0530, Vamsee Kanakala wrote: > Vamsee Kanakala wrote: > > sudharsan s wrote: > >> sudha...@debian:~$ sudo su postgres -c psql template1 > >> psql: could not connect to server: No such file or directory > >> Is the server running locally and accepting > >> connections on Unix domain socket > >> "/var/run/postgresql/.s.PGSQL.5432"? > >> > >> So how to solve it... > >> > > > > Check if the db server is running in the first place - try: > > > > sudo /etc/init.d/postgresql restart > > > > Replace 'restart' with 'start' if it's down and try again. > > Sorry, replied too soon. Try changing to the postgres user first: > > sudo su postgres > > And then try: > > psql template1 > > One of those steps should show you the problem. > > Vamsee.
check for the following listen_address in postgresql.conf and for local connections in pg_hba.conf Thanks baskar _______________________________________________ To unsubscribe, email [email protected] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
