Thread: db connection and script execution error
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.
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.
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."
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."
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.
---
To create a database, you can login to your postgres server as Postgres (or whatever the owner of Postgres is) and issue:
createdb your_db_name ;
You may want to check the PostgreSQL docs on creating a database.
--
--
Husam
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of jeff shu
Sent: Wednesday, September 28, 2005 10:05 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] db connection and script execution error
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.
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.
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s)
named above and may contain information that is legally privileged. If you are not the
addressee, or the person responsible for delivering it to the addressee, you are hereby
notified that reading, disseminating, distributing or copying this message is strictly prohibited.
If you have received this message by mistake, please immediately notify us by replying to the
message and delete the original message immediately thereafter.
Thank you. FADLD Tag
**********************************************************************
> 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."
> 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."
*** 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.
---
*** To create a database, you can login to your postgres server as Postgres (or whatever the owner of Postgres is) and issue:
createdb your_db_name ;
You may want to check the PostgreSQL docs on creating a database.
--
--
Husam
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of jeff shu
Sent: Wednesday, September 28, 2005 10:05 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] db connection and script execution error
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.
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.
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s)
named above and may contain information that is legally privileged. If you are not the
addressee, or the person responsible for delivering it to the addressee, you are hereby
notified that reading, disseminating, distributing or copying this message is strictly prohibited.
If you have received this message by mistake, please immediately notify us by replying to the
message and delete the original message immediately thereafter.
Thank you. FADLD Tag
**********************************************************************
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.