Re: Create db fails using utility tool - Mailing 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