Re: "Connection refused" with backend psycopg2

On May 23, 2012, at 1:41 PM, Tanuva wrote:

> Am 22.05.2012 23:52, schrieb akaariai:
>> On May 22, 11:51 pm, Tanuva <tan...@googlemail.com> wrote:
>>> Moin,
>>>
>>> lately, I wanted to switch my database from the testing sqlite file to a
>>> more productive pgsql 8.4 server. Now I'm constantly getting a
>>> "connection refused" from the psycopg2 backend:http://dpaste.org/0Ezka/
>>> Database configuration:http://dpaste.org/QPjD2/(not that verbose...)
>>>
>>> Funny enough, connecting manually using psycopg2 in a python2 shell and
>>> using pgadmin to confirm changes done there works just fine, so there
>>> must be something in between.
>>>
>>> What information might help you help me helping myself? ;)
>>
>> I would take a wild guess that this is related to pg_hba.conf. Is the
>> database on the localhost? If so, can you connect to it using 'psql -d
>> thedb', but not with 'psql -d thedb -h www0.....com -U
>> the_user_in_settings'.
>>
>> - Anssi
>>
>
> No, the db is not running on localhost, the machine sits in some
> datacentre. On that db server, your first command indeed doesn't work.
> Sadly that doesn't tell us much now I guess. The second one works fine
> both on the machine and here on my local box.
>
> Marcel

I had the same problem when i was working on a school project. I informed my supervisor and he restarted the servers which solved the problem.

I don't know if that may solve your problem but do be careful because i believe you are dealing with production servers.

Just my two cents worth.

Stanwin
>
> --
> 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+unsubscribe@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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.