Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
- API
  
  Reference documentation for the pkg.go.dev API
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

postgresql

package

Go to main page

Versions in this module

v7

v7.2.0

Sep 2, 2026

Changes in this version

+ type CreateBackupOption func(*CreateBackupOptions)

+ type CreateBackupOptions struct

+ Type string

+ func (options CreateBackupOptions) New() *CreateBackupOptions

+ type CreateBackupPolicyOption func(*CreateBackupPolicyOptions)

+ type CreateBackupPolicyOptions struct

+ Enabled bool

+ Type string

+ func (options CreateBackupPolicyOptions) New() *CreateBackupPolicyOptions

+ type CreateBranchOption func(*CreateBranchOptions)

+ type CreateBranchOptions struct

+ BranchId string

+ Ttl int

+ func (options CreateBranchOptions) New() *CreateBranchOptions

+ type CreateExecutionOption func(*CreateExecutionOptions)

+ type CreateExecutionOptions struct

+ Bindings interface{}

+ TimeoutSeconds int

+ func (options CreateExecutionOptions) New() *CreateExecutionOptions

+ type CreateFailoverOption func(*CreateFailoverOptions)

+ type CreateFailoverOptions struct

+ TargetReplicaId string

+ func (options CreateFailoverOptions) New() *CreateFailoverOptions

+ type CreateMigrationOption func(*CreateMigrationOptions)

+ type CreateMigrationOptions struct

+ Specification string

+ func (options CreateMigrationOptions) New() *CreateMigrationOptions

+ type CreateOption func(*CreateOptions)

+ type CreateOptions struct

+ IdleTimeoutMinutes int

+ NetworkIPAllowlist []string

+ NetworkIdleTimeoutSeconds int

+ Pitr bool

+ PitrRetentionDays int

+ Replicas int

+ Specification string

+ StorageAutoscaling bool

+ StorageAutoscalingMaxGb int

+ StorageAutoscalingThresholdPercent int

+ SyncMode string

+ Version string

+ func (options CreateOptions) New() *CreateOptions

+ type CreateRestorationOption func(*CreateRestorationOptions)

+ type CreateRestorationOptions struct

+ BackupId string

+ TargetDatabaseId string

+ TargetTime string

+ Type string

+ func (options CreateRestorationOptions) New() *CreateRestorationOptions

+ type ListBackupPoliciesOption func(*ListBackupPoliciesOptions)

+ type ListBackupPoliciesOptions struct

+ Queries []string

+ func (options ListBackupPoliciesOptions) New() *ListBackupPoliciesOptions

+ type ListBackupsOption func(*ListBackupsOptions)

+ type ListBackupsOptions struct

+ Queries []string

+ func (options ListBackupsOptions) New() *ListBackupsOptions

+ type ListOperationsOption func(*ListOperationsOptions)

+ type ListOperationsOptions struct

+ Limit int

+ Offset int

+ Status string

+ func (options ListOperationsOptions) New() *ListOperationsOptions

+ type ListOption func(*ListOptions)

+ type ListOptions struct

+ Queries []string

+ func (options ListOptions) New() *ListOptions

+ type ListRestorationsOption func(*ListRestorationsOptions)

+ type ListRestorationsOptions struct

+ Limit int

+ Offset int

+ Status string

+ Type string

+ func (options ListRestorationsOptions) New() *ListRestorationsOptions

+ type Postgresql struct

+ func New(clt client.Client) *Postgresql

+ func (srv *Postgresql) Create(DatabaseId string, Name string, optionalSetters ...CreateOption) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) CreateBackup(DatabaseId string, optionalSetters ...CreateBackupOption) (*models.DedicatedDatabaseBackup, error)

+ func (srv *Postgresql) CreateBackupPolicy(DatabaseId string, PolicyId string, Name string, Schedule string, ...) (*models.BackupPolicy, error)

+ func (srv *Postgresql) CreateBranch(DatabaseId string, optionalSetters ...CreateBranchOption) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) CreateExecution(DatabaseId string, Sql string, optionalSetters ...CreateExecutionOption) (*models.DedicatedDatabaseExecution, error)

