manifest

type ClusterConfig struct {
	DataDirectory          string `json:"data_directory,omitempty"`
	Timezone               string `json:"timezone,omitempty"`
	MaxConnections         int    `json:"max_connections,omitempty"`
	WalLevel               string `json:"wal_level,omitempty"`
	ServerEncoding         string `json:"server_encoding,omitempty"`
	DataChecksums          bool   `json:"data_checksums"`
	BlockSize              int    `json:"block_size,omitempty"`
	WalBlockSize           int    `json:"wal_block_size,omitempty"`
	SharedPreloadLibraries string `json:"shared_preload_libraries,omitempty"`
	LCCollate              string `json:"lc_collate,omitempty"`
	LCCType                string `json:"lc_ctype,omitempty"`
	ArchiveMode            string `json:"archive_mode,omitempty"`
	ArchiveCommandSet      bool   `json:"archive_command_set"` // true when archive_command is non-empty; the command itself is not stored to avoid leaking credentials
}

type ColumnInfo struct {
	Position int    `json:"position"`
	Name     string `json:"name"`
	Type     string `json:"type"`
	Nullable bool   `json:"nullable"`
	Default  string `json:"default,omitempty"`
}

type ConstraintInfo struct {
	Name    string   `json:"name"`
	Type    string   `json:"type"`
	Columns []string `json:"columns,omitempty"`
}

type DatabaseInfo struct {
	Name              string         `json:"name"`
	Owner             string         `json:"owner"`
	Encoding          string         `json:"encoding"`
	Collate           string         `json:"collate"`
	CType             string         `json:"ctype"`
	AllowConn         bool           `json:"allow_conn"`
	IsTemplate        bool           `json:"is_template"`
	DefaultTablespace string         `json:"default_tablespace,omitempty"`
	ConnectionLimit   int            `json:"connection_limit"` // -1 = no limit
	Extensions        []Extension    `json:"extensions,omitempty"`
	Schemas           []SchemaInfo   `json:"schemas,omitempty"`
	Relations         []RelationInfo `json:"relations,omitempty"`
}

type Extension struct {
	Name    string `json:"name"`
	Version string `json:"version"`
	Schema  string `json:"schema"`
}

type IndexInfo struct {
	Name           string `json:"name"`
	Method         string `json:"method"` // btree, hash, gist, gin, brin, …
	Definition     string `json:"definition"`
	IsUnique       bool   `json:"is_unique"`
	IsPrimary      bool   `json:"is_primary"`
	IsValid        bool   `json:"is_valid"`
	IsPartial      bool   `json:"is_partial"` // has a WHERE predicate
	ConstraintName string `json:"constraint_name,omitempty"`
}

type LogicalConfig struct {
	PSQLBin    string
	PgDumpBin  string
	Conn       pgconn.ConnConfig
	Database   string // empty = full-cluster backup
	DumpFormat string
	Options    ManifestOptions
}

type Manifest struct {
	Version                 int              `json:"version"`
	CreatedAt               time.Time        `json:"created_at"`
	Connector               string           `json:"connector"`
	Host                    string           `json:"host"`
	Port                    string           `json:"port"`
	ServerVersion           string           `json:"server_version"`
	ServerVersionNum        int              `json:"server_version_num"`
	PgDumpVersion           string           `json:"pg_dump_version,omitempty"`
	PgBaseBackupVersion     string           `json:"pg_basebackup_version,omitempty"`
	ClusterSystemIdentifier string           `json:"cluster_system_identifier,omitempty"`
	InRecovery              bool             `json:"in_recovery"`
	Database                string           `json:"database,omitempty"`
	DumpFormat              string           `json:"dump_format"`
	Options                 *ManifestOptions `json:"options,omitempty"`
	ClusterConfig           *ClusterConfig   `json:"cluster_config,omitempty"`
	Roles                   []Role           `json:"roles,omitempty"`
	Tablespaces             []Tablespace     `json:"tablespaces,omitempty"`
	Databases               []DatabaseInfo   `json:"databases,omitempty"`
}

type ManifestOptions struct {
	SchemaOnly bool `json:"schema_only"`
	DataOnly   bool `json:"data_only"`
	Compress   bool `json:"compress"`
}

type PhysicalConfig struct {
	PSQLBin         string
	PgBaseBackupBin string
	Conn            pgconn.ConnConfig
}

type RelationInfo struct {
	Schema            string           `json:"schema"`
	Name              string           `json:"name"`
	Owner             string           `json:"owner"`
	Persistence       string           `json:"persistence"` // p=permanent, u=unlogged, t=temp
	Kind              string           `json:"kind"`        // see above
	Tablespace        string           `json:"tablespace,omitempty"`
	RowEstimate       int64            `json:"row_estimate"`      // reltuples (fast, may be stale)
	LiveRowEstimate   int64            `json:"live_row_estimate"` // n_live_tup from autovacuum
	ColumnCount       int              `json:"column_count"`
	HasPrimaryKey     bool             `json:"has_primary_key"`
	HasTriggers       bool             `json:"has_triggers"`
	RLSEnabled        bool             `json:"rls_enabled"`
	RLSForced         bool             `json:"rls_forced"`
	IsPartition       bool             `json:"is_partition"`
	PartitionParent   string           `json:"partition_parent,omitempty"`   // "schema.name"
	PartitionStrategy string           `json:"partition_strategy,omitempty"` // range, list, hash
	StorageOptions    []string         `json:"storage_options,omitempty"`    // reloptions
	LastVacuum        *time.Time       `json:"last_vacuum"`
	LastAnalyze       *time.Time       `json:"last_analyze"`
	Columns           []ColumnInfo     `json:"columns,omitempty"`
	Constraints       []ConstraintInfo `json:"constraints,omitempty"`
	Indexes           []IndexInfo      `json:"indexes,omitempty"`
}

type Role struct {
	Name            string     `json:"name"`
	Superuser       bool       `json:"superuser"`
	Replication     bool       `json:"replication"`
	CanLogin        bool       `json:"can_login"`
	CreateDB        bool       `json:"create_db"`
	CreateRole      bool       `json:"create_role"`
	Inherit         bool       `json:"inherit"`
	BypassRLS       bool       `json:"bypass_rls"`
	ConnectionLimit int        `json:"connection_limit"` // -1 = no limit
	ValidUntil      *time.Time `json:"valid_until"`
	MemberOf        []string   `json:"member_of,omitempty"`
}

type SchemaInfo struct {
	Name  string `json:"name"`
	Owner string `json:"owner"`
}

type Tablespace struct {
	Name     string   `json:"name"`
	Owner    string   `json:"owner"`
	Location string   `json:"location"`
	Options  []string `json:"options,omitempty"` // e.g. seq_page_cost=1.1
}