4 posts tagged with "Postgres"

WordPress sites are often targeted by attackers, especially on shared hosting environments. To ensure the security of the WordPress managed hosting offering in your shared hosting solution, here are best practices and recommendations for protecting the hosted WordPress sites:

In PostgreSQL, aclitem is a specialized data type used internally to represent access control lists (ACLs) for database objects, such as tables, views, sequences, functions, and schemas. It defines who (roles or users) has specific privileges on a database object.

Although it's not commonly used directly in application-level development, it's stored in PostgreSQL system catalogs like pg_class, pg_proc, and pg_namespace to manage permissions.

PostgreSQL offers a wide range of data types that can be broadly categorized as follows:

1. Numeric Types​

• Small Integer: SMALLINT (2 bytes, range: -32,768 to +32,767)
• Integer: INTEGER or INT (4 bytes, range: -2,147,483,648 to +2,147,483,647)
• Big Integer: BIGINT (8 bytes, range: -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807)
• Decimal/Numeric: DECIMAL(p, s) or NUMERIC(p, s) (User-defined precision)
• Real: REAL (4 bytes, single-precision floating-point)
• Double Precision: DOUBLE PRECISION (8 bytes, double-precision floating-point)
• Serial: SERIAL, BIGSERIAL, SMALLSERIAL (Auto-incrementing integers)

This is a comprehensive PostgreSQL learning guide for someone familiar with MySQL:

1. Install PostgreSQL​

On Ubuntu:​

sudo apt update
sudo apt install postgresql postgresql-contrib