Thread: can't create a database
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?
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.