Re: PostgreSQL Socket 5432 Error
The other possibility is that you need to build psycopg2 from scratch and set the pg_config option in setup.cfg. I have to do this with the brew build of pg because the socket is elsewhere On Apr 19, 2012, at 7:32 PM, Russell Keith-Magee wrote: > On Friday, 20 April 2012 at 6:04 AM, Zach wrote: >> Hi I am trying to setup a PostgreSQL database for Heroku. I am running >> into trouble. >> >> I installed PostgreSQL(9.0) from EnterpriseDB on OS X 10.6. However, >> when I do a simple >> >> $ psql -U postgres >> >> I get this error message. >> >> psql: could not connect to server: No such file or directory >> Is the server running locally and accepting >> connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL. >> 5432"? >> >> I am getting the same message when I do a syncdb. >> >> Any ideas what could be causing this. Thank you so much! >> > Well, the error message asks you: >> Is the server running locally and accepting >> connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL. >> 5432"? > > > > Is it? I'm going to go out on a limb and say "No, it isn't". > > Just because you've installed Postgres doesn't *necessarily* mean you've > started the Postgres server. If the server isn't running, you won't be able > to connect to the server, which is what psql (and syncdb) is trying to do. > > Yours, > Russ Magee %-) > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
Re: PostgreSQL Socket 5432 Error
On Friday, 20 April 2012 at 6:04 AM, Zach wrote: > Hi I am trying to setup a PostgreSQL database for Heroku. I am running > into trouble. > > I installed PostgreSQL(9.0) from EnterpriseDB on OS X 10.6. However, > when I do a simple > > $ psql -U postgres > > I get this error message. > > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL. > 5432"? > > I am getting the same message when I do a syncdb. > > Any ideas what could be causing this. Thank you so much! > Well, the error message asks you: > Is the server running locally and accepting > connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL. > 5432"? Is it? I'm going to go out on a limb and say "No, it isn't". Just because you've installed Postgres doesn't *necessarily* mean you've started the Postgres server. If the server isn't running, you won't be able to connect to the server, which is what psql (and syncdb) is trying to do. Yours, Russ Magee %-) -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
PostgreSQL Socket 5432 Error
Hi I am trying to setup a PostgreSQL database for Heroku. I am running into trouble. I installed PostgreSQL(9.0) from EnterpriseDB on OS X 10.6. However, when I do a simple $ psql -U postgres I get this error message. psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL. 5432"? I am getting the same message when I do a syncdb. Any ideas what could be causing this. Thank you so much! -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.