Re: Could not connect postgresql database

2011-08-23 Thread Landy Chapman
Great job. You could've told everyone that you had a working install and decided to break it & install from source code. but oh well. OSS truly is the ultimate, when you break it you get to keep both pieces :-; For the record: why did you install from source instead of using Ubuntu

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
I solved the problem. I just added, LD_LIBRARY_PATH=/usr/local/pgsql/lib PATH=/usr/local/pgsql/bin:$PATH lines to my .bashrc startup shell. After that there is no error. Selcuk On Aug 23, 10:50 pm, Landy Chapman wrote: > I reinstalled postgresql after deleting

Re: Could not connect postgresql database

2011-08-23 Thread Landy Chapman
I reinstalled postgresql after deleting config files. in postgresql.conf I changed this line: # listen = "localhost" to read: listen = "*" Also make sure this line is uncommented: port = 5432 Then I restarted the server. /etc/init.d/postgresql restart One way to see if postgresql

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
You're so right, sorry about that. OS: ubuntu 11.04 Database: postgresql 8.4.8 Django Version: 1.3 All of them are running on same machine. I install the current postgresql database version from source code. I think i missed something related to enviroment variables. I think, i just need to

Re: Could not connect postgresql database

2011-08-23 Thread Landy Chapman
Ignore my long-winded rant/reply above. the command should be psql -d test2db Cheers -- 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

Re: Could not connect postgresql database

2011-08-23 Thread Landy Chapman
> there are lots of questions about this problem on net , but there is > no point solution There's no FixItNow(tm) text that works for all use cases. Sometimes over-familiarity will cause maddening (though simple-to-fix) problems. My basic point is, since nothing you did solved the problem,

Re: Could not connect postgresql database

2011-08-23 Thread bikkit
com> Sender: django-users@googlegroups.com Date: Tue, 23 Aug 2011 12:06:06 To: Django users<django-users@googlegroups.com> Reply-To: django-users@googlegroups.com Subject: Re: Could not connect postgresql database Guys, When i command ; postgres@laptop:~$ /usr/local/pgsql/bin/crea

Re: Could not connect postgresql database

2011-08-23 Thread bikkit
ue, 23 Aug 2011 12:06:06 To: Django users<django-users@googlegroups.com> Reply-To: django-users@googlegroups.com Subject: Re: Could not connect postgresql database Guys, When i command ; postgres@laptop:~$ /usr/local/pgsql/bin/createdb test2db there is no problem and ".s.PGSQL.5432"

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
Guys, When i command ; postgres@laptop:~$ /usr/local/pgsql/bin/createdb test2db there is no problem and ".s.PGSQL.5432" file appeared in tmp directory which is ok according my postgresql.conf settings.But when i command; postgres@laptop:~$ psql test2db psql: could not connect to server: No such

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
nothing changed... there are lots of questions about this problem on net , but there is no point solution On Aug 23, 9:09 pm, Subhranath Chunder wrote: > Seems to me like it has something to do with pg_hba.conf settings. > > Maybe you can try out by commenting out the

Re: Could not connect postgresql database

2011-08-23 Thread Landy Chapman
I apologize.. What user are you running psql as? Try this: cd /tmp su postgres createdb conntest psql -d conntest That should since you can connect from pgadmin. If it doesn't. run (as root) /etc/init.d/postgresql force-restart and try the above again. On the django side, I would

Re: Could not connect postgresql database

2011-08-23 Thread Subhranath Chunder
Seems to me like it has something to do with pg_hba.conf settings. Maybe you can try out by commenting out the existing entries in it, and inserting one specific to your requirement. You should probably try it out. And don't forget to restart the db server everytime you make a change. On Tue,

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
i am taking error below: 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"? but there is no such a .s.PGSQL.5432 file. I really dont understand what is

Re: Could not connect postgresql database

2011-08-23 Thread Subhranath Chunder
You may try to test the connection using the command line interface 'psql'. On Tue, Aug 23, 2011 at 10:39 PM, SSozuer wrote: > Settings in postgresql.conf are ok. And also postgresql is running > without no problem. As i said, i can connect database with pgAdmin > with

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
Settings in postgresql.conf are ok. And also postgresql is running without no problem. As i said, i can connect database with pgAdmin with no error. Selcuk On Aug 23, 8:03 pm, Landy Chapman wrote: > Also did the the server actually start?  On debian, >  

Re: Could not connect postgresql database

2011-08-23 Thread Landy Chapman
Also did the the server actually start? On debian, /etc/init.d/postgresql start > > > Try connecting on the local system. I would guess you can't. It looks > > > like you have a problem with the socket directory. Permissions? > > remember to edit postgresql.conf -- make sure to change >  

Re: Could not connect postgresql database

2011-08-23 Thread Landy Chapman
> > On Tue, Aug 23, 2011 at 2:05 PM, SSozuer wrote: > > >        Is the server running locally and accepting > > >        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL. > > > 5432"? > > > Try connecting on the local system. I would guess you can't. It

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
l checked the /var/run/postgresql/... directory. But there is no directory called that. I'll reinstall postgresql from package, the current was installed from source code thanks for advice Selcuk On Aug 23, 6:06 pm, Simon Riggs wrote: > On Tue, Aug 23, 2011 at 2:05 PM,

Re: Could not connect postgresql database

2011-08-23 Thread Simon Riggs
On Tue, Aug 23, 2011 at 2:05 PM, SSozuer wrote: >        Is the server running locally and accepting >        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL. > 5432"? Try connecting on the local system. I would guess you can't. It looks like you have a

Re: Could not connect postgresql database

2011-08-23 Thread SSozuer
In addition i can connect database with pgAdmin III without any error... On Aug 23, 4:05 pm, SSozuer wrote: > Hi guys, > When i was checking the database connection,i am taking that error: > >  File "", line 1, in >   File

Could not connect postgresql database

2011-08-23 Thread SSozuer
Hi guys, When i was checking the database connection,i am taking that error: File "", line 1, in File "/usr/local/lib/python2.7/dist-packages/django/db/backends/ __init__.py", line 250, in cursor cursor = self.make_debug_cursor(self._cursor()) File