Thread: Create db fails using utility tool

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.klaver@aklaver.com

Yes server is running on the local host and default port. I can connect to it using UI pgsql client



> On Feb 4, 2016, at 10:10 PM, Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com

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.klaver@aklaver.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.klaver@aklaver.com
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 02/04/2016 08:15 PM, Shashank Dutt Jha wrote:
> pgAdmin tool.
>
> Yes running both on same machine.
>
> With explicit options, as suggested, it is able to create db.

Probably because this is on Windows. When you run createdb without -h it 
assumes you want to connect to a socket. On Windows that is not possible 
so Postgres substitutes localhost in for the socket. I am not exactly 
how that is done, but I suspect the manner in which is done is causing a 
Windows anti-virus or firewall program to block the connection. FYI, 
createdb is just a command line wrapper around the SQL command CREATE 
DATABASE:

http://www.postgresql.org/docs/9.5/interactive/sql-createdatabase.html

so you can do the same thing in psql or pgAdmin.


>
> Thanks for help
>
>
>
Adrian Klaver
adrian.klaver@aklaver.com