Bug #522: Cannot Create Database

Curtis Hermann (curtis(dot)hemann(at)wisdomtools(dot)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 postmaster this 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

Seems a known bug with Mac OS 10.1. Work around: try 7.2beta3.
--
Tatsuo Ishii

> Curtis Hermann (curtis(dot)hemann(at)wisdomtools(dot)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 postmaster this 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

pgsql-bugs(at)postgresql(dot)org writes:
> 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

Apple broke this in 10.1. There is a workaround for their bug in
7.2b3.

regards, tom lane