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
