PostgreSQL backup tool with Point-In-Time-Recovery and restore verification
TypeScript backupbackupsdatabasedatabase-backupdevopsdockergolangkubernetesmariadbmongodbmysqlpgpostgrespostgresqls3self-hostedsystem-administrationtoolsweb-ui
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;
}