Forum OpenACS Q&A: Re: RDBMS type could not be determined for any pool

Collapse
10: Re: RDBMS type could not be determined for any pool (response to 1)
Posted by Dave Bauer on 02/02/06 07:03 PM
Did you read the messagess on the install page?

[22/Jan/2006:17:19:28][26846.3086924000][-main-] Error: Ns_PgExec: result status: 7 message: ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.

This shows plpgsql is not installed in your database.

createlang plpgsql dbname

will fix it.

Collapse
11: Re: Re: RDBMS type could not be determined for any pool (response to 10)
Posted by anjali n on 02/02/06 08:22 PM
plpgsql is installed and i am able to create database.I got this error when i had just started .Now i can create and drop database successfully..
i had given createlang plpgsql template1.here's the server.log file of postgres

FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another postmaster (PID 29594) using socket file "
/tmp/.s.PGSQL.5432"?
FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another postmaster (PID 29594)
using socket file "/tmp/.s.PGSQL.5432"?
FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another
postmaster (PID 29594) using socket file "/tmp/.s.PGSQL.5432"?
FATAL: data directory "/usr/local/pgsql/data" does not
exist
LOG: database system was shut down at 2006-01-23 10:41:51 IST
LOG: checkpoint record is at 0/9B1058
LOG: redo
record is at 0/9B1058; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 536; next OID: 17142
LOG:
database system is ready
ERROR: syntax error at or near "createfunction" at character 1
FATAL: database
"" does not exist
FATAL: database "my_server" does not exist
FATAL:
lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT: Is another postmaster (PID 2812) using socket file
"/tmp/.s.PGSQL.5432"?
FATAL: "/usr/local/pgsql/data" is not a valid data directory
DETAIL:
File "/usr/local/pgsql/data/PG_VERSION" is missing.
FATAL: lock file "/tmp/.s.PGSQL.5432.lock" already exists
HINT:
Is another postmaster (PID 2812) using socket file "/tmp/.s.PGSQL.5432"?
FATAL: lock file "/tmp/.s.PGSQL.5432.lock"
already exists
HINT: Is another postmaster (PID 2812) using socket file "/tmp/.s.PGSQL.5432"?
FATAL:
"/usr/local/pgsql/data" is not a valid data directory
DETAIL: File "/usr/local/pgsql/data/PG_VERSION" is missing.
FATAL:
"/usr/local/pgsql/data" is not a valid data directory
DETAIL: File "/usr/local/pgsql/data/PG_VERSION" is missing.
FATAL:
"/usr/local/pgsql/data" is not a valid data directory
DETAIL: File "/usr/local/pgsql/data/PG_VERSION" is missing.
LOG:
unexpected EOF on client connection
LOG: received smart shutdown request
LOG: shutting down
LOG: could not open "/usr/
local/pgsql/data/base/17145/1255": No such file or directory
CONTEXT: writing block 64 of relation 17145/1255
PANIC: c
ould not write block 64 of 17145/1255 blind: No such file or directory
CONTEXT:
writing block 64 of relation 17145/1255
LOG: shutdown process (PID 19637) was terminated by signal 6

Collapse
12: Re: Re: RDBMS type could not be determined for any pool (response to 10)
Posted by anjali n on 02/03/06 10:51 AM
createlang: language "plpgsql" is already installed in database "my_server_name"

This (RDBMS type could not be determined for any pool)
is the only error i'm getting..I am not able to figure out as to what error it is.
please help....