X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E1C65D1B528 for ; Sun, 14 Sep 2003 01:42:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 32730-01 for ; Sat, 13 Sep 2003 22:42:47 -0300 (ADT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id C2EB0D1B526 for ; Sat, 13 Sep 2003 22:42:43 -0300 (ADT) Received: from [172.16.0.30] (h00508bcfaaed.ne.client2.attbi.com[65.96.103.108](untrusted sender)) by comcast.net (rwcrmhc12) with SMTP id <20030914014247014008ptu6e>; Sun, 14 Sep 2003 01:42:47 +0000 Subject: Re: [PHP] Help me From: "Kent L. Nasveschuk" To: Tran Anh Tu Cc: Postgres-Admin list In-Reply-To: References: <200309131050.22440.martin@bugs.unl.edu.ar> Content-Type: text/plain Organization: Message-Id: <1063502858.2747.3.camel@1134> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 13 Sep 2003 21:27:39 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/244 X-Sequence-Number: 10332 Are you connecting on the local machine? If so try without the -U and -p ex.: psql waterdb You can also use telnet or ssh and connect from a remote machine and do the same. Kent N On Sat, 2003-09-13 at 21:23, Tran Anh Tu wrote: > I started postgresql with command: > /etc/init.d/postgresql start > I created user 'trantu' with password 'hanoi' and this user have > privileges fully to create database and create user. > when I type a command: > psql -U trantu -p hanoi > or > psql -U trantu -p hanoi waterdb > have a same error: > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > connections on Unix domain socket "/tmp/.s.PGSQL.0"? > > With phpPgAdmin, apache and php are configured perfecly. > Please help me to debug it. Thank you very much. > ******************************************************* > Tran Anh Tu > Vien CNTT - DHQG Ha Noi > Phone: 047680417-25 Email trantu@vnu.edu.vn > ******************************************************* > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html -- Kent L. Nasveschuk .