| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Shashank Dutt Jha <shashank(dot)dj(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Create db fails using utility tool |
| Date: | 2016-02-05 06:08:53 |
| Message-ID: | 56B43C75.5040009@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Venkatesan, Sekhar | 2016-02-09 04:29:15 | Question on PostgreSQL DB behavior w.r.t JOIN and sort order. |
| Previous Message | Shashank Dutt Jha | 2016-02-05 04:15:13 | Re: Create db fails using utility tool |