+ func (srv *Postgresql) CreateExtension(DatabaseId string, Name string) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) CreateFailover(DatabaseId string, optionalSetters ...CreateFailoverOption) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) CreateMigration(DatabaseId string, TargetType string, optionalSetters ...CreateMigrationOption) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) CreateRestoration(DatabaseId string, optionalSetters ...CreateRestorationOption) (*models.DedicatedDatabaseRestoration, error)

+ func (srv *Postgresql) CreateUpgrade(DatabaseId string, TargetVersion string) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) Delete(DatabaseId string) (*interface{}, error)

+ func (srv *Postgresql) DeleteBackup(DatabaseId string, BackupId string) (*interface{}, error)

+ func (srv *Postgresql) DeleteBackupPolicy(DatabaseId string, PolicyId string) (*interface{}, error)

+ func (srv *Postgresql) DeleteBranch(DatabaseId string, BranchId string) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) DeleteExtension(DatabaseId string, ExtensionName string) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) Get(DatabaseId string) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) GetBackup(DatabaseId string, BackupId string) (*models.DedicatedDatabaseBackup, error)

+ func (srv *Postgresql) GetBackupPolicy(DatabaseId string, PolicyId string) (*models.BackupPolicy, error)

+ func (srv *Postgresql) GetPitr(DatabaseId string) (*models.DedicatedDatabasePITRWindows, error)

+ func (srv *Postgresql) GetPooler(DatabaseId string) (*models.DedicatedDatabasePooler, error)

+ func (srv *Postgresql) GetReplicas(DatabaseId string) (*models.DedicatedDatabaseReplicas, error)

+ func (srv *Postgresql) GetRestoration(DatabaseId string, RestorationId string) (*models.DedicatedDatabaseRestoration, error)

+ func (srv *Postgresql) GetStatus(DatabaseId string) (*models.DatabaseStatus, error)

+ func (srv *Postgresql) List(optionalSetters ...ListOption) (*models.DedicatedDatabaseList, error)

+ func (srv *Postgresql) ListBackupPolicies(DatabaseId string, optionalSetters ...ListBackupPoliciesOption) (*models.BackupPolicyList, error)

+ func (srv *Postgresql) ListBackups(DatabaseId string, optionalSetters ...ListBackupsOption) (*models.DedicatedDatabaseBackupList, error)

+ func (srv *Postgresql) ListBranches(DatabaseId string) (*models.DedicatedDatabaseBranchList, error)

+ func (srv *Postgresql) ListExtensions(DatabaseId string) (*models.DedicatedDatabaseExtensions, error)

+ func (srv *Postgresql) ListOperations(DatabaseId string, optionalSetters ...ListOperationsOption) (*models.DedicatedDatabaseOperationList, error)

+ func (srv *Postgresql) ListRestorations(DatabaseId string, optionalSetters ...ListRestorationsOption) (*models.DedicatedDatabaseRestorationList, error)

+ func (srv *Postgresql) ListSpecifications() (*models.DedicatedDatabaseSpecificationList, error)

+ func (srv *Postgresql) Update(DatabaseId string, optionalSetters ...UpdateOption) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) UpdateBackupPolicy(DatabaseId string, PolicyId string, ...) (*models.BackupPolicy, error)

+ func (srv *Postgresql) UpdateBackupStorage(DatabaseId string, Provider string, Bucket string, AccessKey string, ...) (*models.DedicatedDatabaseBackupStorage, error)

+ func (srv *Postgresql) UpdateCredentials(DatabaseId string) (*models.DedicatedDatabaseOperation, error)

+ func (srv *Postgresql) UpdateMaintenance(DatabaseId string, Day string, HourUtc int) (*models.DedicatedDatabase, error)

+ func (srv *Postgresql) UpdatePooler(DatabaseId string, optionalSetters ...UpdatePoolerOption) (*models.DedicatedDatabasePooler, error)

+ func (srv *Postgresql) WithCreateBackupPolicyEnabled(v bool) CreateBackupPolicyOption

+ func (srv *Postgresql) WithCreateBackupPolicyType(v string) CreateBackupPolicyOption

