[ckan-dev] Could not connect to server: Connection refused - Postgresql in CKAN

Tue Jul 22 07:40:45 UTC 2014

Hi Again,

Paster is telling you thatpostgres is not listening on the 192.168.251.89
IP on port 5432.

Is 192.168.251.89 the postgres database server?

If 192.168.251.89 IS the psotgres server then log into 192.168.251.89 and
run:

ps auxwww|grep postmaster

You should get something like:
[jtan at ckan-db ~]$ ps auxwww | grep postmaster
postgres  1579  0.0  0.0 216512  5776 ?        S    Jun30   1:34
/usr/pgsql-9.0/bin/postmaster -p 5432 -D /var/lib/pgsql/9.0/data -i -h
192.168.251.89

The important bit is the
 -i -h 192.168.251.89

The -'i' says listen on internet sockets (as opposed to unix sockets)
The '-h 192.168.251.89' says what host/IP address to listen on.

If both paster and postgres are running on 192.168.251.89 you can simply
change the postgres URLs in
/etc/ckan/default/development.ini to use 127.0.0.1:5432 instead of
192.168.251.89:5432 and update pg_hba.conf to suit.

Jason

On 22 July 2014 16:45, Library IT <libraryit at iimahd.ernet.in> wrote:

> Dear All,
>
> We are installing CKAN using Source.
>
> http://docs.ckan.org/en/1117-start-new-test-suite/install-from-source.html
>
> We are facing some issue while execute the step no : 6 Create database
> tables
>
> paster db init -c /etc/ckan/default/development.ini
>
> [image: Inline image 1]
>
>
> Database list :
>
> [image: Inline image 2]
>
> pg_hba.conf file
>
>
> [image: Inline image 3]
>
> CKAN Config : development.ini
>
> [image: Inline image 4]
>
> Please let me know what may be the issue ?
>

-- 
Jason Tan
Data Infrastructure Specialist, eResearch SA

phone: +61 8 8313 2184
Mob: +61 407 268 270
email: jason.tan at ersa.edu.au
web: http://www.ersa.edu.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/3953f3e8/attachment-0003.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 13851 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/3953f3e8/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 3573 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/3953f3e8/attachment-0013.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 7755 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/3953f3e8/attachment-0014.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 18929 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140722/3953f3e8/attachment-0015.png>