Seems a known bug with Mac OS 10.1. Work around: try 7.2beta3.
--
Tatsuo Ishii
> Curtis Hermann (curtis.hemann@wisdomtools.com) reports a bug with a severity of 1
> The lower the number the more severe it is.
>
> Short Description
> Cannot Create Database
>
> Long Description
> I am on Mac OS 10.1. Every time I try to create a database I get the following error:
> [localhost:~] postgres% createdb curtis_test
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> connection to server was lost
> createdb: database creation failed
>
> All other functionality like connecting to template1 or initdb seems to be functioning correctly. When I start
postmasterthis is what I get:
> [localhost:~] postgres% /usr/local/bin/postmaster -D /usr/local/pgsql/data
> DEBUG: database system was shut down at 2001-11-26 10:50:24 CST
> DEBUG: CheckPoint record at (0, 1530864)
> DEBUG: Redo record at (0, 1530864); Undo record at (0, 0); Shutdown TRUE
> DEBUG: NextTransactionId: 624; NextOid: 26912
> DEBUG: database system is in production state
>
>
> Thanks very much,
> Curtis P. Hermann
>
> Sample Code
> [localhost:~] postgres% createdb curtis_test
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> connection to server was lost
> createdb: database creation failed
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>