AO Logo
 
  
  
  
PostgreSQL Servers
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoserv platform ··· software components ··· aoserv client ··· tables ··· table definitions ··· postgresql servers

TABLE NAME

postgres_servers

DESCRIPTION

The postgres_servers table stores the information about each PostgreSQL instance in the system.

COLUMNS

columntypenulluniquereferencesreferenced_bysince_versiondescription
bindfkeyfalsetruenet_binds.idpostgres_databases.postgres_server
postgres_server_users.postgres_server
1.81.18the port the server binds to
namepostgres_server_namefalsefalse1.80.0the name of the database
ao_serverfkeyfalsefalseao_servers.server1.0a100the pkey of the server that this database is hosted on
versionfkeyfalsefalsepostgres_versions.version1.0a100the pkey of the PostgreSQL version
max_connectionsintfalsefalse1.0a100the maximum number of connections for the db
sort_memintfalsefalse1.0a100the amount of shared memory used for sorting
shared_buffersintfalsefalse1.0a100the number of shared buffers
fsyncbooleanfalsefalse1.0a100indicates that writes are synchronous