Title: Plugin do not work with pg4wp
Last modified: January 29, 2025

---

# Plugin do not work with pg4wp

 *  Resolved [Márcio Lopes Fão](https://wordpress.org/support/users/marciofao/)
 * (@marciofao)
 * [1 year, 3 months ago](https://wordpress.org/support/topic/plugin-do-not-work-with-pg4wp/)
 * In my project I am using the pg4wp plugin because we needed it running on postgres.
   
   The plugin shows the message: “**Missing Table** — One or more required database
   tables are missing, please check the Diagnostic Info in the Support tab for details”
 * It seems the plugin was not able to create the table.
 * I have tested the plugin elsewhere in standard mysql and copied the table from
   there.
 * Even tough the table exists, the error still shows the same
 * Here is the postgres-compatible sql I used to create the table:
 *     ```wp-block-code
       CREATE TABLE wp_as3cf_items (id BIGSERIAL PRIMARY KEY,provider VARCHAR(18) NOT NULL,region VARCHAR(255) NOT NULL,bucket VARCHAR(255) NOT NULL,path VARCHAR(1024) NOT NULL,original_path VARCHAR(1024) NOT NULL,is_private BOOLEAN NOT NULL DEFAULT FALSE,source_type VARCHAR(18) NOT NULL,source_id BIGINT NOT NULL,source_path VARCHAR(1024) NOT NULL,original_source_path VARCHAR(1024) NOT NULL,extra_info TEXT,originator SMALLINT NOT NULL DEFAULT 0,is_verified BOOLEAN NOT NULL DEFAULT TRUE,UNIQUE (source_type, source_id),UNIQUE (is_verified, originator, id),UNIQUE (path, id),UNIQUE (original_path, id),UNIQUE (source_path, id),UNIQUE (original_source_path, id),UNIQUE (provider, bucket, id));
       ```
   
 * Here is the diagnostic info from support tab:
   Table Prefix: wp_WordPress: 6.7.1Web
   Server: nginx/1.27.3PHP: 8.1.31MySQL: 8.0.35ext/mysqli: yesPHP Memory Limit: -
   1WP Memory Limit: 40MMemory Usage: 8 MBBlocked External HTTP Requests: NoneWP
   Locale: pt_BROrganize offloads by month/year: EnabledWP_DEBUG: NoWP_DEBUG_LOG:
   NoWP_DEBUG_DISPLAY: YesSCRIPT_DEBUG: NoWP Max Upload Size: 64 MBPHP Time Limit:
   0PHP Error Log: /dev/stderrWP Cron: Enabledfsockopen: Enabledallow_url_fopen:
   EnabledOpenSSL: OpenSSL 3.0.15 3 Sep 2024cURL: 7.88.1Zlib Compression: EnabledPHP
   GD: bundled (2.1.0 compatible)Imagick: EnabledBasic Auth: DisabledProxy: DisabledTotal
   Media Items: 0Total Offloaded Media Items: 0Total Not Offloaded Media Items: 
   0Media Library Items: 0Offloaded Media Library Items: 0Not Offloaded Media Library
   Items: 0Number of Image Sizes: 6Names and Dimensions of Image Sizes:thumbnail(
   150×150)medium (300×300)large (1024×1024)1536×1536 (1536×1536)2048×2048 (2048
   ×2048)WP_CONTENT_DIR: /var/www/html/wp-contentWP_CONTENT_URL: [https://portaljusbr-dev.stg.pdpj.jus.br/wp-content](https://portaljusbr-dev.stg.pdpj.jus.br/wp-content)
   UPLOADS: Not definedWP_PLUGIN_DIR: /var/www/html/wp-content/pluginsWP_PLUGIN_URL:
   [https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/plugins](https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/plugins)
   AS3CF_PROVIDER: Not definedAS3CF_BUCKET: Not definedAS3CF_REGION: Not definedAS3CF_SETTINGS:
   Not definedLocal URL:[https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/uploads/2025/01/example.jpg](https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/uploads/2025/01/example.jpg)
   Offload URL:[https://portal-media-jus.s3.sa-east-1.amazonaws.com/wp-content/uploads/2025/01/29165816/example.jpg](https://portal-media-jus.s3.sa-east-1.amazonaws.com/wp-content/uploads/2025/01/29165816/example.jpg)
   OME Metadata Version: 12Custom tables:wp_as3cf_items: MissingStorage Provider:
   Amazon S3Use Server Roles: OnKey File Path: N/AAccess Keys Set: NoAccess Key 
   ID Define: Not definedSecret Access Key Define: Not definedBucket: portal-media-
   jusRegion: sa-east-1Block All Public Access: DisabledObject Ownership Enforced:
   NoOffload Media: OnRemove Local Media: OnEnable Add Prefix to Bucket Path: OnCustom
   Prefix for Bucket Path: wp-content/uploads/Add Year & Month to Bucket Path: OnAdd
   Object Version to Bucket Path: OnDelivery Provider: Amazon S3Deliver Offloaded
   Media: OnForce HTTPS: OffActive Theme Name: CNJ Portal JusActive Theme Version:
   1.0Active Theme Folder: portal-jusActive Plugins:Advanced Custom Fields (v6.3.6)
   by WP EngineSucuri Security – Auditing, Malware Scanner and Hardening (v1.9.4)
   by Sucuri Inc.WP Offload Media Lite (v3.2.11) by Delicious BrainsDrop-ins:db.
   php – PostgreSQL for WordPress (PG4WP)

Viewing 1 replies (of 1 total)

 *  Plugin Support [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/)
 * (@dbisupport)
 * [1 year, 3 months ago](https://wordpress.org/support/topic/plugin-do-not-work-with-pg4wp/#post-18283179)
 * Hi [@marciofao](https://wordpress.org/support/users/marciofao/),
 * WP Offload Media Support Team here. Thanks for reaching out with your query! 
   We would be happy to assist.
 * [WP Offload Media requires at least MySQL 5.0+](https://deliciousbrains.com/wp-offload-media/pricing/#requirements),
   and it is not officially compatible with PostgreSQL via PG4WP. We understand 
   you’ve manually created the `wp_as3cf_items` table, but since the plugin still
   reports it as missing, this suggests compatibility issues.
 * If possible, switching to MySQL would be the best approach to ensure compatibility.
 * Let us know if you have any questions!

Viewing 1 replies (of 1 total)

The topic ‘Plugin do not work with pg4wp’ is closed to new replies.

 * ![](https://ps.w.org/amazon-s3-and-cloudfront/assets/icon-256x256.jpg?rev=1809890)
 * [WP Offload Media Lite for Amazon S3, DigitalOcean Spaces, and Google Cloud Storage](https://wordpress.org/plugins/amazon-s3-and-cloudfront/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/amazon-s3-and-cloudfront/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/amazon-s3-and-cloudfront/)
 * [Active Topics](https://wordpress.org/support/plugin/amazon-s3-and-cloudfront/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/amazon-s3-and-cloudfront/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/amazon-s3-and-cloudfront/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/)
 * Last activity: [1 year, 3 months ago](https://wordpress.org/support/topic/plugin-do-not-work-with-pg4wp/#post-18283179)
 * Status: resolved