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 >