Postgresql is now at version 6.5. Their web site is updated, but the last
file in their ftp site is beta 5. I guess they are sill fixing last-minute
bugs (it was supposed to be released last week).
As soon as I get my hands on the final release, I compile and package it
for Mandrake 6.
Jean-Michel
[EMAIL PROTECTED]
[EMAIL PROTECTED]
On Thu, 10 Jun 1999, Tom Berger wrote:
> Date: Thu, 10 Jun 1999 14:01:24 +0200
> From: Tom Berger <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: [expert] FWD: suggested solution for postgresql problem
>
> 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
>
