PostgreSql extends AbstractPlatform

Check database configuration status for PostgreSQL

This class is a hardcoded requirement check for the database server.

The status messages and title must not include HTML, use plain text only. The return values of this class are not bound to HTML and can be used in different scopes (eg. as json array).

Internal

This class is only meant to be used within EXT:install and is not part of the TYPO3 Core API.

Table of Contents

Constants

SCHEMA_NAME_MAX_LENGTH  = 64

Properties

$databaseCharsetToCheck  : array<string|int, mixed>
Charset of the database that should be fulfilled
$databaseServerCharsetToCheck  : array<string|int, mixed>
Charset of the database server that should be fulfilled
$messageQueue  : FlashMessageQueue
$minimumLibPQVersion  : string
Minimum supported libpq version
$minimumPostgreSQLVerion  : string
Minimum supported PostgreSQL Server version

Methods

__construct()  : mixed
checkDefaultDatabaseCharset()  : void
Checks the character set of the database and reports an error if it is not utf-8.
checkDefaultDatabaseServerCharset()  : void
Checks the character set of the database server and reports an info if it is not utf-8.
getMessageQueue()  : FlashMessageQueue
getStatus()  : FlashMessageQueue
Get all status information as array with status objects
isValidDatabaseName()  : bool
Validate the database name
checkDatabaseName()  : void
checkLibpqVersion()  : mixed
Check the version of ligpq within the PostgreSQL driver
checkPostgreSqlVersion()  : mixed
Check minimum PostgreSQL version

Constants

SCHEMA_NAME_MAX_LENGTH

protected int SCHEMA_NAME_MAX_LENGTH = 64

The maximum length of the schema name

Properties

$databaseCharsetToCheck

Charset of the database that should be fulfilled

protected array<string|int, mixed> $databaseCharsetToCheck = ['utf8']

$databaseServerCharsetToCheck

Charset of the database server that should be fulfilled

protected array<string|int, mixed> $databaseServerCharsetToCheck = ['utf8']

$minimumLibPQVersion

Minimum supported libpq version

protected string $minimumLibPQVersion = '9.0'

$minimumPostgreSQLVerion

Minimum supported PostgreSQL Server version

protected string $minimumPostgreSQLVerion = '9.2'

Methods

checkDefaultDatabaseCharset()

Checks the character set of the database and reports an error if it is not utf-8.

public checkDefaultDatabaseCharset(Connection $connection) : void
Parameters
$connection : Connection

to the database to be checked

checkDefaultDatabaseServerCharset()

Checks the character set of the database server and reports an info if it is not utf-8.

public checkDefaultDatabaseServerCharset(Connection $connection) : void
Parameters
$connection : Connection

to the database to be checked

isValidDatabaseName()

Validate the database name

public static isValidDatabaseName(string $databaseName) : bool
Parameters
$databaseName : string
Return values
bool

checkLibpqVersion()

Check the version of ligpq within the PostgreSQL driver

protected checkLibpqVersion() : mixed

checkPostgreSqlVersion()

Check minimum PostgreSQL version

protected checkPostgreSqlVersion(Connection $connection) : mixed
Parameters
$connection : Connection

to the database to be checked


        
On this page

Search results