Gentoo Archives: gentoo-dev

From: 320095285153-0001@t-online.de (Achim Gottinger)
To: gentoo-dev@g.o
Subject: Re: [gentoo-dev] Problem with installing Postgres
Date: Tue, 23 Jan 2001 12:23:02
Message-Id: 3A6D989E.85E4F9FF@gottinger.de
In Reply to: [gentoo-dev] Problem with installing Postgres by Robert Schrem
Robert Schrem wrote:

> Hi, gentoo rocks ! > > I tried to install PostgresQL on Gentoo > using the package dev-db/postgresql-7.0.3.tbz2 > without succsess. I get the following error > when I run initdb to initialize the postgres on > disk data structures: > > bash-2.04# rm -rf /var/lib/pgsql/* > bash-2.04# su postgres > bash-2.04$ /usr/local/pgsql/bin/initdb -D /var/lib/pgsql > This database system will be initialized with username "postgres". > This user will own all the data files and must also own the server process. > > Fixing permissions on existing directory /var/lib/pgsql > Creating directory /var/lib/pgsql/base > Creating directory /var/lib/pgsql/global > Creating directory /var/lib/pgsql/pg_xlog > Creating template1 database in /var/lib/pgsql/base/1 > DEBUG: starting up > DEBUG: database system was shut down at 2001-01-22 12:36:25 > DEBUG: CheckPoint record at (0, 8) > DEBUG: Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE > DEBUG: NextTransactionId: 514; NextOid: 16384 > DEBUG: database system is in production state > ERROR: Error: unknown type 'ame'. > > Creating global relations in /var/lib/pgsql/global > DEBUG: starting up > DEBUG: database system was interrupted at 2001-01-22 12:36:25 > DEBUG: CheckPoint record at (0, 8) > DEBUG: Redo record at (0, 8); Undo record at (0, 8); Shutdown TRUE > DEBUG: NextTransactionId: 514; NextOid: 16384 > DEBUG: database system was not properly shut down; automatic recovery in > progress... > FATAL 2: cannot open pg_log: No such file or directory > > initdb failed. > Removing temp file /tmp/initdb.8499. > bash-2.04$ > > Wht does the this error mean? > ERROR: Error: unknown type 'ame'.
Ok, I found the problem. There are two buggy files in this package coming from postgress. The files global1.bki.source and local1_template1.bki.source contain a few lines like proname = ame but that should be proname = name As a quick fix try cp global1.bki.source global1.orig sed -e "s:= ame:= name:" global1.orig > global1.bki.source same for local1... Then initdb should work. At least it worked here after that fix. I update the package at the moment, so that problem is fixed in postgresql-7.0.3-r1. Bye Achim
> > > Any comments? > _______________________________________________ > gentoo-dev mailing list > gentoo-dev@g.o > http://www.gentoo.org/mailman/listinfo/gentoo-dev