Skip to main content
Skip table of contents

PostgreSQL mQE

Version

Date

Issue

Note

370

MIG-26077

Added support for scanning PostgreSQL 15 sources with migVisor Metadata Collector.

369

MIG-25592

Maintenance release

368

MIG-19207

Maintenance release

367

MIG-16676

Maintenance release

366

MIG-15681

Added queries to identify the following features:

List of new features in this release

1. Function Executing as DEFINER User – Identifies functions with security definer.

2. Functions Written in C – Identifies functions that are written in C.

3. Unsupported AlloyDB Extension – Identifies the usage of extensions that are unsupported by AFPS.

Added queries to identify the following features for AlloyDB migration insights:

List of new features in this release

1. AWS SCT Extension – Identifies the presence of the AWS SCT extension pack.

2. Large Object Data – Identifies the presence of the Large Object data type.

3. Max Database Size – Identifies when the maximum storage limit per cluster has been exceeded.

4. Read Replica as Source – Identifies the usage of a read replica as a source.

5. Trigger During Replication – Identifies triggers that are set to fire always, or on a replica.

6. Users and Roles – Identifies information about users and roles.

365

MIG-12775

Added queries to gather PostgreSQL workload.

List of new features in this release

1. CPU Time % for query execution

2. Current allocated memory (Bytes)

3. Commit ratio

4. Extended Connections waiting for a lock

5. Maximum Transaction Age

6. Number Of rows INSERTED

7. Number Of rows UPDATED

8. Number Of rows DELETED

9. Number of queries

10. Transactions count

364

MIG-10845

Added queries to determine "Read IOPS" and "Write IOPS" metrics.

List of new features in this release

1. Physical Read IOPS

2. Physical Write IOPS

363
(aka v11)

MIG-7689

Adjusted the Unsupported Extension query to exclude generally available extensions.

List of extensions to exclude

1. pg_bigm – Enables full text search and allows a two-gram (bigram) index for faster full text search.

2. refint – Enables the checking of foreign key restraints, the referencing table, and the referenced table.

3. decoderbufs – A logical decoder that delivers output data as Protocol Buffers, adapted for Debezium.

4. pg_wait_sample – Collects sampling statistics of wait events, providing wait event data for processes on servers.

362
(aka v10)

MIG-7363

Added a new CDC query to identify if logical replication is enabled and publications created for tables to provide Change Data Capture capability.

361
(aka v9)

MIG-6980

Adjusted queries to return a list of objects instead of counters.

List of affected features in this release

1. Foreign Key Constraint

2. UNIQUE Constraint

3. CHECK Constraint

4. Block-range (BRIN) index

5. Generalized Inverted Index (GIN) 

6. GiST index

7. SP-GiST index

8. Hash index

9. Temporary Table

10. BTree Indexes

360
(aka v8)

MIG-6787

Adjusted the GCP unsupported settings query by adding a session_replication_role flag into the list of supported flags. This flag allows disabling constraint triggers in individual logical replication sessions.

359
(aka v7)

AP-392

Maintenance release

358
(aka v6)

INT-158

Added queries to identify the following features:

List of new features in this release

