Re: upgrade from 6.4 to 7.02 problem

> $ 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."