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

Tue Jul 22 08:54:17 UTC 2014

Thanks Jason,

I have just change the path /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.

and it's Initialising DB: SUCCESS

Thanks,
Bhavesh

On Tue, Jul 22, 2014 at 1:10 PM, Jason Tan <jason.tan at ersa.edu.au> wrote:

> 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/e0768289/attachment-0003.html>
-------------- 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/e0768289/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/e0768289/attachment-0013.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/e0768289/attachment-0014.png>
-------------- 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/e0768289/attachment-0015.png>