Re: Create db fails using utility tool
| От | Shashank Dutt Jha |
|---|---|
| Тема | Re: Create db fails using utility tool |
| Дата | |
| Msg-id | CAKkUp99qNjSdjkN6VjxYxp=-p97P1_PFZ52iS368m+2ayFotuQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Create db fails using utility tool (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Create db fails using utility tool
|
| Список | pgsql-sql |
pgAdmin tool.
Yes running both on same machine.
With explicit options, as suggested, it is able to create db.
Thanks for help
On Thu, Feb 4, 2016 at 11:34 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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 по дате отправления: