Skip site navigation (1) Skip section navigation (2)

Re: Getting up and running on Red Hat 9

From: "Eric S(dot) Johansson" <esj(at)harvee(dot)org>
To: Paul Linehan <plinehan(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Getting up and running on Red Hat 9
Date: 2003-10-24 18:25:48
Message-ID: 3F996EAC.1030106@harvee.org (view raw or flat)
Thread:
Lists: pgsql-novice
Paul Linehan wrote:

> 
> Hi all,
> 
> I'm fairly new to Linux and totally new to
> PostgreSQL, so bear with me please. I do have lots
> of experience with Interbase, Firebird, MS SQL
> and Oracle.
> 
> I have just installed Red Hat 9, which went fine.
> 
> I then wanted to install PostgreSQL, so I decided to
> go with the one on the Linux distro. 
> 
> 
> I went to the Services area in the system menu
> and ticked the PostgreSQL box. Now, on booting
> if I do ps -All | grep postmaster, I get
> 
> --
> 0 S    26  2208     1  0  75   0    -  2392 schedu ?
> 00:00:00 postmaster
> 1 S    26  2210  2208  0  85   0    -  2640 schedu ?
> 00:00:00 postmaster
> 1 S    26  2211  2210  0  85   0    -  2398 schedu ?
> 00:00:00 postmaster
> --
> 
> So, I figure that the postgreSQL server is running.
> 
> Then, I type (as myself as a user - Paul).
> 
> rpm -ivh pgadmin3-1.0.0-1.i386.rpm
> 
> But, I have no idea how to start up the admin tool, 
> or what other steps that I should take to get a
> couple of databases up and running so that I can
> administer them using the tool.
> 
> What do I type and where? At the moment, I don't
> wish to install from source!
personally, I'm not sure how to run pgadmin3 myself because I've 
primarily used webmin and psql.

Little bits of black magic have learned include:

Give your postgres user a password with postgresql turned off.  Why?  It 
appears that the startup process for postgresql copies over passwords 
from the password file into itself on startup if the user in postgresql 
exists in the UNIX password file.  For example, it will not copy the 
root password unless you create a database user called root.

The stock configuration files do not have logging turned on and I really 
need to go searching for how to turn on logging.

always run as postgres during your initial testing.  That's the 
equivalent of root for the database (I think)

don't be afraid to dive in with psql and look at the tables. \d is your 
friend.

another friend is "rm -rf" which you will use on the database files 
regularly as you make mistakes.

---eric

-- 
Speech recognition in use.  Incorrect endings, words, and case is
closer than it appears


In response to

pgsql-novice by date

Next:From: Jordan S. JonesDate: 2003-10-25 00:33:33
Subject: Re: how to create a multi columns return function ?
Previous:From: Mel JameroDate: 2003-10-24 07:41:00
Subject: derive the sequence name of a column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group