Postgres DBMS??!

Hady · 04-15-2004, 01:35 PM

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.

michaelk · 04-15-2004, 05:35 PM

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.

Tinkster · 04-15-2004, 06:22 PM

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

Hady · 04-27-2004, 02:20 PM

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

michaelk · 04-27-2004, 03:19 PM

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.