function postgis_lib_version() does not exist at character
参考サイト
no pg_hba.conf entry for host "[local]", user "postgres", database "uki2db", SSL off
参考サイト
LOG: database system was shut down at 2010-08-26 07:57:45 UTC
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
ERROR: function postgis_lib_version() does not exist at character 8
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT postgis_lib_version()
ERROR: current transaction is aborted, commands ignored until end of transaction block
STATEMENT: SELECT postgis_lib_version()
vim /etc/postgresql/8.4/main/pg_hba.confで hogedbについてident->trustにかえてみる。
# Database administrative login by UNIX sockets
local all postgres ident
local hogedb hoge trust
pg_hba.confは/var/lib/postgresql/8.4/dataにもあるのでどちらがほんもんだろ。。
参考サイト