Amazon RDS for PostgreSQL

Installing FlexDeploy version 6.0.0.2 or later is supported on Amazon RDS for PostgreSQL. But if you are migrating from earlier versions, then read further below.

If you migrate to Amazon RDS for PostgreSQL from another database with FlexDeploy 6.0.0.1 or older, you will need to run an additional grant.

grant fd_admin to CURRENT_USER;

Nutanix

In some Database SaaS environment like Nutanix, the following grants may also be required. If you are receiving errors like “permission denied for schema fd”, then these additional grants should be executed:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA FD_ADMIN TO FD_ADMIN;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA FD_ADMIN TO FD_ADMIN;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA FD TO FD_ADMIN;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA FD TO FD_ADMIN;

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA FF TO FD_ADMIN;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA FF TO FD_ADMIN;

In addition, in many SaaS environment, the admins are not given access to the user postgres. If migrating from an on-prem server to a SaaS solution, make sure that all tables are owned by a user in your SaaS environment that has super user privileges. Here is a query that can be used to determine who owns the table:

select tableowner, schemaname, tablename from pg_catalog.pg_tables where schemaname in ('fd','ff');

The tableowner column is the owner of the table and in order to run some of the required FlexDeploy grants, you will need to have access to the tableowner user. If it is postgres or a user that you do not have access to, then you may need to change the owner by running an alter like this:

ALTER TABLE <tablename> OWNER TO <username>

FlexDeploy 6.0

FlexDeploy with Cloud Database Services

Amazon RDS for PostgreSQL

Nutanix

Related content