Hi Postgres Team !

I've been sucessfully using Postgres 7.1.3 on MacOS 10.0.4. Now I
updated to 10.1 (darwin 1.4). I can't create a new database anymore. The
backend hangs up somehow. Here's the log:

DEBUG: database system was shut down at 2001-10-03 15:34:52 CEST
DEBUG: CheckPoint record at (0, 1522656)
DEBUG: Redo record at (0, 1522656); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system is in production state
Server process (pid 6629) exited with status 11 at Wed Oct 3 15:35:20
2001
Terminating any active server processes...
Server processes were terminated at Wed Oct 3 15:35:20 2001
Reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2001-10-03 15:35:08 CEST
DEBUG: CheckPoint record at (0, 1522656)
DEBUG: Redo record at (0, 1522656); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 615; NextOid: 18720
DEBUG: database system was not properly shut down; automatic recovery
in progress...
DEBUG: ReadRecord: record with zero len at (0, 1522720)
DEBUG: redo is not required

Is there any other log file I can look into ? Any known solutions to the
problem ?

What I did :

as postgres user :

initdb -D /var/lib/pgsql (/var/lib/pgsql is owner by user postgres)
createuser mgm (mgm ist me)

as user mgm :

createdb test

I get the message that the backend has died (see above).

Ideas ?

Another thing :

I tried to recompile the whole thing. But since OS 10.1 ld is switched
to two_level_namespaces (don't know exactly what it means) but you need
to change the Makefile.darwin to add the -flat_namespace switch somehow.
But even with the newly compiled version it behaves just as noted above.

Greetings

Moritz

Search Discussions

  • Scott W. Hill at Oct 4, 2001 at 6:40 pm
    I have tried compiling Postgres under 10.1, with the -flat_namespace
    switch, but am still having other problems. I'll post if I get past
    them. I've stopped trying for right now, since I found a .pkg with int
    built under 10.1 at <http://www.entropy.ch/software/macosx/postgresql/>.
    It has a disclaimer that it hasn't been tested, but it seems to be
    working fine for me. YMMV.

    --Scott
    On Wednesday, October 3, 2001, at 08:10 AM, Moritz Gmelin wrote:

    Hi Postgres Team !

    I've been sucessfully using Postgres 7.1.3 on MacOS 10.0.4. Now I
    updated to 10.1 (darwin 1.4). I can't create a new database anymore.
    The backend hangs up somehow. Here's the log:

    DEBUG: database system was shut down at 2001-10-03 15:34:52 CEST
    DEBUG: CheckPoint record at (0, 1522656)
    DEBUG: Redo record at (0, 1522656); Undo record at (0, 0); Shutdown
    TRUE
    DEBUG: NextTransactionId: 615; NextOid: 18720
    DEBUG: database system is in production state
    Server process (pid 6629) exited with status 11 at Wed Oct 3 15:35:20
    2001
    Terminating any active server processes...
    Server processes were terminated at Wed Oct 3 15:35:20 2001
    Reinitializing shared memory and semaphores
    DEBUG: database system was interrupted at 2001-10-03 15:35:08 CEST
    DEBUG: CheckPoint record at (0, 1522656)
    DEBUG: Redo record at (0, 1522656); Undo record at (0, 0); Shutdown
    TRUE
    DEBUG: NextTransactionId: 615; NextOid: 18720
    DEBUG: database system was not properly shut down; automatic recovery
    in progress...
    DEBUG: ReadRecord: record with zero len at (0, 1522720)
    DEBUG: redo is not required

    Is there any other log file I can look into ? Any known solutions to
    the problem ?

    What I did :

    as postgres user :

    initdb -D /var/lib/pgsql (/var/lib/pgsql is owner by user postgres)
    createuser mgm (mgm ist me)

    as user mgm :

    createdb test

    I get the message that the backend has died (see above).

    Ideas ?

    Another thing :

    I tried to recompile the whole thing. But since OS 10.1 ld is switched
    to two_level_namespaces (don't know exactly what it means) but you need
    to change the Makefile.darwin to add the -flat_namespace switch somehow.
    But even with the newly compiled version it behaves just as noted above.

    Greetings

    Moritz


    ---------------------------(end of broadcast)---------------------------
    TIP 3: if posting/reading through Usenet, please send an appropriate
    subscribe-nomail command to [email protected] so that your
    message can get through to the mailing list cleanly

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedOct 3, '01 at 3:24p
activeOct 4, '01 at 6:40p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Moritz Gmelin: 1 post Scott W. Hill: 1 post

People

Translate

site design / logo © 2023 Grokbase