pgmabel – create cross section using Abel Integration for Deconvolution Synopsispgmabel [-help] [-axis axis] [-factor factor] [-pixsize pixsize] [-left | -right] [-verbose] [filespec] DescriptionThis program is part of Netpbm(1) pgmabel reads as input a PGM image, which it assumes to be an image of a rotational symmetric transparent object. The image must have a vertical…
pgcenter – is the PostgreSQL administration console with top-like monitoring. Synopsispgcenter [OPTION]… [DBNAME [USERNAME]] DescriptionPostgreSQL provides various statistics which includes information about tables, indexes, functions and other database objects and their usage. Moreover, statistics has information about connections, current queries and database operations (INSERT/DELETE/UPDATE). But most of this statistics are provided as permanently incremented counters….
pgbench – run a benchmark test on PostgreSQL Synopsis pgbench -i [option…] [dbname] pgbench [option…] [dbname]Descriptionpgbench is a simple program for running benchmark tests on PostgreSQL. It runs the same sequence of SQL commands over and over, possibly in multiple concurrent database sessions, and then calculates the average transaction rate (transactions per second). By default,…
gawk – pattern scanning and processing language Synopsisgawk [ POSIX or GNU style options ] -f program-file [ — ] file … gawk [ POSIX or GNU style options ] [ — ] program-text file … pgawk [ POSIX or GNU style options ] -f program-file [ — ] file … pgawk [ POSIX or…
pg_upgrade – upgrade a PostgreSQL server instance Synopsis pg_upgrade -b oldbindir -B newbindir -d olddatadir -D newdatadir [option…]Descriptionpg_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/reload typically required for major version upgrades, e.g. from 8.4.7 to the current major release…
pg_top – display and update information about the top cpu PostgreSQL processes Synopsispg_top [ OPTIONS ] [ NUMBER ] Descriptionpg_top displays the top processes on the system and periodically updates this information. Raw cpu percentage is used to rank the processes. If number is given, then the top number processes will be displayed instead of…
pg_test_timing – measure timing overhead Synopsis pg_test_timing [option…]Descriptionpg_test_timing is a tool to measure the timing overhead on your system and confirm that the system time never moves backwards. Systems that are slow to collect timing data can give less accurate EXPLAIN ANALYZE results. Optionspg_test_timing accepts the following command-line options: -d duration, –duration=duration Specifies the test…
pg_test_fsync – determine fastest wal_sync_method for PostgreSQL Synopsis pg_test_fsync [option…]Descriptionpg_test_fsync is intended to give you a reasonable idea of what the fastest wal_sync_method is on your specific system, as well as supplying diagnostic information in the event of an identified I/O problem. However, differences shown by pg_test_fsync might not make any difference in real database…
pg_standby – supports the creation of a PostgreSQL warm standby server Synopsis pg_standby [option…] archivelocation nextwalfile xlogfilepath [restartwalfile]Descriptionpg_standby supports creation of a “warm standby” database server. It is designed to be a production-ready program, as well as a customizable template should you require specific modifications. pg_standby is designed to be a waiting restore_command, which is…
pg_restore – restore a PostgreSQL database from an archive file created by pg_dump Synopsis pg_restore [connection-option…] [option…] [filename]Descriptionpg_restore is a utility for restoring a PostgreSQL database from an archive created by pg_dump(1) in one of the non-plain-text formats. It will issue the commands necessary to reconstruct the database to the state it was in at…
pg_resetxlog – reset the write-ahead log and other control information of a PostgreSQL database cluster Synopsis pg_resetxlog [-f] [-n] [-o oid] [-x xid] [-e xid_epoch] [-m mxid] [-O mxoff] [-l timelineid,fileid,seg] datadirDescriptionpg_resetxlog clears the write-ahead log (WAL) and optionally resets some other control information stored in the pg_control file. This function is sometimes needed if these files have become corrupted. It…
pg_receivexlog – streams transaction logs from a PostgreSQL cluster Synopsis pg_receivexlog [option…]Descriptionpg_receivexlog is used to stream transaction log from a running PostgreSQL cluster. The transaction log is streamed using the streaming replication protocol, and is written to a local directory of files. This directory can be used as the archive location for doing a restore…
pg_dumpall – extract a PostgreSQL database cluster into a script file Synopsis pg_dumpall [connection-option…] [option…]Descriptionpg_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(1) to restore the databases. It does this by calling…
pg_dump – extract a PostgreSQL database into a script file or other archive file Synopsis pg_dump [connection-option…] [option…] [dbname]Descriptionpg_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). Dumps can be…
pg_ctl – initialize, start, stop, or control a PostgreSQL server Synopsis pg_ctl init[db] [-s] [-D datadir] [-o initdb-options] pg_ctl start [-w] [-t seconds] [-s] [-D datadir] [-l filename] [-o options] [-p path] [-c] pg_ctl stop [-W] [-t seconds] [-s] [-D datadir] [-m s[mart] | f[ast] | i[mmediate]] pg_ctl restart [-w] [-t seconds] [-s] [-D datadir] [-c] [-m s[mart] | f[ast] | i[mmediate]] [-o options] pg_ctl reload [-s] [-D datadir] pg_ctl status [-D datadir] pg_ctl promote [-s] [-D datadir] pg_ctl kill…
pg_controldata – display control information of a PostgreSQL database cluster Synopsis pg_controldata [option] [datadir]Descriptionpg_controldata prints information initialized during initdb, such as the catalog version. It also shows information about write-ahead logging and checkpoint processing. This information is cluster-wide, and not specific to any one database. This utility can only be run by the user who…
pg_config – retrieve information about the installed version of PostgreSQL Synopsis pg_config [option…]DescriptionThe pg_config utility prints configuration parameters of the currently installed version of PostgreSQL. It is intended, for example, to be used by software packages that want to interface to PostgreSQL to facilitate finding the required header files and libraries. OptionsTo use pg_config, supply…
pg_basebackup – take a base backup of a PostgreSQL cluster Synopsis pg_basebackup [option…]Descriptionpg_basebackup is used to take base backups of a running PostgreSQL database cluster. These are taken without affecting other clients to the database, and can be used both for point-in-time recovery (see Section 24.3, “Continuous Archiving and Point-in-Time Recovery (PITR)”, in the documentation)…
pg_archivecleanup – clean up PostgreSQL WAL archive files Synopsis pg_archivecleanup [option…] archivelocation oldestkeptwalfileDescriptionpg_archivecleanup is designed to be used as an archive_cleanup_command to clean up WAL file archives when running as a standby server (see Section 25.2, “Log-Shipping Standby Servers”, in the documentation). pg_archivecleanup can also be used as a standalone program to clean WAL file…
pg – browse pagewise through text files Synopsispg [–number] [-p string] [-cefnrs] [+line] [+/pattern/] [file…] Descriptionpg displays a text file on a CRT one screenful at once. After each page, a prompt is displayed. The user may then either press the newline key to view the next page or one of the keys described below….