Abbreviations in PostgreSQL database
Abbreviations in PostgreSQL database.
- WAL buffers ==> write ahead log buffers
- psql command ==> postgreSQL command
- CRUD operations ==> Create, Read, Update, Delete
- MCC or MVCC ==> Multiversion concurrency control
- LSN ==> Log Sequence Number
- PITR ==> Point In Time Recovery
- pg_hba.conf ==> Enables client authentication between postgreSQL server and the client application
- hba ==> host based authentication
- pg_ident.conf ==>User name maps are defined in the ident map file, which by default is named pg_ident.conf and is stored in the cluster’s data directory
- pg_catalog ==>tables that store schema metadata and internal bookkeeping information for PostgreSQL databases
- pg_basebackup ==> we can take base backups of a running PostgreSQL database cluster using pg_basebackup command.
- pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers).
- pg_restore ==>pg_restore is a utility for restoring a PostgreSQL database from an archive created by pg_dump in one of the non-plain-text formats
- Pgadmin ==> The pgAdmin package is a free and open-source graphical user interface (GUI) administration tool for PostgreSQL
- pg_dumpall ==> pg_dumpall is a utility for writing out (“dumping”) all PostgreSQL databases of a cluster into one script file. The script file contains SQL commands that can be used as input to psql to restore the databases. It does this by calling pg_dump for each database in the cluster. pg_dumpall also dumps global objects that are common to all databases, namely database roles, tablespaces, and privilege grants for configuration parameters. (pg_dump does not save these objects.)
- pg_upgrade ==> pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/restore typically required for major version upgrades, e.g., from 12.14 to 13.10 or from 14.9 to 15.5. It is not required for minor version upgrades, e.g., from 12.7 to 12.8 or from 14.1 to 14.5.
See also