Skip site navigation (1) Skip section navigation (2)

initdb segfaulting.

From: Rudy Lippan <rlippan(at)remotelinux(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: initdb segfaulting.
Date: 2002-12-12 03:21:54
Message-ID: Pine.LNX.4.44.0212112123170.7114-100000@elfride.ineffable.net (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Rudolf Lippan
Your email address      : rlippan(at)remotelinux(dot)com


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : PII-400x4

  Operating System (example: Linux 2.0.26 ELF)  : 2.4.19-gentoo-r9

  PostgreSQL version (example: PostgreSQL-7.3):   PostgreSQL-7.3

  Compiler used (example:  gcc 2.95.2)          : gcc 2.95.3


Please enter a FULL description of your problem:
------------------------------------------------

initdb (postmaster) segfaults.  It seems that if I don't set the system's
timezone, postmaster does a li'le fandango on core.  Pg 7.2.3 work fine.



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

postgres(at)war PGDATA $ date
Sat Dec 14 02:12:00 Local time zone must be set--see zic manual page 2002

And run initdb.  Here is output from both runs of initdb:


postgres(at)war PGDATA $ ../pgsql7.3/bin/initdb
The files belonging to this database system will be owned by user 
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/PGDATA/pgsql7.3... ok
creating directory /usr/local/PGDATA/pgsql7.3/base... ok
creating directory /usr/local/PGDATA/pgsql7.3/global... ok
creating directory /usr/local/PGDATA/pgsql7.3/pg_xlog... ok
creating directory /usr/local/PGDATA/pgsql7.3/pg_clog... ok
creating template1 database in /usr/local/PGDATA/pgsql7.3/base/1... 
../pgsql7.3/bin/initdb: line 582:  9491 Segmentation fault      
"$PGPATH"/postgres -boot -x1 $PGSQL_OPT $BACKEND_TALK_ARG template1

initdb failed.
Removing /usr/local/PGDATA/pgsql7.3.



==============
postgres(at)war PGDATA $ TZ=EST ../pgsql7.3/bin/initdb
The files belonging to this database system will be owned by user 
"postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/PGDATA/pgsql7.3... ok
creating directory /usr/local/PGDATA/pgsql7.3/base... ok
creating directory /usr/local/PGDATA/pgsql7.3/global... ok
creating directory /usr/local/PGDATA/pgsql7.3/pg_xlog... ok
creating directory /usr/local/PGDATA/pgsql7.3/pg_clog... ok
creating template1 database in /usr/local/PGDATA/pgsql7.3/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

    ../pgsql7.3/bin/postmaster -D /usr/local/PGDATA/pgsql7.3
or
    ../pgsql7.3/bin/pg_ctl -D /usr/local/PGDATA/pgsql7.3 -l logfile start



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------





Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-12-12 04:58:18
Subject: Re: initdb segfaulting.
Previous:From: Joe ConwayDate: 2002-12-11 18:18:08
Subject: Re: ON DELETE triggers don't work as documented

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group