Skip site navigation (1) Skip section navigation (2)

Re: Problem with createdb

From: Jean Arnaud <Jean(dot)Arnaud(at)inrialpes(dot)fr>
To: Durgaprasad Pawar <durgaprasad(dot)pawar(at)yahoo(dot)co(dot)in>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem with createdb
Date: 2007-10-30 10:39:49
Message-ID: 472709F5.2080504@inrialpes.fr (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

have you done any modification to your pg_hba.conf ?


Durgaprasad Pawar a écrit :
> Hi,
>     I am experiencing a strange problem with createdb. It gives 
> following error message.
>
> ***********
> bin # ./createdb -U dpgres -p 9999 -h 127.0.0.1 -q mydb
> createdb: could not connect to database postgres: could not connect to 
> server: No route to host
> Is the server running on host "127.0.0.1" and accepting
> TCP/IP connections on port 9999?
> ************
>
> However, when I remove the -h option, it works smoothly.
>
> ************
> bin # ./createdb -U dpgres -p 9999 mydb
> CREATE DATABASE
> ************
>
> The changes in postgresql.conf file are:
>
> shared_buffers = 300MB
> work_mem = 150MB
>
> My system has 2 GB of RAM.
>
> The parameters in /etc/system are as follows.
>
> set msgsys:msginfo_msgmnb=65536
> set msgsys:msginfo_msgtql=1024
> set shmsys:shminfo_shmmax=0x15E00000
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=256
> set shmsys:shminfo_shmseg=256
> set semsys:seminfo_semmap=256
> set semsys:seminfo_semmni=512
> set semsys:seminfo_semmns=512
> set semsys:seminfo_semmsl=32
>
>
> Can anybody help me understand what the problem might be?
>
>
> Regards,
> DP
>
> ------------------------------------------------------------------------
> Forgot the famous last words? Access your message archive online. 
> Click here. 
> <http://in.rd.yahoo.com/tagline_webmessenger_4/*http://in.messenger.yahoo.com/webmessengerpromo.php>


-- 
-- Jean Arnaud
-- PhD student, SARDES project
-- INRIA Rhône-Alpes / LIG
-- http://sardes.inrialpes.fr/~jarnaud

In response to

Responses

pgsql-novice by date

Next:From: Moiz KothariDate: 2007-10-30 11:29:12
Subject: Re: Problem with createdb
Previous:From: Durgaprasad PawarDate: 2007-10-30 10:02:26
Subject: Problem with createdb

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group