Re: Strange problem upgrading to 7.0.3x

On Thu, 16 Nov 2000, Lamar Owen wrote:

> The result of 'rpm -qa|grep postgres' would be educational here.

  I actually do understand the differences among -i (install) -U (upgrade)
and -F (freshen). What I don't understand is why what _should_ work _isn't_
working.

  For example, as Lamar and others suggested:

[root@salmo rshepard]# rpm -qa | grep postgres
postgresql-server-6.5.3-1
postgresql-test-6.5.3-1
postgresql-7.0.3-2

  "Aha, I said. The rpm database thinks that postgresql-server, and -test are still
installed." Then I tried to erast the server:

[root@salmo rshepard]# rpm -e postgresql-server-6.5.3-1
error reading information on service postgresql: No such file or directory
execution of script failed

  Where this gets more interesting is that the first time I ran the rpm
query postgresql-devel-6.5.3-1 also showed up. Running erase on that package
came up with all sorts of errors because I had already removed
/usr/include/pgsql/ and /usr/lib/pgsql/. But, when I ran the query again,
-devel didn't show up.

  I just tried erasing -test, and found the same messages: cannot do it
because the files or directories do not exist. But, now the query shows only
-server (that is, -test is gone, too). But, I cannot replace the server.
Let's see what happens if I try to upgrade the server ... it worked! I guess
it was the problems with -devel and -test still being registered in the rpm
database that made the difference.

  Next: re-starting postgres. Do I do this by invoking initdb? Here's what
that did:

[root@salmo rshepard]# initdb
The program pg_id needed by initdb could not be found. It was
expected at:
    /usr/bin/pg_id
If this is not the correct directory, please start initdb
with a full search path. Otherwise make sure that the program
was installed successfully.

  Thanks, everyone. Getting closer here to a working postgres-7.0.3!

Rich

Dr. Richard B. Shepard, President

                       Applied Ecosystem Services, Inc. (TM)
              Making environmentally-responsible mining happen. (SM)
                       --------------------------------
            2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
 + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com