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!
  • Students Click Here

*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

PostgreSQL on linux

PostgreSQL on linux

PostgreSQL on linux

OK I rarly use linux but I have a CSCE 492 project that requires me to use it for a few things

Basically I need to run a wildfire server with an external PostgreSQL database and I'm having trouble getting PostgreSQL server running

I got the postgresql 8.2.3.tar.bz2

I extracted that and got


to work from here I'm kinda stuck I don't know what I need to do.

I need to create a db I have the table definitions written out

I think basically I need to set enviroment variables and some paths but I can't seem to get them to work correctly

RE: PostgreSQL on linux


So you say PostgreSQL is installed successfully ?

Then you only have to :

Initialize PostgreSQL data directory

The initdb tool must create the files and directories needed for the data storage in the designated directory. It must be executed before the server is started.

CODE --> as unprivileged user

initdb -D /var/lib/postgresql/data

Start PostgreSQL

PostgreSQL can be started in two ways :
  • as daemon, in background, with pg_ctl

    CODE --> as superuser

    postmaster -D /var/lib/postgres/data
  • single user mode, in foreground, with postmaster

    CODE --> as unprivileged user

    pg_ctl start -D /var/lib/postgresql/data -L /var/log/postgresql -o -i
Check in /etc/init.d/ to see if you already have a startup script for PostgeSQL. If not, you can write one easily using the examples in man pg_ctl

Use PostgreSQL

Use the psql utility to access the databases. Some statements can be executed with dedicated tools too : createdb, dropdb, vacuumdb.

For dump manipulation there are separate tools : pg_dump, pg_dumpall, pg_restore. Note that compressed dumps can be handled only by pg_restore, but plain dumps can be loaded with psql too.

Try the above steps and when in doubt, ask again.


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