1. Big Integer Data Type – Identifies tables with Big Integer data type.
2. Big Serial Data Type – Identifies tables with Big Serial data type.
3. Bit String Data Type – Identifies tables with Bit String data type.
4. Boolean Data Type – Identifies tables with Boolean data type.
5. Box Data Type – Identifies tables with Box data type.
6. Character Data Types – Identifies tables with Character data type.
7. CIDR Data Type – Identifies tables with CIDR data type.
8. Circle Data Type – Identifies tables with Circle data type.
9. Date Data Type – Identifies tables with Date data type.
10. ARRAY Data Types – Identifies tables with ARRAY data types.
11. INET Data Type – Identifies tables with INET data type.
12. Integer Data Type – Identifies tables with Integer data type.
13. Small Integer Data Type – Identifies tables with Small Integer data type.
14. Small Serial Data Type – Identifies tables with Small Serial data type.
15. Serial Data Type – Identifies tables with Serial data type.
16. Interval Data Type – Identifies tables with Interval data type.
17. JSON Data Type – Identifies tables with JSON data type.
18. JSONB Data Type – Identifies tables with JSONB data type.
19. Line Data Type – Identifies tables with Line data type.
20. Line segments Data Type – Identifies tables with Line segments data type.
21. Mac address Data Type – Identifies tables with Mac address data type.
22. Monetary Data Type – Identifies tables with Monetary data type.
23. Numeric/Decimal Data Types – Identifies tables with Numeric/Decimal data types.
24. Path Data Type – Identifies tables with Path data type.
25. Log Sequence Number Data Type – Identifies tables with Log Sequence Number data type.
26. Point Data Type – Identifies tables with Point data type.
27. Polygon Data Type – Identifies tables with Polygon data type.
28. Real Data Type – Identifies tables with Real data type.
29. Time without time zone – Identifies tables with Time data type without time zone semantics.
30. Time with time zone – Identifies tables with Time data type containing time zone semantics.
31. Timestamp without time zone – Identifies tables with Timestamp data type without time zone semantics.
32. Timestamp with time zone – Identifies tables with Timestamp data type containing time zone semantics.
33. Text Search Data Types – Identifies tables with Text Search data types.
34. Txid Snapshot – Identifies tables with Txid Snapshot.
35. GUID/UUID Data Type – Identifies tables with GUID/UUID data type.
36. Multiranges Data Types – Identifies tables with Multiranges data types.
37. Range Data Types – Identifies tables with Range data types.
38. Enumerated Data Type – Identifies tables with Enumerated data type.
39. Object Identifier Type – Identifies tables with Object Identifier type.
40. Foreign Key Constraint – Identifies Foreign Key Constraint count.
41. UNIQUE Constraint – Identifies UNIQUE Constraint count.
42. CHECK Constraint – Identifies CHECK Constraint count.
43. Block-range (BRIN) index – Identifies Block-range (BRIN) index count.
44. Generalized Inverted Index (GIN) – Identifies Generalized Inverted Index (GIN) count.
45. GiST index – Identifies GiST index count.
46. SP-GiST index – Identifies SP-GiST index count.
47. Hash index – Identifies Hash index count.
48. ASC | DESC in View – Identifies view that is created with ASC | DESC.
49. UNION ALL in View – Identifies view that is created with UNION ALL.
50.ROW_NUMBER() Function in View – Identifies view that is created with ROW_NUMBER() function.
51. Data Encryption – Identifies view that is created with Data Encryption.
52. Decode() Function in View – Identifies view that is created with Decode() function.
53. Encode() Function in View – Identifies view that is created with Encode() function.
54. btrim String Function in View – Identifies view that is created with btrim String function.
55. greatest() Function in View – Identifies view that is created with greatest() function.
56. least() Function in View – Identifies view that is created with least() function.
57. now() Function in View – Identifies view that is created with now() function.
58. to_timestamp Function in View – Identifies view that is created with to_timestamp function.
59. bool_and Function in View – Identifies view that is created with bool_and function.
60. bool_or Function in View – Identifies view that is created with bool_or function.
61. every() Aggregate Function – Identifies view that is created with every() Aggregate function.
62. LATERAL Clause in View – Identifies view that is created with LATERAL Clause.
63. SEARCH Keyword in View – Identifies view that is created with SEARCH Keyword.
64. CYCLE Keyword in View – Identifies view that is created with CYCLE Keyword.
65. Database Links Extension – Identifies Database Links Extension.
66. Temporary Table – Identifies Temporary Table count.
67. GROUPING SETS support in View – Identifies view that is created with GROUPING SETS support.
68. CUBE support in View – Identifies view that is created with CUBE support.
69. ROLLUP support in View – Identifies view that is created with ROLLUP support.
70. NULLS FIRST/LAST in View – Identifies view that is created with NULLS FIRST/LAST.
71. WITHIN GROUP clause in View – Identifies view that is created with WITHIN GROUP clause.
72. WITH ORDINALITY clause in View – Identifies view that is created with WITH ORDINALITY clause.
73. Full Text Search in View – Identifies view that is created with Full Text Search.
74. WITH CHECK clause in View – Identifies view that is created with WITH CHECK clause.
75. SCRAM-SHA-256 Authentication – Identifies SCRAM-SHA-256 Authentication is enable or not.
76. SSL support – Identifies if SSL is enabled on the source database.
77. Databases per Instance – Identifies databases per instance count when it is more than 100.
78. Spanner View Count Limit – Identifies views per database count when it is more than 5000.
79. Spanner View Name Length Limit – Identifies views count where views name length are more than 128 characters.
80. Spanner Indexes per Database – Identifies indexes per database count when it is more than 10,000.
81. Spanner Indexes per Table – Identifies index count of each table and table name where index count is more than 32 in each table.
82. Spanner Index Name Length – Identifies index count when index name length is more than 128 characters.
83. Spanner Tables per Database – Identifies tables per database count when it is more than 5000.
84. Spanner Table Name Length – Identifies tables count where tables name length are more than 128 characters.
85. Spanner Columns per Table – Identifies columns per table count when it is more than 1024 in table.
86. Spanner Column Name Length – Identifies columns count where columns name length are more than 128 characters.
87. Toast Tables – Identifies Toast Tables count.
88. Archive Mode – Identifies if archive_mode parameter is enabled.
89. Autovacuum – Identifies if autovacuum parameter is enabled.
90. Block Size – Identifies Block Size.
91. Incremental Sort – Identifies if enable_incremental_sort parameter is enabled. The parameter enables or disables the query planner's use of incremental sort steps.
92. Maximum Index keys number – Identifies Maximum Index keys number.
93. Maximum Identifier length – Identifies Maximum Identifier length.
94. Installed PostgreSQL Extension – Identifies Installed PostgreSQL extension.
95. Spanner Index Key Size – Identifies tables and index key total size where it is greater than 8k.
96. Spanner Columns Per Index Key – Identifies table name where the number of indexed columns more than 16.
97. Spanner Columns Per Table Key – Identifies table name where the number of primary key and foreign key columns more than 16.

