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 2C37DD9AC4 for ; Wed, 28 Sep 2005 14:05:26 -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 47572-06 for ; Wed, 28 Sep 2005 17:05:22 +0000 (GMT) Received: from web35802.mail.mud.yahoo.com (web35802.mail.mud.yahoo.com [66.163.179.171]) by svr1.postgresql.org (Postfix) with SMTP id 69EBFD8C50 for ; Wed, 28 Sep 2005 14:05:21 -0300 (ADT) Received: (qmail 10392 invoked by uid 60001); 28 Sep 2005 17:05:18 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=TIFtV6DN4XQr3TvI3qvgnRY+okvm+QqfvylW6VXzAj0H/hlO9zDyN5FFOqTIo9ThBOcO6NCyzk4eRfaDgZOfaxDRrWLt/e+P7cMCi1D8giTeXMZ4vrhtkPpoVII8StN1J/4pL1SxMqI38+ivZeE32/PKnZIlO7/3SOSSELAF6hQ= ; Message-ID: <20050928170518.10390.qmail@web35802.mail.mud.yahoo.com> Received: from [71.131.61.165] by web35802.mail.mud.yahoo.com via HTTP; Wed, 28 Sep 2005 10:05:18 PDT Date: Wed, 28 Sep 2005 10:05:18 -0700 (PDT) From: jeff shu Subject: db connection and script execution error To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-673157527-1127927118=:6063" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.256 required=5 tests=[AWL=0.587, DNS_FROM_RFC_ABUSE=0.374, HTML_10_20=0.295, HTML_MESSAGE=0.001] X-Spam-Level: * X-Archive-Number: 200509/306 X-Sequence-Number: 19043 --0-673157527-1127927118=:6063 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-673157527-1127927118=:6063 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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, t hen 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. --0-673157527-1127927118=:6063--