Problem with createdb
От | Durgaprasad Pawar |
---|---|
Тема | Problem with createdb |
Дата | |
Msg-id | 410047.9825.qm@web7702.mail.in.yahoo.com обсуждение исходный текст |
Ответы |
Re: Problem with createdb
Re: Problem with createdb |
Список | 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
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
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?
************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.
В списке pgsql-novice по дате отправления: