Problem with createdb

From: Durgaprasad Pawar <durgaprasad(dot)pawar(at)yahoo(dot)co(dot)in>
To: pgsql-novice(at)postgresql(dot)org
Subject: Problem with createdb
Date: 2007-10-30 10:02:26
Message-ID: 410047.9825.qm@web7702.mail.in.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Explore your hobbies and interests. Go to http://in.promos.yahoo.com/groups

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jean Arnaud 2007-10-30 10:39:49 Re: Problem with createdb
Previous Message Steve T 2007-10-29 18:03:12 Re: Graphical tools for PostGres