在Amazon RDS上安装PostGIS(Installing PostGIS on Amazon RDS)

 我正在尝试从AWS文档中遵循本指南： http ： //docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html#Appendix.PostgreSQL.CommonDBATasks.PostGIS 
 
 在“步骤2：加载PostGIS扩展”中，在它显示的文档(4 rows)但有三行。 到目前为止，我自己运行相同的命令，我看到四行，文档中缺少的行是tiger_data 。 在第3步中， tiger_data所有权tiger_data应该给rds_superuser？ 
 
 在“步骤4：将对象的所有权转移到rds_superuser角色”中，我使用文档中提供的查询时出现语法错误，我不知道该怎么做： 
 
postgres=> CREATE FUNCTION exec(text) returns text language plpgsql volatile AS $f$ BEGIN EXECUTE $1; RETURN $1; END; $f$;
CREATE FUNCTION
postgres=> SELECT exec('ALTER TABLE ' || quote_ident(s.nspname) || '.' || quote_ident(s.relname) || ' OWNER TO rds_superuser,')
postgres->   FROM (
postgres(>     SELECT nspname, relname
postgres(>     FROM pg_class c JOIN pg_namespace n ON (c.relnamespace = n.oid)
postgres(>     WHERE nspname in ('tiger','topology') AND
postgres(>     relkind IN ('r','S','v') ORDER BY relkind = 'S')
postgres-> s;
ERROR:  syntax error at end of input
LINE 1: ALTER TABLE tiger.loader_variables OWNER TO rds_superuser,
                                                                  ^
QUERY:  ALTER TABLE tiger.loader_variables OWNER TO rds_superuser,
CONTEXT:  PL/pgSQL function exec(text) line 1 at EXECUTE statement

I am trying to follow this guide from AWS docs: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html#Appendix.PostgreSQL.CommonDBATasks.PostGIS
 
On "Step 2: Load the PostGIS extensions", in the docs it shows (4 rows) but there are three rows there. Running the same commands myself up to that point, I see four rows, and the row that was missing from the docs is tiger_data. In Step 3, should ownership of tiger_data be given to rds_superuser as well?
 
In "Step 4: Transfer ownership of the objects to the rds_superuser role", I'm getting a syntax error from using the query provided in the docs and I don't know what to do about this:
 
postgres=> CREATE FUNCTION exec(text) returns text language plpgsql volatile AS $f$ BEGIN EXECUTE $1; RETURN $1; END; $f$;
CREATE FUNCTION
postgres=> SELECT exec('ALTER TABLE ' || quote_ident(s.nspname) || '.' || quote_ident(s.relname) || ' OWNER TO rds_superuser,')
postgres->   FROM (
postgres(>     SELECT nspname, relname
postgres(>     FROM pg_class c JOIN pg_namespace n ON (c.relnamespace = n.oid)
postgres(>     WHERE nspname in ('tiger','topology') AND
postgres(>     relkind IN ('r','S','v') ORDER BY relkind = 'S')
postgres-> s;
ERROR:  syntax error at end of input
LINE 1: ALTER TABLE tiger.loader_variables OWNER TO rds_superuser,
                                                                  ^
QUERY:  ALTER TABLE tiger.loader_variables OWNER TO rds_superuser,
CONTEXT:  PL/pgSQL function exec(text) line 1 at EXECUTE statement

原文：https://stackoverflow.com/questions/34925400