Re: [cobalt-developers] Postgre SQL

[vic@xxxxxxx]

On Thu, 18 Jan 2001, Dan wrote:

> I was wondering what the mechanics are for configuring Postgre SQL, i.e.:
> 
> 1) What configuration files I alter, the path to those files (such as where
> I should create pg_hba.conf)
If postgreSQL is already installed, you will find the files in ~postgres.
> 2) is there is an autoconfig utility?
If you are compiling it from sources, I recall, there is one. If you are
talking aubout autoconfiguring a system that has never been started, you
can use the tricks in the posgresql script from RH 6.2 or RH 7.0 to
initialize the database system automagically, if not just use initdb as 
postgres user and follow directions.

>3) what ports I can use to conect to PostgreSQL
The 'normal' port is 5432, in the Qube3 Cobalt has decided to use 5583.
The psql command line tool, does not need a port number to connect to
local databases. If you intend to use PHP for connecting to your
databases, you need to enable 'internet' connections in the posgresql
startup script (/etc/rc.d/init.d/posgresql) with a -i option for the
postmaster command, then localhost connections are allowed to your
databases. If you have multiple users with different databases in your
system that could step on each other toes, refer to a previous post from
me (a week or so ago) on the topic. (List archives at
http://list.cobalt.com/pipermail/cobalt-developers/)
> 4) where I can find additional documentation or a few tutorials on it (the
Ask the elephant: http://www.postgresql.org/
> 
> Thank you -
> Dan
> 
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
> 

-------------------------------------------------------------------------------
G & S Sistemas de Informacion, S.L.  | Phones:
Victoriano Giralt                    |   Land line: +34-952-207-048
Chief Consultant and Owner           |   Mobile:    +34-670-332-720
Torre de San Telmo, 8                |   Fax:       Use e-mail, looks nicer
E-29018 Malaga (Spain)               | E-mail: vic@xxxxxxx
Member of ISOC (Andalusian Chapter)  | http://www.gssi.es/ 
-------------------------------------------------------------------------------