Re: PostgreSQL Socket 5432 Error

2012-04-19 Thread Jeff Heard
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

2012-04-19 Thread Russell Keith-Magee
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

2012-04-19 Thread Zach
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.