+ func (srv *Postgresql) WithCreateBackupType(v string) CreateBackupOption

+ func (srv *Postgresql) WithCreateBranchBranchId(v string) CreateBranchOption

+ func (srv *Postgresql) WithCreateBranchTtl(v int) CreateBranchOption

+ func (srv *Postgresql) WithCreateExecutionBindings(v interface{}) CreateExecutionOption

+ func (srv *Postgresql) WithCreateExecutionTimeoutSeconds(v int) CreateExecutionOption

+ func (srv *Postgresql) WithCreateFailoverTargetReplicaId(v string) CreateFailoverOption

+ func (srv *Postgresql) WithCreateIdleTimeoutMinutes(v int) CreateOption

+ func (srv *Postgresql) WithCreateMigrationSpecification(v string) CreateMigrationOption

+ func (srv *Postgresql) WithCreateNetworkIPAllowlist(v []string) CreateOption

+ func (srv *Postgresql) WithCreateNetworkIdleTimeoutSeconds(v int) CreateOption

+ func (srv *Postgresql) WithCreatePitr(v bool) CreateOption

+ func (srv *Postgresql) WithCreatePitrRetentionDays(v int) CreateOption

+ func (srv *Postgresql) WithCreateReplicas(v int) CreateOption

+ func (srv *Postgresql) WithCreateRestorationBackupId(v string) CreateRestorationOption

+ func (srv *Postgresql) WithCreateRestorationTargetDatabaseId(v string) CreateRestorationOption

+ func (srv *Postgresql) WithCreateRestorationTargetTime(v string) CreateRestorationOption

+ func (srv *Postgresql) WithCreateRestorationType(v string) CreateRestorationOption

+ func (srv *Postgresql) WithCreateSpecification(v string) CreateOption

+ func (srv *Postgresql) WithCreateStorageAutoscaling(v bool) CreateOption

+ func (srv *Postgresql) WithCreateStorageAutoscalingMaxGb(v int) CreateOption

+ func (srv *Postgresql) WithCreateStorageAutoscalingThresholdPercent(v int) CreateOption

+ func (srv *Postgresql) WithCreateSyncMode(v string) CreateOption

+ func (srv *Postgresql) WithCreateVersion(v string) CreateOption

+ func (srv *Postgresql) WithListBackupPoliciesQueries(v []string) ListBackupPoliciesOption

+ func (srv *Postgresql) WithListBackupsQueries(v []string) ListBackupsOption

+ func (srv *Postgresql) WithListOperationsLimit(v int) ListOperationsOption

+ func (srv *Postgresql) WithListOperationsOffset(v int) ListOperationsOption

+ func (srv *Postgresql) WithListOperationsStatus(v string) ListOperationsOption

+ func (srv *Postgresql) WithListQueries(v []string) ListOption

+ func (srv *Postgresql) WithListRestorationsLimit(v int) ListRestorationsOption

+ func (srv *Postgresql) WithListRestorationsOffset(v int) ListRestorationsOption

+ func (srv *Postgresql) WithListRestorationsStatus(v string) ListRestorationsOption

+ func (srv *Postgresql) WithListRestorationsType(v string) ListRestorationsOption

+ func (srv *Postgresql) WithUpdateBackupPolicyEnabled(v bool) UpdateBackupPolicyOption

+ func (srv *Postgresql) WithUpdateBackupPolicyName(v string) UpdateBackupPolicyOption

+ func (srv *Postgresql) WithUpdateBackupPolicyRetention(v int) UpdateBackupPolicyOption

+ func (srv *Postgresql) WithUpdateBackupPolicySchedule(v string) UpdateBackupPolicyOption

+ func (srv *Postgresql) WithUpdateBackupStorageEndpoint(v string) UpdateBackupStorageOption

+ func (srv *Postgresql) WithUpdateBackupStoragePrefix(v string) UpdateBackupStorageOption

+ func (srv *Postgresql) WithUpdateBackupStorageRegion(v string) UpdateBackupStorageOption

