Shared libraries required to deploy client applications, including libpq runtime libraries for ECPG processor. Standard client applications, such as psql or pg_dump. Similarly, this Postgres Pro installation may be automatically removed if you later install another PostgreSQL-based product. Installing the postgrespro-std-11 package can delete existing installations of Postgres Pro and PostgreSQL-based products. Like vanilla PostgreSQL, Postgres Pro server runs on behalf of the postgres user.

opt/pgpro/std-11/bin/pg-setup service start

Start the server by running pg-setup as root, as follows: In this file, you can also change the value of PG_OOM_ADJUST_VALUE for postmaster child processes (see Section 17.4.4 for details). All the subsequent pg-setup commands, as well as any commands that manage Postgres Pro service, affect this database only. Since the default database is created using the pg-setup script, the path to its data directory is stored in the /etc/default/postgrespro-std-11 file. All the LC_* environment variables are ignored.

If you do not specify any initdb options, the default database is created in the /var/lib/pgpro/std-11/data directory, using localization settings specified in the LANG environment variable for the current session. The pg-setup script performs database administration operations as user postgres. If this is not what you expect, specify the -no-data-checksums. By default, pg-setup initializes the database cluster with checksums enabled.

Install postgresql debian 11