Re: Use of Postgres in RH 7.2

[blkline attglobal net]

"Daniel F. Montagnese" wrote:
> 
> I just did it for the first time last night, but  am not quite an expert
> yet.  As root, type 'initdb'.  Make sure there is a postgres user.  As
> postgres, type 'pg_ctl -D /var//lib/pgsql/data -o "-i" '
> to start the postmaster as a daemon on an iternet domain tcp socket.  As
> postgres, type  'createdb db_name'.  To connect to the new data base
> named 'db_name', type 'psql db_name'.
> Type '\?' to see the psql commands.  Type '\h' to see the available sql
> commands.

Don't go to all that trouble.  When you (as root) type:

/sbin/service postgresql start

the first time the scripts will automatically take care of the
initdb.  
You need to edit the config files:

/var/lib/pgsql/data/postgresql.conf and
/var/lib/pgsql/data/pg_hba.conf

to enable TCP/IP connections and set the level of security for the
connection.

Barry


-- 
Please avoid sending me Word, PowerPoint or Excel attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html