Re: Could not connect postgresql database

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 <landy.chapm...@gmail.com> wrote:
> 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 is running would be:
>    lsof | grep "postgres"
>
> >  createdb conntest
>
> I asked you to create a database because  if the server ISNT running
> you would not be able to.
>
> >   psql -d conntest
>
> As another suggested, this will try to use the postgres client.  If
> all that worked, I would've asked you to run
>
>   psql  -h 127.0.0.1 -d conntest
>
> Which, in a DEFAULT debian lenny install result in:
>    "psql: FATAL:  password authentication failed for user "postgres"
>
> I set a password for postgres:
>    su
>    passwd postgres
>
> Next I change pg_hba.conf to "trust" for localhost, restarted the
> server, and
>     psql  -h 127.0.0.1 -d conntest
>
> does work.  The last step would be to use my local IP address
>     psql  -h 192.168.1.211 -d conntest
>
> This would make sure remote machines could connect also.

--
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.