7.2beta2 on Mac OS X/Darwin

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

Thanks.

Tara

--
Tara Piorkowski
System Administrator