Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id B62202E003D for ; Sat, 12 Apr 2008 05:53:04 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 58498-03 for ; Sat, 12 Apr 2008 05:52:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pat.uio.no (pat.uio.no [129.240.10.15]) by developer.postgresql.org (Postfix) with ESMTP id 701E32E0032 for ; Sat, 12 Apr 2008 05:53:01 -0300 (ADT) Received: from mail-mx4.uio.no ([129.240.10.45]) by pat.uio.no with esmtp (Exim 4.67) (envelope-from ) id 1JkbTk-0007Lu-3f; Sat, 12 Apr 2008 10:52:56 +0200 Received: from smtp.uio.no ([129.240.10.9] helo=mail-mx4.uio.no) by mail-mx4.uio.no with esmtp (Exim 4.67) (envelope-from ) id 1JkbTj-0003fj-UU; Sat, 12 Apr 2008 10:52:56 +0200 Received: from c0db8bf51.dhcp.bluecom.no ([81.191.184.13] helo=[192.168.1.105]) by mail-mx4.uio.no with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.67) (envelope-from ) id 1JkbTj-0003eb-PU; Sat, 12 Apr 2008 10:52:55 +0200 Message-ID: <4800785F.2080804@usit.uio.no> Date: Sat, 12 Apr 2008 10:52:47 +0200 From: Tommy Gildseth User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: "Jaisen N.D." CC: pgsql-admin@postgresql.org Subject: Re: Problem:- createdb: could not connect to database postgres: could not connect to server: No such file or directory References: <7db916da0804112227p5b523629m18c949abf41c1f02@mail.gmail.com> In-Reply-To: <7db916da0804112227p5b523629m18c949abf41c1f02@mail.gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-UiO-Resend: resent X-UiO-Spam-info: not spam, SpamAssassin (score=0.0, required=5.0, autolearn=disabled, none) X-UiO-Scanned: AFB7108FDDB5FF534B90CB17C16F35B20C907950 X-UiO-SR-test: 3712C576101B0932A9CB051669A4B9303AA92074 X-UiO-SPAM-Test: remote_host: 129.240.10.9 spam_score: 0 maxlevel 200 minaction 2 bait 0 mail/h: 289 total 7844669 max/h 8345 blacklist 0 greylist 0 ratelimit 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL=0.000 X-Spam-Level: X-Archive-Number: 200804/104 X-Sequence-Number: 28868 Jaisen N.D. wrote: > postgres@localhost:~$ /usr/lib/postgresql/8.1/bin/createdb test > createdb: could not connect to database postgres: could not connect to > server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket > "/var/run/postgresql/.s.PGSQL.5432"? > postgres@localhost:~$ > ----------------------------------------------------- > Why it can't connect to server? How can I resolve it?? Doublecheck to see what port PostgreSQL is running on. Debian is known to put postgreSQL on non-standard ports, in order to make it possible to run multiple versions of postgreSQL on the same machine. -- Tommy Gildseth