Re: db connection and script execution error - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: db connection and script execution error
Date
Msg-id 1128103800.29347.105.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: db connection and script execution error  ("Tomeh, Husam" <htomeh@firstam.com>)
List pgsql-admin
On Fri, 2005-09-30 at 12:09, Tomeh, Husam wrote:
> 1. create db by using postgres manager Lite's create db wizard
>
> db name new_db / host : lost host/port: 5432/login: postgres
> when I tried to connect to this db I got FATAL error, ¡°database
> new_db doesn¡¯t 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.
>
> ---
>
> 2. Then I registered new host on port 5433, tried to connect. I got
> follwing error, ¡°error connection to server, is the server running on
> host 127.0.0.1, and allow TCP/IP connection on port 5433?¡±
>
> 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.

Note that you also have to edit postgresql.conf to get a database to
answer sometimes as well.

pgsql-admin by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: db connection and script execution error
Next
From: ig@freemail.gr (Çëßáò Ãêïõíôáñüðïõëïò)
Date:
Subject: Postgresql 8.0.3 installation problem on WinXP SP2