Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Installation of Postgre database

Status
Not open for further replies.
parthaC

parthaC

Programmer
Nov 18, 2002
6
0
0
IN
Hi all,
I am a newcomer to postgreSQl. I have mandrake 9 installed in my machine and postgreSQL up and running as seen through ps -ef|grep postmaster.I am running su - postgres and running the command "psql" wherby it is showing "not in system catalogue". Do i have to enter any database name from psql when I am postgres user?? What is the database name??
Basically I have to create a database called "school"
in a directory "/dbfile" that is the database files should be in that directory. Also there is a linux user called "partha" password "partha" who should be able to connect to that database through psql as well as pgaccess.User "partha" is going to run some applications which needs connection to the database. Also how do I compile the proC scripts.Please help.Thanks in advance
Partha
 
Sort by date Sort by votes
Hi partha,

You will need to enter a database to connect to postgres. You should be able to use the template1 database to do it like:

psql template1 postgres

You should consider using a database admin tool like phpPgAdmin, pgaccess or pgaccess II to work with your database/tables. It sure does save me alot of time and effort.

Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
 
Upvote 0 Downvote
You do not need to enter a database to run psql, you can just type psql and attach to PostgreSQL. Once there you can list the available databases using \l and then connect to the one you want with the \c command.

When you type psql what error message do you get?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wbower34
  • Locked
  • Question
Postgres 9.6 Books
Replies
0
Views
101
wbower34
wbower34
OJSan
  • Locked
  • Question
On Postgresql 10 i can replace or rename the default Postgresql account?
Replies
0
Views
118
OJSan
OJSan
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
115
dbuxton101
dbuxton101
Dragonfish
  • Locked
  • Question
Installation
Replies
2
Views
49
Dragonfish
Dragonfish
LD50
  • Locked
  • Question
postgres 9.0 streaming replication for reporting
Replies
0
Views
95
LD50
LD50

Part and Inventory Search

Sponsor

Back
Top