Skip site navigation (1) Skip section navigation (2)

Re: db connection and script execution error

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
Cc: jeff shu <flashqa7(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: db connection and script execution error
Date: 2005-09-30 18:10:00
Message-ID: 1128103800.29347.105.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-admin by date

Next:From: tasoDate: 2005-09-30 19:41:34
Subject: HP Openview
Previous:From: Tomeh, HusamDate: 2005-09-30 17:22:12
Subject: Re: db connection and script execution error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group