Re: Create db fails using utility tool

pgAdmin tool.

Yes running both on same machine.

With explicit options, as suggested, it is able to create db.

Thanks for help

On Thu, Feb 4, 2016 at 11:34 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 02/04/2016 09:45 AM, Shashank Dutt Jha wrote:
>
>> Yes server is running on the local host and default port. I can connect
>> to it using UI pgsql client
>>
>
> Do you mean pgAdmin or the SQL shell command?
>
> In either case are you running createdb.exe on the same machine?
>
> What happens if you run createdb.exe with explicit options:
>
> createdb.exe -h localhost -p 5432 -U <some_superuser>
>
>
>
>>
>>
>> On Feb 4, 2016, at 10:10 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
>>> wrote:
>>>
>>> On 02/03/2016 11:23 PM, Shashank Dutt Jha wrote:
>>>> c:\Program Files\PostgreSQL\9.5\bin>createdb.exe testdb
>>>> createdb: could not connect to database template1: could not connect to
>>>> server:
>>>> Connection refused (0x0000274D/10061)
>>>> Is the server running on host "localhost" (::1) and accepting
>>>> TCP/IP connections on port 5432?
>>>> could not connect to server: Connection refused (0x0000274D/10061)
>>>> Is the server running on host "localhost" (127.0.0.1) and
>>>> accepting
>>>> TCP/IP connections on port 5432?
>>>>
>>>
>>>
>>> Well the error is pretty specific, so is the server running and if so
>>> does it have the parameters set as above?
>>>
>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian(dot)klaver(at)aklaver(dot)com
>>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>