Re: Create db fails using utility tool - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: Create db fails using utility tool
Date
Msg-id 56B392B1.3010608@aklaver.com
Whole thread Raw
In response to Re: Create db fails using utility tool  (Shashank Dutt Jha <shashank.dj@gmail.com>)
Responses Re: Create db fails using utility tool  (Shashank Dutt Jha <shashank.dj@gmail.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Shashank Dutt Jha
Date:
Subject: Re: Create db fails using utility tool
Next
From: Michael Moore
Date:
Subject: Re: update without SET ?