↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Search PostgreSQL documentation

PG 18 · Browse by category, or enter a name or keyword

Category index15
bsdAuthentication MethodsWikiAuthentication Methods · Authentication and access controlAuthenticate using the BSD Authentication service provided by the operating system. See Section 20.13 for details. Authentication and access control Authenticate using the BSD Authenticatio… certAuthentication MethodsWikiAuthentication Methods · Authentication and access controlAuthenticate using SSL client certificates. See Section 20.11 for details. Authentication and access control Authenticate using SSL client certificates. See Section 20.3.9 for details. Meth… gssAuthentication MethodsWikiAuthentication Methods · Authentication and access controlUse GSSAPI to authenticate the user. This is only available for TCP/IP connections. See Section 20.6 for details. It can be used in conjunction with GSSAPI encryption. Authentication and ac… identAuthentication MethodsWikiAuthentication Methods · Authentication and access controlObtain the operating system user name of the client by contacting the ident server on the client and check if it matches the requested database user name. Ident authentication can only be us… ldapAuthentication MethodsWikiAuthentication Methods · Authentication and access controlAuthenticate using an LDAP server. See Section 20.10 for details. Authentication and access control Authenticate using an LDAP server. See Section 20.3.7 for details. Method ldap Configurat… md5Authentication MethodsWikiAuthentication Methods · Password authenticationPerform SCRAM-SHA-256 or MD5 authentication to verify the user's password. See Section 20.5 for details. Warning Support for MD5-encrypted passwords is deprecated and will be removed in a fu… oauthAuthentication MethodsWikiAuthentication Methods · Authentication and access controlAuthorize and optionally authenticate using a third-party OAuth 2.0 identity provider. See Section 20.14 for details. Authentication and access control Authorize and optionally authenticate… pamAuthentication MethodsWikiAuthentication Methods · Authentication and access controlAuthenticate using the Pluggable Authentication Modules (PAM) service provided by the operating system. See Section 20.12 for details. Authentication and access control Authenticate using t… passwordAuthentication MethodsWikiAuthentication Methods · Password authenticationRequire the client to supply an unencrypted password for authentication. Since the password is sent in clear text over the network, this should not be used on untrusted networks. See Section… peerAuthentication MethodsWikiAuthentication Methods · Authentication and access controlObtain the client's operating system user name from the operating system and check if it matches the requested database user name. This is only available for local connections. See Section 2… radiusAuthentication MethodsWikiAuthentication Methods · Authentication and access controlAuthenticate using a RADIUS server. See Section 20.11 for details. Authentication and access control Authenticate using a RADIUS server. See Section 20.3.8 for details. Method radius Config… rejectAuthentication MethodsWikiAuthentication Methods · Authentication and access controlthe connection unconditionally. This is useful for “ filtering out ” certain hosts from a group, for example a reject line could block a specific host from connecting, while a later line all… scram-sha-256Authentication MethodsWikiAuthentication Methods · Password authenticationPerform SCRAM-SHA-256 authentication to verify the user's password. See Section 20.5 for details. Password authentication Perform SCRAM-SHA-256 authentication to verify the user's password.… sspiAuthentication MethodsWikiAuthentication Methods · Authentication and access controlUse SSPI to authenticate the user. This is only available on Windows. See Section 20.7 for details. Authentication and access control Use SSPI to authenticate the user. This is only availab… trustAuthentication MethodsWikiAuthentication Methods · Authentication and access controlAllow the connection unconditionally. This method allows anyone that can connect to the PostgreSQL database server to login as any PostgreSQL user they wish, without the need for a password …

Find definitions in the PostgreSQL manuals, reference library, and extension catalogue.

Searching every version by default. Manual pages are indexed for PostgreSQL 10–20; the reference library and extension catalogue are not version-bound.

all: every version pg17: one version ex: extensions only ↑↓ select ↵ open