Got it, let's break this down into two clear, actionable parts: setting up your staging WordPress instance with PostgreSQL, and migrating that email subscription form with PostgreSQL-based validation. Here's a step-by-step guide tailored to your needs:

First, note that WordPress natively supports MySQL/MariaDB, so we'll use an adapter layer to make it work with PostgreSQL. The most reliable tool for this is PG4WP (PostgreSQL for WordPress).

• Set up your PostgreSQL database
  Log into your PostgreSQL shell and create a dedicated database, user, and grant privileges:

  CREATE DATABASE wp_staging;
  CREATE USER wp_staging_user WITH PASSWORD 'your_strong_unique_password';
  GRANT ALL PRIVILEGES ON DATABASE wp_staging TO wp_staging_user;
  

• Prepare WordPress files
  Download the latest WordPress release, unzip it into your staging server's web root directory.

• Install the PostgreSQL adapter
  Download the latest PG4WP package, then:

  1. Backup the original wp-db.php file in your WordPress root (just in case).
  2. Replace it with the wp-db.php from PG4WP, and copy the pg4wp folder into your WordPress root directory.

• Configure wp-config.php
  Copy wp-config-sample.php to wp-config.php, then update the database settings and add the PG4WP force flag:

  define('DB_NAME', 'wp_staging');
  define('DB_USER', 'wp_staging_user');
  define('DB_PASSWORD', 'your_strong_unique_password');
  define('DB_HOST', 'localhost'); // Use your remote DB IP if PostgreSQL is on another server
  define('DB_CHARSET', 'utf8');
  define('DB_COLLATE', '');
  
  // Force PG4WP to handle database connections
  define('PG4WP_FORCE', true);
  

• Run the WordPress installation
  Access your staging site's URL, follow the wizard to create an admin account, and complete setup.

• Verify the connection
  Log into WordPress admin, go to Tools > Site Health and check the database section—you should see PostgreSQL listed as the database type.

Your existing form uses PostgreSQL to check for existing subscribers; here's how to replicate this in WordPress:

• Set up the subscription table in your staging PostgreSQL DB
  Create a table to store subscriber data (run this in your PostgreSQL shell):

  CREATE TABLE wp_email_subscribers (
      id SERIAL PRIMARY KEY,
      email VARCHAR(255) NOT NULL UNIQUE,
      subscribed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
      status BOOLEAN DEFAULT true
  );
  

  If you have existing subscribers from your HTML site, export them as CSV/SQL and import them into this table using COPY or a database tool like pgAdmin.

• Create a custom subscription form shortcode
  To add the form to any WordPress page/post, create a custom shortcode. You can add this to your theme's functions.php (or better, a custom plugin to avoid losing code when updating your theme):

  function custom_subscription_form() {
      ob_start();
      ?>
      <form id="subscription-form" method="post" action="<?php echo esc_url($_SERVER['REQUEST_URI']); ?>">
          <input type="email" name="subscriber_email" placeholder="Enter your email address" required>
          <button type="submit" name="subscribe">Subscribe</button>
          <div class="form-feedback"></div>
      </form>
      <?php
      return ob_get_clean();
  }
  add_shortcode('subscription_form', 'custom_subscription_form');
  

• Add form handling & PostgreSQL validation logic
  Add this code right after the shortcode function to handle form submissions and check for existing subscribers:

  function handle_subscription_submit() {
      if (isset($_POST['subscribe']) && isset($_POST['subscriber_email'])) {
          global $wpdb;
          $email = sanitize_email($_POST['subscriber_email']);
  
          // Validate email format
          if (!is_email($email)) {
              echo '<div class="form-feedback error">Please enter a valid email address.</div>';
              return;
          }
  
          // Check if email is already subscribed (uses WordPress's $wpdb, adapted for PostgreSQL via PG4WP)
          $table_name = $wpdb->prefix . 'email_subscribers';
          $existing_subscriber = $wpdb->get_var($wpdb->prepare("SELECT email FROM $table_name WHERE email = %s", $email));
  
          if ($existing_subscriber) {
              echo '<div class="form-feedback error">This email is already subscribed.</div>';
          } else {
              // Insert new subscriber
              $wpdb->insert(
                  $table_name,
                  array('email' => $email),
                  array('%s')
              );
              echo '<div class="form-feedback success">Thank you for subscribing!</div>';
          }
      }
  }
  add_action('init', 'handle_subscription_submit');
  

• Add the form to your pages
  In any WordPress page or post editor, insert the shortcode [subscription_form] to display the form. You can also add it directly to theme templates with echo do_shortcode('[subscription_form]');.

• Test the form
  Visit the page with the form:

  • Enter an email that's already in your subscriber table—you should get an error message.
  • Enter a new email—you should get a success message, and the email should appear in your PostgreSQL wp_email_subscribers table.

Key Notes #

• Match production environment: Make sure your staging server uses the same PHP, PostgreSQL, and server configuration as your production WordPress site to avoid compatibility issues during final migration.
• Backup everything: Always backup your staging database and WordPress files before making changes.
• Security: The code above uses sanitize_email() and $wpdb->prepare() to prevent SQL injection and invalid inputs—never skip these steps.

内容的提问来源于stack exchange，提问作者Abhi