X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D0DC7D922B for ; Fri, 30 Sep 2005 15:10:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54739-01 for ; Fri, 30 Sep 2005 18:10:03 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 63F29D6DA1 for ; Fri, 30 Sep 2005 15:10:01 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 30 Sep 2005 13:10:00 -0500 Subject: Re: db connection and script execution error From: Scott Marlowe To: "Tomeh, Husam" Cc: jeff shu , pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1128103800.29347.105.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Fri, 30 Sep 2005 13:10:00 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 required=5 tests=[AWL=0.007] X-Spam-Level: X-Archive-Number: 200509/335 X-Sequence-Number: 19072 On Fri, 2005-09-30 at 12:09, Tomeh, Husam wrote: > 1. create db by using postgres manager Lite's create db wizard >=20 > db name new_db / host : lost host/port: 5432/login: postgres > when I tried to connect to this db I got FATAL error, =C2=A1=C2=B0databas= e > new_db doesn=C2=A1=C2=AFt exist." Sounds like you created a database named something like: MyDatabase and are now referencing it as mydatabase. Make sure that whatever you call it in the creation wizard you call it that later. and you can save yourself a lot of little headaches by just naming everything, everywhere in lower case. > The above suggest that you haven't created your database (new_db) on > the postgres server. > =20 > --- > =20 > 2. Then I registered new host on port 5433, tried to connect. I got > follwing error, =C2=A1=C2=B0error connection to server, is the server run= ning on > host 127.0.0.1, and allow TCP/IP connection on port 5433?=C2=A1=C2=B1=20 >=20 > The above error may be due to not setting up your pg_hba.conf > correctly to accept TCP/IP connection from your PC. Or it there could > be a firewall issue.=20 Note that you also have to edit postgresql.conf to get a database to answer sometimes as well.