i dont find anything inside this /var/log/postgres/postgresxxx.log.... after /var/log/postgres.. its empty
then i also dont find the file postgresql.conf... the path of installation is changed its in usr/share/postgresql.. i dont know how it changed..... but by default it must be in /var/lib/postgre.. as per the installation peocedure which i followed... On Sat, Aug 1, 2009 at 8:47 AM, baskar <[email protected]> wrote: > 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 > -- success is never final failure is never fatal have a good day SUDHARSH _______________________________________________ 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
