Skip to content

PostgreSQL backup tool with Point-In-Time-Recovery and restore verification

932 B
Raw Blame
import type { SshTunnelConfig } from '../sshtunnel/SshTunnelConfig';
import type { PostgresqlVersion } from './PostgresqlVersion';
import type { PostgresSslMode } from './PostgresSslMode';

export interface PostgresqlLogicalDatabase {
  id: string;
  version: PostgresqlVersion;

  // connection data
  host: string;
  port: number;
  username: string;
  password: string;
  database?: string;

  // SSL / TLS
  sslMode: PostgresSslMode;
  sslClientCert?: string;
  sslClientKey?: string;
  sslRootCert?: string;

  // When enabled, host and port above address the database as the bastion sees it.
  sshTunnel?: SshTunnelConfig;

  // backup settings
  includeSchemas?: string[];
  excludeTables?: string[];
  excludeTableData?: string[];
  cpuCount: number;
  isSkipUserMappings?: boolean;

  // restore settings (not saved to DB)
  isExcludeExtensions?: boolean;
  isRestoreOwnership?: boolean;
  isRestorePrivileges?: boolean;
}