Bug #522: Cannot Create Database

Started by PostgreSQL Bugs Listover 24 years ago3 messagesbugs
Jump to latest
#1PostgreSQL Bugs List
pgsql-bugs@postgresql.org

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

#2Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #522: Cannot Create Database

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

Show quoted text

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 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@postgresql.org so that your
message can get through to the mailing list cleanly

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: PostgreSQL Bugs List (#1)
Re: Bug #522: Cannot Create Database

pgsql-bugs@postgresql.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