pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: jeff shu <flashqa7@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: db connection and script execution error
Date: Wed, 28 Sep 2005 10:05:18 -0700 (PDT)
Message-ID: <20050928170518.10390.qmail@web35802.mail.mud.yahoo.com> (raw)

Dear pgsql-admin members:
 
 I am new to PostgresSql and run into some problems after I installed Posgressql 8.0 and PostgresSql  manager 3 Lite. Your advises will be appreciated:)
 
I. can't make connection to database
II. can't run a script which will created a database.

I. can't make connection to database

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."

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?¡± 

I checked pgadmin menu If this message appears, there are two possible reasons for this: 
a)either the server isn't running at all. Simply start it. 

b)The other non-trivial cause for this message is that the server isn't configured to accept TCP/IP requests on the address shown. 

Modification done: modified postgressql.conf set listen_addresses='*'
Do I need to set port = 5432, then add port 5433 as well? I still got same error message


II. can't run a script which will created a database.

1. run script in EMS postgres manager Lite
run command create database booktown;
¡¤ Error: "ERROR: source database "template1" is being accessed by other users" 

2. Run script in pgadmin 
Create Database "booktown";
\connect booktown postgres
ERROR: syntax error at or near "\" at character 146

Please give me some advise, I am kind of struck here. I need information on how to create and connect to a database

Where I can find error log message in postgres.org web site which can help me trouble shoot the error message i got.
 
Jeff
9-28-05

		
---------------------------------
Yahoo! for Good
 Click here to donate to the Hurricane Katrina relief effort. 

view thread (4+ messages)  latest in thread

Message-ID: <20050928170518.10390.qmail@web35802.mail.mud.yahoo.com>
Permalink:  ../20050928170518.10390.qmail@web35802.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/20050928170518.10390.qmail@web35802.mail.mud.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: flashqa7@yahoo.com
  Subject: Re: db connection and script execution error
  In-Reply-To: <20050928170518.10390.qmail@web35802.mail.mud.yahoo.com>
  References: <20050928170518.10390.qmail@web35802.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox