populating sql and getting errors

[andrewm659]

I am trying to deploy this on CentOS 7/8 and using a remote postgresql server. I have installed the ip4r package and loaded the extension. I ma using PostgreSQL 11. However I am still getting the following

[root@test123 ~]# psql -h 10.150.10.20 -d nipap -f /opt/NIPAP/nipap/sql/ip_net.plsql
Password: 
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:7: ERROR:  syntax error at or near "%"
LINE 1: COMMENT ON DATABASE %s IS 'NIPAP database - schema version: ...
                            ^
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:9: ERROR:  permission denied to create extension "ip4r"
HINT:  Must be superuser to create this extension.
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:10: ERROR:  permission denied to create extension "hstore"
HINT:  Must be superuser to create this extension.
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:11: ERROR:  permission denied to create extension "citext"
HINT:  Must be superuser to create this extension.
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:13: ERROR:  type "ip_net_plan_type" already exists
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:14: ERROR:  type "ip_net_plan_status" already exists
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:16: ERROR:  type "priority_5step" already exists
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:22: ERROR:  relation "ip_net_asn" already exists
COMMENT
COMMENT
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:45: ERROR:  type "hstore" does not exist
LINE 15:  avps hstore NOT NULL DEFAULT ''
               ^
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:50: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:51: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:53: ERROR:  relation "ip_net_vrf" does not exist
LINE 1: INSERT INTO ip_net_vrf (id, rt, name, description) VALUES (0...
                    ^
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:55: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:56: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:58: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:59: ERROR:  relation "ip_net_vrf__rt__index" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:60: ERROR:  relation "ip_net_vrf__name__index" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:61: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:62: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:63: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:64: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:65: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:66: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:67: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:68: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:69: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:70: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:71: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:72: ERROR:  relation "ip_net_vrf" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:105: ERROR:  type "hstore" does not exist
LINE 23:  avps hstore NOT NULL DEFAULT ''
               ^
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:107: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:109: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:111: ERROR:  relation "ip_net_pool__name__index" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:113: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:114: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:115: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:116: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:117: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:118: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:119: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:120: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:121: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:122: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:123: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:124: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:125: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:126: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:127: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:128: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:129: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:130: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:131: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:132: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:133: ERROR:  relation "ip_net_pool" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:174: ERROR:  type "hstore" does not exist
LINE 29:  avps hstore NOT NULL DEFAULT '',
               ^
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:176: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:178: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:179: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:180: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:181: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:182: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:183: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:184: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:185: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:186: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:187: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:188: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:189: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:190: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:191: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:192: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:193: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:194: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:195: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:196: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:197: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:198: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:199: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:200: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:201: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:202: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:203: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:204: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:206: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:208: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:209: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:210: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:211: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:212: ERROR:  relation "ip_net_plan" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:214: ERROR:  relation "ip_net_plan__vrf_id_prefix__index" does not exist
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:234: ERROR:  relation "ip_net_log" already exists
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:255: ERROR:  relation "ip_net_log__vrf__index" already exists
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:256: ERROR:  relation "ip_net_log__prefix__index" already exists
psql:/opt/NIPAP/nipap/sql/ip_net.plsql:257: ERROR:  relation "ip_net_log__pool__index" already exists
[root@test123 ~]# 

[mpellatt]

Just had this myself - this is due to the hstore and citext PostgreSQL extensions not being available.

You need to install the postgresql-contrib package, which supplies them