7.2beta2 on Mac OS X/Darwin

============================================================================
                         POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Tara Piorkowski
Your email address      : tara@vilaj.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.

Thanks.

Tara

--
Tara Piorkowski
System Administrator