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

Re: Problem with createdb

From: "Moiz Kothari" <moizpostgres(at)gmail(dot)com>
To: "Jean Arnaud" <Jean(dot)Arnaud(at)inrialpes(dot)fr>
Cc: "Durgaprasad Pawar" <durgaprasad(dot)pawar(at)yahoo(dot)co(dot)in>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem with createdb
Date: 2007-10-30 11:29:12
Message-ID: 82e1a9bd0710300429t290a2b8fhe62afcb7d553dff8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

Jean has a perfect question for you. Have you done any modifications to your
pg_hba.conf.

Regards,
Moiz Kothari

On 10/30/07, Jean Arnaud <Jean(dot)Arnaud(at)inrialpes(dot)fr> wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>



-- 
Hobby Site : http://dailyhealthtips.blogspot.com

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2007-10-30 15:22:35
Subject: Re: Problem with createdb
Previous:From: Jean ArnaudDate: 2007-10-30 10:39:49
Subject: Re: Problem with createdb

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