Hi!
Wayne Larmon has fixed his troubles with postgresql and thankfully told me
about it. Since this might help others, too, here is his mail:
[begin quote]
The "postgresql install is incomplete (missing files in
/var/lib/pgsql/)" problem was discussed in comp.os.linux.setup under the
thread "Postgresq starting problem." Somebody posted a workaround that
worked for me. (I think.)
Here is an edited extract from my posting:
----------------------------------------------------
>> Forum: comp.os.linux.setup
>> Thread: Postgresql starting problem
>> Message 4 of 4
Subject: Re: Postgresql starting problem
Date: 1999/06/06
Author: wlarmon <[EMAIL PROTECTED]>
>
> You have to 'su postgres' first, then give the initdb command. I
> think the correct invocation is:
> initdb --pglib=/usr --pgdata=/var/lib/pgsql
> or at least that is close. After that works you can use
> createuser commands to add other users, then they can do
> createdb commands to create databases.
>
> Les Mikesell
> [EMAIL PROTECTED]
Close. I first had to remove /var/lib/pgsql/PB_VERSION . I then
typed
initdb --pglib=/usr/lib/pgsql --pgdata=/var/lib/pgsql
Now my /var/lib/pgsql directory contains
-rw------- 1 postgres postgres 4 Jun 6 15:51 PG_VERSION
drwx------ 3 postgres postgres 1024 Jun 6 15:51 base
-rw------- 1 postgres postgres 8192 Jun 6 15:51 pg_database
-r-------- 1 postgres postgres 2838 Jun 6 15:51 pg_geqo.sample
-rw------- 1 postgres postgres 0 Jun 6 15:51 pg_group
-r-------- 1 postgres postgres 5192 Jun 6 15:51 pg_hba.conf
-rw------- 1 postgres postgres 8192 Jun 6 15:51 pg_log
-rw-rw-rw- 1 postgres postgres 53 Jun 6 15:51 pg_pwd
-rw------- 1 postgres postgres 8192 Jun 6 15:51 pg_shadow
-rw------- 1 postgres postgres 8192 Jun 6 15:51 pg_variable
like it should. (Before it only contained PG_VERSION, which
prevented initdb from working.)
Wayne Larmon
-----------------------------------------------------------------------
I don't know if this is the complete fix. I only tested that "pgsql
template1" woke up without errors, which, of course, it wouldn't before.
[...]
[end quote]
Regards
tom
--
"Everybody is someone else's newbie." (Marilyn Manson, edited)
Thomas 'Tom' Berger, [EMAIL PROTECTED] No UCE. No spam. 'nuff said.
Questions? Answers! Go Mandrake Answers at http://aolmfaq.tsx.org
