[gentoo-dev] Problem with installing Postgres

[gentoo-dev] Problem with installing Postgres

[Robert Schrem]

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'.

Any comments?

Re: [gentoo-dev] Problem with installing Postgres

[Achim Gottinger]

Robert Schrem wrote:

> Hi, gentoo rocks !

Hi Robert,

Hmm, das postgress paket hat hier glaub ich keiner getestet, ist nur da um php
und gnome-db dagegen zu linken.

Hab das grad mal bei mir getestet und nen segfault bekommen.

Denke daß ich das so in ein zwei Stunden hinbekomme, schicke dir dann das
ebuild-script.

Tschüß Achim

>
>
> 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'.
>
> Any comments?
> _______________________________________________
> gentoo-dev mailing list
> gentoo-dev@gentoo.org
> http://www.gentoo.org/mailman/listinfo/gentoo-dev

Re: [gentoo-dev] Problem with installing Postgres

[Achim Gottinger]

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@gentoo.org
> http://www.gentoo.org/mailman/listinfo/gentoo-dev