LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices

Reply
 
Search this Thread
Old 04-15-2004, 01:35 PM   #1
Hady
Member
 
Registered: Nov 2003
Posts: 55

Rep: Reputation: 15
Postgres DBMS??!


Hi!

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, 05:35 PM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 11,856

Rep: Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738Reputation: 738
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 www.postgresql.org

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, 06:22 PM   #3
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,974
Blog Entries: 11

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

ps -A | grep postmaster

If that gives a result it's installed properly.

On a commandline try
createdb

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

and end up with a screen like
Code:
[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

tink=>


Cheers,
Tink

Last edited by Tinkster; 09-08-2005 at 02:26 AM.
 
Old 04-27-2004, 02:20 PM   #4
Hady
Member
 
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??

thanks

Last edited by Hady; 04-27-2004 at 02:21 PM.
 
Old 04-27-2004, 03:19 PM   #5
michaelk
Moderator
 
Registered: Aug 2002
Posts: 11,856

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

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

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

See man createuser for additional help.
 
  


Reply


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 05:43 PM
problems with SQLITE DBMS leochen Linux - Software 0 05-20-2004 08:51 PM
Installing PostgreSQL DBMS Hady Linux - Software 1 04-28-2004 05:44 AM
which DBMS to learn rvijay17 Linux - General 11 03-17-2003 02:38 PM
Whiich DBMS for very large database? nakkaya Linux - General 5 03-16-2003 10:38 PM


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

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