agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Adrian Klaver <adrian.klaver@aklaver.com>
To: Shashank Dutt Jha <shashank.dj@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Create db fails using utility tool
Date: Thu, 4 Feb 2016 22:08:53 -0800
Message-ID: <56B43C75.5040009@aklaver.com> (raw)
In-Reply-To: <CAKkUp99qNjSdjkN6VjxYxp=-p97P1_PFZ52iS368m+2ayFotuQ@mail.gmail.com>
References: <CAKkUp98EVUVpttXj90vKWsD+n2j5=i-SfEnqxdvereyncJvSHg@mail.gmail.com>
<56B37EF8.7030904@aklaver.com>
<649F207B-457F-4DC7-8770-CB5E7E467C4F@gmail.com>
<56B392B1.3010608@aklaver.com>
<CAKkUp99qNjSdjkN6VjxYxp=-p97P1_PFZ52iS368m+2ayFotuQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (6+ messages)
Message-ID: <56B43C75.5040009@aklaver.com>
Permalink: ../56B43C75.5040009@aklaver.com/
Also on: postgresql.org/message-id/56B43C75.5040009@aklaver.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: adrian.klaver@aklaver.com, shashank.dj@gmail.com
Subject: Re: Create db fails using utility tool
In-Reply-To: <56B43C75.5040009@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox