can't create a database

rdacker@pacbell.net (rdack) wrote in message news:<644f6688.0110171613.20bd49f6@posting.google.com>...

everything else seems ok. add tables, add records.
but when i try 'create database tt;' interactively or do 'createdb tt'
in shell, i get:
Server process (pid 446) exited with status 11 at Wed Oct 17 17:04:06
2001
Terminating any active server processes...
Server processes were terminated at Wed Oct 17 17:04:06 2001
Reinitializing shared memory and semaphores
DEBUG: database system was interrupted at 2001-10-17 17:01:24 PDT
DEBUG: CheckPoint record at (0, 2271516)
DEBUG: Redo record at (0, 2271516); Undo record at (0, 0); Shutdown
TRUE
DEBUG: NextTransactionId: 797; NextOid: 67890
DEBUG: database system was not properly shut down; automatic recovery
in progress...
DEBUG: ReadRecord: record with zero len at (0, 2271580)
DEBUG: redo is not required
DEBUG: database system is in production state

the folder 67890 is created with a lot of files, but new db isn't in
system catalog. next time i try to create a db with a different name
shell says:
ERROR: CREATE DATABASE: unable to create database directory
'/usr/local/pgsql/data/base/67890': File exists
createdb: database creation failed

any one have a clue?

after more digging, i found a post that said it was a problem after
upgrading to OS 10.1 and there is a new package for downloading for
10.1 with a patch. it is at:
http://www.entropy.ch/software/macosx/postgresql/

rdacker@pacbell.net (rdack) writes:

everything else seems ok. add tables, add records.
but when i try 'create database tt;' interactively or do 'createdb tt'
in shell, i get:
Server process (pid 446) exited with status 11 at Wed Oct 17 17:04:06
2001

Hmm. This should have left a core dump file --- can you get a stack
trace from the core with a debugger?

Also, problem reports that don't mention Postgres version nor the
platform you are running on are not very helpful.

regards, tom lane

tgl@sss.pgh.pa.us (Tom Lane) wrote in message news:<25222.1003432303@sss.pgh.pa.us>...

rdacker@pacbell.net (rdack) writes:

everything else seems ok. add tables, add records.
but when i try 'create database tt;' interactively or do 'createdb tt'
in shell, i get:
Server process (pid 446) exited with status 11 at Wed Oct 17 17:04:06
2001

Hmm. This should have left a core dump file --- can you get a stack
trace from the core with a debugger?

Also, problem reports that don't mention Postgres version nor the
platform you are running on are not very helpful.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

answer was to get latest postgresql package that works on os 10.1.