PostgreSQL初始化报错

90 views
Skip to first unread message

Richard Chen

unread,
Dec 9, 2014, 4:21:58 AM12/9/14
to tdw-...@googlegroups.com
psql -h 127.0.0.1 -p 5432 -U postgres postgres -f qe/script/tdw_meta_init.sql
SET
SET
CREATE ROLE
psql:qe/script/tdw_meta_init.sql:14: ERROR:  syntax error at or near "NOREPLICATION"
LINE 1: ...NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICAT...
                                                             ^
CREATE ROLE
psql:qe/script/tdw_meta_init.sql:18: ERROR:  syntax error at or near "NOREPLICATION"
LINE 1: ...NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICAT...
                                                             ^
CREATE ROLE
psql:qe/script/tdw_meta_init.sql:23: ERROR:  syntax error at or near "NOREPLICATION"
LINE 1: ...NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICAT...
                                                             ^
CREATE DATABASE
CREATE DATABASE
CREATE DATABASE
CREATE DATABASE
REVOKE
GRANT
psql (8.4.20)
You are now connected to database "global".
SET
SET
SET
SET
SET
psql:qe/script/tdw_meta_init.sql:53: ERROR:  syntax error at or near "EXTENSION"
LINE 1: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalo...
               ^
psql:qe/script/tdw_meta_init.sql:60: ERROR:  syntax error at or near "EXTENSION"
LINE 1: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural languag...
                   ^
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
psql:qe/script/tdw_meta_init.sql:133: ERROR:  type "int4range" does not exist
LINE 3:     seg_accept_range int4range
                             ^
psql:qe/script/tdw_meta_init.sql:136: ERROR:  relation "public.seg_split" does not exist
psql:qe/script/tdw_meta_init.sql:138: ERROR:  relation "seg_split" does not exist
LINE 1: insert into seg_split values('jdbc:postgresql://127.0.0.1:54...
                    ^
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE VIEW
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
psql:qe/script/tdw_meta_init.sql:321: ERROR:  relation "seg_split" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
REVOKE
GRANT
psql (8.4.20)
You are now connected to database "pbjar".
SET
SET
SET
SET
SET
psql:qe/script/tdw_meta_init.sql:399: ERROR:  syntax error at or near "EXTENSION"
LINE 1: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalo...
               ^
psql:qe/script/tdw_meta_init.sql:406: ERROR:  syntax error at or near "EXTENSION"
LINE 1: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural languag...
                   ^
SET
SET
SET
CREATE TABLE
ALTER TABLE
ALTER TABLE
REVOKE
GRANT
psql (8.4.20)
You are now connected to database "seg_1".
SET
SET
SET
SET
SET
psql:qe/script/tdw_meta_init.sql:466: ERROR:  syntax error at or near "EXTENSION"
LINE 1: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalo...
               ^
psql:qe/script/tdw_meta_init.sql:473: ERROR:  syntax error at or near "EXTENSION"
LINE 1: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural languag...
                   ^
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
REVOKE
GRANT
psql (8.4.20)
You are now connected to database "template1".
SET
SET
SET
SET
SET
COMMENT
psql:qe/script/tdw_meta_init.sql:759: ERROR:  syntax error at or near "EXTENSION"
LINE 1: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalo...
               ^
psql:qe/script/tdw_meta_init.sql:766: ERROR:  syntax error at or near "EXTENSION"
LINE 1: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural languag...
                   ^
REVOKE
GRANT
psql (8.4.20)
You are now connected to database "tdw".
SET
SET
SET
SET
SET
CREATE SCHEMA
ALTER SCHEMA
psql:qe/script/tdw_meta_init.sql:796: ERROR:  syntax error at or near "database"
LINE 1: alter role tdw in database tdw set search_path='tdw';
                          ^
SET
psql:qe/script/tdw_meta_init.sql:805: ERROR:  syntax error at or near "EXTENSION"
LINE 1: CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalo...
               ^
psql:qe/script/tdw_meta_init.sql:812: ERROR:  syntax error at or near "EXTENSION"
LINE 1: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural languag...
                   ^
CREATE TABLE
ALTER TABLE
ALTER TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX

Jov

unread,
Dec 9, 2014, 5:15:57 AM12/9/14
to Richard Chen, tdw-...@googlegroups.com
rt


2014-12-09 18:11 GMT+08:00 Jov <am...@amutu.com>:
查看一下你PG的版本，TDW要求PG 9.2及以上版本


--
您收到此邮件是因为您订阅了Google网上论坛上的“TDW邮件列表”群组。
要退订此群组并停止接收此群组的电子邮件，请发送电子邮件到tdw-user+u...@googlegroups.com。
要查看更多选项，请访问https://groups.google.com/d/optout。


Jov

unread,
Dec 9, 2014, 5:16:11 AM12/9/14
to Richard Chen, tdw-...@googlegroups.com
rt

Richard Chen

unread,
Dec 9, 2014, 5:18:56 AM12/9/14
to tdw-...@googlegroups.com, whug...@gmail.com
多谢，把CENTOS 6.5自带的 postgresql 卸载，安装9.3版的 就解决了~~

hive终于可以用了~~
rt
查看一下你PG的版本，TDW要求PG 9.2及以上版本

--
您收到此邮件是因为您订阅了Google网上论坛上的“TDW邮件列表”群组。
要退订此群组并停止接收此群组的电子邮件，请发送电子邮件到tdw-user+unsubscribe@googlegroups.com。
要查看更多选项，请访问https://groups.google.com/d/optout。


Reply all
Reply to author
Forward
0 new messages