$ rpm -i --force postgrerpm7.02
Not to sound rough, but if this is a new installation of RH6.0 you really wouldn't to be doing a --force option on the install.
Traditionally you would want to do
rpm -Uvh {the postgresql packages you want to install}
The data directory by default is /var/lib/pgsql.
Aside from that...
As root su to postgres
$ su - postgres
then run initdb
If initdb cannot find the database location it will ask you where the folders are.
If you change the default data directory you will need to inform postgres as to where the new location is by commandline or by editing the postmaster.opts file.
----------------
to connect to the db you can connect by doing
psql template1 postgres
where template1 is the first database created by initdb. and postgres is the user you are connecting as.
By default you cannot connect as root.
I hope this helps
Thomas
-
-
Thomas Swan - Graduate Student - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."