357
(aka v5)

AP-387

Adjusted the GCP unsupported setting query to exclude the following newly supported parameters from the list of unsupported ones:

List of newly supported parameters

1. max_parallel_maintenance_workers – Sets the maximum number of parallel workers that can be started by a single utility command.
2. max_parallel_workers – Sets the maximum number of workers that the system can support for parallel operations.
3. max_parallel_workers_per_gather – Sets the maximum number of workers that can be started by a single Gather or Gather Merge node.
4. max_pred_locks_per_transaction – Controls the average number of object locks allocated for each transaction.
5. wal_receiver_timeout Flag, ends replication connections that are inactive for the specified time.
6. wal_sender_timeout – Flag, which is for detection by the ending server, ends replication connections that are inactive for the specified time.

356
(aka v4)

INT-153

Added support for scanning PostgreSQL 14 sources with migVisor Metadata Collector.

355
(aka v3)

AP-334

Added queries for Azure DB target to identify the following features:

List of new features in this release

1. Azure unsupported Extension – Identifies if the source database has installed extensions which are not supported by Azure DB PostgreSQL.

2. Azure unsupported language – Identifies if the source database has installed languages which are not supported by Azure DB PostgreSQL.

354
(aka v2)

INT-126

Adjusted the Unsupported Extension query to reflect that Cloud SQL for PostgreSQL now supports the following extensions:

List of newly supported extensions

1. auto_explain – Enables you to automatically log execution plans of slow statements, for troubleshooting and more. Provides an automated way to perform the functionality of the EXPLAIN command.

2. pg_cron – A cron-based job scheduler, this extension enables cron syntax to schedule commands from a database.

3. pg_hint_plan – Enables you to improve PostgreSQL execution plans using hints, which are simple descriptions in SQL comments.

4. pg_proctab – Enables you to use pg_top with Cloud SQL for PostgreSQL, and generate reports from the operating system process table.

Adjusted the GCP Unsupported settings query to reflect that Cloud SQL for PostgreSQL now supports max_pred_locks_per_page and max_pred_locks_per_relation flags.

353
(aka v1)

MIG-1984

Maintenance release – Split query file based on Source DB Engine

352

INT-110

Maintenance release

349

INT-104

Maintenance release

348

INT-103

Adjusted queries to optimize their output format.

List of affected features in this release

1. Tables without PK – Identifies tables that do not have Primary Key constraints.

2. PG version lower 9.6 – Identifies if the database version is lower than 9.6.

3. Postgres Database not present – Identifies if source database has PostgreSQL database, which is a prerequisite for GCP DMS service.

4. pglogical extension missing – Identifies if pglogical extension is missing, which is required for logical replication setup.

345-346

AP-208

Maintenance release

343

INT-96

Adjusted the GCP Unsupported settings query to reflect that Cloud SQL for PostgreSQL supports the min_wal_size flag.

340

INT-92

Adjusted the GCP unsupported setting query to reflect that Cloud SQL for PostgreSQL supports the following flags:

List of newly supported flags

1. huge_pages – Enables/disables the use of huge memory pages. Valid values are: try (default), on, off.

2. shared_buffers – Sets the amount of memory the database server uses for shared memory buffers.

3. wal_buffers – The amount of shared memory used for WAL data that has not yet been written to disk.

335

INT-82

Maintenance release

334

INT-80

Adjusted the GCP unsupported setting query to reflect that Cloud SQL for PostgreSQL supports the following flags:

List of newly supported flags

1. tcp_keepalives_count – Specifies the number of TCP keepalives that can be lost before the server's connection to the client is considered dead.

2. tcp_keepalives_idle – Specifies the number of seconds of inactivity after which TCP should send a keepalive message to the client.

3. tcp_keepalives_interval – Specifies the number of seconds after which a TCP keepalive message that is not acknowledged by the client should be retransmitted.

330

INT-72

Maintenance release

302


INT-48

Added queries to identify the following features:

List of new features in this release

1. Tables without PK – Identifies tables which do not have Primary Key constraint.

2. PG version lower 9.6 – Identifies if database version is lower than 9.6.

3. Postgres Database not present – Identifies if source database has postgres database, which is a prerequisite for GCP DMS service.

4. pglogical extension missing – Identifies if pglogical extension is missing, which is required for logical replication setup.

5. GCP DMS parameters incorrect settings – Identifies if source database parameters meet GCP DMS service prerequisites.

295

INT-32

Added a query to identify User Defined functions.

260

SUP-193

Added support for scanning PostgreSQL 8.3, 9.1, 9.2, 9.3, 9.4, 9.5 sources with migVisor Metadata Collector.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.