Install Postgres 11.2 Windows

Posted on

PostgreSQL was developed for UNIX-like platforms, however, it was designed to be portable. It means that PostgreSQL can also run on other platforms such as m.

Contents

Installed Programs:clusterdb, createdb, createuser, dropdb, dropuser, ecpg, initdb, pg_archivecleanup, pg_basebackup, pg_config, pg_controldata, pg_ctl, pg_dump, pg_dumpall, pg_isready, pg_receivewal, pg_recvlogical, pg_resetwval, pg_restore, pg_rewind, pg_test_fsync, pg_test_timing, pg_upgrade, pg_waldump, pgbench, postgres, postmaster (deprecated), psql, reindexdb, vacuumdb, optionally, if Tcl support has been built, pltcl_delmod, pltcl_listmod, pltcl_loadmod, and optionally (in contrib/) oid2name, pg_standby, vacuumlo, and many others
Installed Libraries:libecpg.{so,a}, libecpg_compat.{so,a}, libpgcommon.a, libpgport.a, libpgtypes.{so,a}, libpq.{so,a}, various charset modules, and optionally programming language modules under /usr/lib/postgresql
Install postgres 11.2 windows 10 pro 64 bit
Installed Directories:/usr/include/{libpq,postgresql}, /usr/lib/postgresql, /usr/share/{doc/postgresql-11.2,postgresql}, and /srv/pgsql

Install Postgres 11.2 Windows 10

Short Descriptions

Install Postgres 11.2 Windows 7

clusterdb

is a utility for reclustering tables in a PostgreSQL database.

createdb

creates a new PostgreSQL database.

createuser

defines a new PostgreSQL user account.

dropdb

removes a PostgreSQL database.

dropuser

removes a PostgreSQL user account.

ecpg

is the embedded SQL preprocessor.

initdb

creates a new database cluster.

oid2name

resolves OIDs (Object IDs) and file nodes in a PostgreSQL data directory.

pg_archivecleanup

cleans up PostgreSQL WAL (write-ahead log) archive files.

pg_basebackup

takes base backups of a running PostgreSQL cluster.

pg_config

retrieves PostgreSQL version information.

pg_controldata

returns information initialized during initdb, such as the catalog version and server locale.

pg_ctl

controls stopping and starting the database server.

pg_dump

dumps database data and metadata into scripts which are used to recreate the database.

pg_dumpall

recursively calls pg_dump for each database in a cluster.

pg_isready

check the connection status of a PostgreSQL server.

pg_receivewal

is used to stream write-ahead logs from a PostgreSQL server.

pg_recvlogical

controls PostgreSQL logical decoding streams.

pg_resetwal

resets the write-ahead log and other control information of a PostgreSQL database cluseter.

pg_restore

creates databases from dump files created by pg_dump.

pg_rewind

synchronizes a PostgreSQL data directory with another data directory that was forked from the first one.

pg_standby

supports the creation of a PostgreSQL warm standby server.

pg_test_fsync

determine fastest wal_sync method for PostgreSQL.

pg_test_timing

measure timing overhead.

pg_upgrade

upgrade a PostgreSQL server instance.

pg_waldump

display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster.

pgbench

run a benchmark test on PostgreSQL.

pltcl_delmod

is a support script used to delete a module from a PL/Tcl table. The command requires the Pgtcl package to be installed also.

pltcl_listmod

is a support script used to list the modules in a PL/Tcl table. The command requires the Pgtcl package to be installed also.

pltcl_loadmod

is a support script used to load a module into a PL/Tcl table. The command requires the Pgtcl package to be installed also.

postgres

is the PostgreSQL database server.

postmaster

(deprecated, a symlink to postgres) is a multi-user database daemon.

psql

is a console based database shell.

reindexdb

is a utility for rebuilding indexes in a database.

vacuumdb

compacts databases and generates statistics for the query analyzer.

vacuumlo

remove orphaned large objects from a PostgreSQL database.

libecpg.{so,a}

contains functions to support embedded SQL in C programs.

libecpg_compat.{so,a}

is the ecpg compatibility library.

libgport.a

is the port-specific subsystem of the Postgres backend.

libpgtypes.{so,a}

contains functions for dealing with Postgres data types.

libpq.{so,a}

is the C programmer's API to Postgres.