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

7.2beta2 on Mac OS X/Darwin

From: Tara Piorkowski <tara(at)vilaj(dot)com>
To: pgsql-ports(at)postgresql(dot)org
Subject: 7.2beta2 on Mac OS X/Darwin
Date: 2001-11-09 17:21:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-ports
                         POSTGRESQL BUG REPORT TEMPLATE

Your name               : Tara Piorkowski
Your email address      : tara(at)vilaj(dot)com

System Configuration
   Architecture (example: Intel Pentium)         : PowerPC

   Operating System (example: Linux 2.0.26 ELF)  : Mac OS X 10.1

   PostgreSQL version (example: PostgreSQL-7.1.1): PostgreSQL-7.2beta2

   Compiler used (example:  gcc 2.95.2)          : Apple Computer, Inc. 
version gcc-932.1, based on gcc version 2.95.2 19991024 (release)

Please enter a FULL description of your problem:

PgSQL 7.2beta2 compiles and installs fine, as did beta1. Furthermore, 
initdb works okay, it starts up okay (which I don't recall was the case 
with beta1), users can be created and the template1 system tables can be 
browsed with psql. However, I am unable to create any new tables. Here's 
what I get...

[tara:~] tara% /opt/pgsql-test/bin/createdb junk2
server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
connection to server was lost
createdb: database creation failed

Here's what the logs show...

DEBUG:  reaping dead processes
DEBUG:  CleanupProc: child process (pid 9125) exited with exit code 0
DEBUG:  BackendStartup: forked pid=9137 socket=62
/opt/pgsql-test/bin/postmaster child[9137]: starting with (postgres -d4 
-v131072 -p template1 )
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: CREATE DATABASE "junk2"
DEBUG:  parse tree: { QUERY :command 5  :utility ?  :resultRelation 0 
:into <> :isPortal false :isBinary false :isTemp false :hasAggs false
:hasSubLinks false :rtable <> :jointree <> :rowMarks () :targetList <> 
:groupClause <> :havingQual <> :distinctClause <> :sortClause <> :lim
itOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessUtility: CREATE DATABASE "junk2"
DEBUG:  reaping dead processes
DEBUG:  CleanupProc: child process (pid 9137) was terminated by signal 11
DEBUG:  server process (pid 9137) was terminated by signal 11
DEBUG:  terminating any other active server processes
DEBUG:  all server processes terminated; reinitializing shared memory 
and semaphores
DEBUG:  shmem_exit(0)
invoking IpcMemoryCreate(size=1417216)
DEBUG:  database system was interrupted at 2001-11-09 12:07:03 EST
DEBUG:  checkpoint record is at 0/119550
DEBUG:  redo record is at 0/119550; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 104; next oid: 16556
DEBUG:  database system was not properly shut down; automatic recovery 
in progress
DEBUG:  ReadRecord: record with zero length at 0/119590
DEBUG:  redo is not required
DEBUG:  database system is ready
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes

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

The problem is entirely repeatable. See above.

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

Don't know. Willing to look into it (with limited knowledge), but wanted 
to see if someone was aware and/or working on the issue. I know someone 
prepared patches for 7.1.3 that worked beautifully.



Tara Piorkowski
System Administrator


pgsql-ports by date

Next:From: Igor KovalenkoDate: 2001-11-09 21:05:38
Subject: QNX6 port (need some assistance from developers)
Previous:From: Tom LaneDate: 2001-11-06 19:04:40
Subject: Re: QNX4-Patch

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