Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Installation of Postgre database

Installation of Postgre database

Installation of Postgre database

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

RE: Installation of Postgre database

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

RE: Installation of Postgre database

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?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close