+ func (srv *Postgresql) WithUpdateIdleTimeoutMinutes(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateMetricsSlowQueryLogThresholdMs(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateMetricsTraceSampleRate(v float64) UpdateOption

+ func (srv *Postgresql) WithUpdateName(v string) UpdateOption

+ func (srv *Postgresql) WithUpdateNetworkIPAllowlist(v []string) UpdateOption

+ func (srv *Postgresql) WithUpdateNetworkIdleTimeoutSeconds(v int) UpdateOption

+ func (srv *Postgresql) WithUpdatePitr(v bool) UpdateOption

+ func (srv *Postgresql) WithUpdatePitrRetentionDays(v int) UpdateOption

+ func (srv *Postgresql) WithUpdatePoolerDefaultPoolSize(v int) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdatePoolerMaxConnections(v int) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdatePoolerMode(v string) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdatePoolerPoolerCpuLimit(v string) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdatePoolerPoolerCpuRequest(v string) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdatePoolerPoolerMemoryLimit(v string) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdatePoolerPoolerMemoryRequest(v string) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdatePoolerReadWriteSplitting(v bool) UpdatePoolerOption

+ func (srv *Postgresql) WithUpdateReplicas(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateSpecification(v string) UpdateOption

+ func (srv *Postgresql) WithUpdateSqlApiAllowedStatements(v []string) UpdateOption

+ func (srv *Postgresql) WithUpdateSqlApiEnabled(v bool) UpdateOption

+ func (srv *Postgresql) WithUpdateSqlApiMaxBytes(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateSqlApiMaxRows(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateSqlApiTimeoutSeconds(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateStatus(v string) UpdateOption

+ func (srv *Postgresql) WithUpdateStorageAutoscaling(v bool) UpdateOption

+ func (srv *Postgresql) WithUpdateStorageAutoscalingMaxGb(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateStorageAutoscalingThresholdPercent(v int) UpdateOption

+ func (srv *Postgresql) WithUpdateSyncMode(v string) UpdateOption

+ type UpdateBackupPolicyOption func(*UpdateBackupPolicyOptions)

+ type UpdateBackupPolicyOptions struct

+ Enabled bool

+ Name string

+ Retention int

+ Schedule string

+ func (options UpdateBackupPolicyOptions) New() *UpdateBackupPolicyOptions

+ type UpdateBackupStorageOption func(*UpdateBackupStorageOptions)

+ type UpdateBackupStorageOptions struct

+ Endpoint string

+ Prefix string

+ Region string

+ func (options UpdateBackupStorageOptions) New() *UpdateBackupStorageOptions

+ type UpdateOption func(*UpdateOptions)

+ type UpdateOptions struct

+ IdleTimeoutMinutes int

+ MetricsSlowQueryLogThresholdMs int

+ MetricsTraceSampleRate float64

+ Name string

+ NetworkIPAllowlist []string

+ NetworkIdleTimeoutSeconds int

+ Pitr bool

+ PitrRetentionDays int

+ Replicas int

+ Specification string

+ SqlApiAllowedStatements []string

+ SqlApiEnabled bool

+ SqlApiMaxBytes int

+ SqlApiMaxRows int

+ SqlApiTimeoutSeconds int

+ Status string

+ StorageAutoscaling bool

+ StorageAutoscalingMaxGb int

+ StorageAutoscalingThresholdPercent int

+ SyncMode string

+ func (options UpdateOptions) New() *UpdateOptions

+ type UpdatePoolerOption func(*UpdatePoolerOptions)

+ type UpdatePoolerOptions struct

+ DefaultPoolSize int

+ MaxConnections int

+ Mode string

+ PoolerCpuLimit string

+ PoolerCpuRequest string

+ PoolerMemoryLimit string

+ PoolerMemoryRequest string

+ ReadWriteSplitting bool

+ func (options UpdatePoolerOptions) New() *UpdatePoolerOptions

v7.2.0-rc.5

Aug 31, 2026

v7.2.0-rc.4

Aug 28, 2026

v7.2.0-rc.3

Aug 21, 2026

v7.2.0-rc.2

Aug 18, 2026

v7.2.0-rc.1

Aug 17, 2026