Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


Search this Thread
Old 04-15-2004, 02:35 PM   #1
Registered: Nov 2003
Posts: 55

Rep: Reputation: 15
Postgres DBMS??!


i have RedHat Linux 8.0
i am supposed to learn how to use Postgres database systems on Linux.
but i don't know from where to run Postgres
could someone please tell me how and from where?

thank you for your time.
Old 04-15-2004, 06:35 PM   #2
Registered: Aug 2002
Posts: 12,059

Rep: Reputation: 760Reputation: 760Reputation: 760Reputation: 760Reputation: 760Reputation: 760Reputation: 760
Did you install postgresql when you installed RH?
I'm not familar with RH GUIs but look at the services and see if its set to start at boot? You can look at the output of:
chkconfig --list
What does it show for postgresql?

For documentation goto

The database server is called postmaster and runs in the background. You can check top or ps to see if its running. To access the DBMS you can use a command line interface which is called psql or the GUI called pgaccess. OpenOffice is also capable of accessing a postgresql database.
Old 04-15-2004, 07:22 PM   #3
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,000
Blog Entries: 11

Rep: Reputation: 893Reputation: 893Reputation: 893Reputation: 893Reputation: 893Reputation: 893Reputation: 893
I don't know how RH sets Pg up, but usually you
should have the daemon running after a successful

ps -A | grep postmaster

If that gives a result it's installed properly.

On a commandline try

That will create a database with your username
After that you should be able to

and end up with a screen like
[tink@diggn:/usr/src/gaim-0.76]$ psql
Welcome to psql 7.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit



Last edited by Tinkster; 09-08-2005 at 03:26 AM.
Old 04-27-2004, 03:20 PM   #4
Registered: Nov 2003
Posts: 55

Original Poster
Rep: Reputation: 15
hi! thank you for your post.
i get the following error when i try to create a database:

[Hady@localhost Hady]$ createdb

psql: FATAL 1: user "Hady" does not exist
createdb: database creation failed.

what shall i do??


Last edited by Hady; 04-27-2004 at 03:21 PM.
Old 04-27-2004, 04:19 PM   #5
Registered: Aug 2002
Posts: 12,059

Rep: Reputation: 760Reputation: 760Reputation: 760Reputation: 760Reputation: 760Reputation: 760Reputation: 760
Did you read the doucmentation?

Log in as root.
su postgres (The postgresql user i.e. has all database permissions)

You can give hady database superuser permissions. i.e create users and create databases.

See man createuser for additional help.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postgres Hiper1 Linux - Newbie 8 04-10-2005 06:43 PM
problems with SQLITE DBMS leochen Linux - Software 0 05-20-2004 09:51 PM
Installing PostgreSQL DBMS Hady Linux - Software 1 04-28-2004 06:44 AM
which DBMS to learn rvijay17 Linux - General 11 03-17-2003 03:38 PM
Whiich DBMS for very large database? nakkaya Linux - General 5 03-16-2003 11:38 PM

All times are GMT -5. The time now is 06:40 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration