The Linux Manuals (man pages) document is an important part of Linux documents. Linux Manuals are organized as several sections. Each section has a group of commands for a specific area in Linux usage, administration or development.
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….
pfunc – grep for perl functions Synopsis pfunc subroutine FILES…Descriptionpfunc searches the named FILES for all calls to the given subroutine. It will report back the file and line number each call is found on along with what sort of call it is function foo() class method Class->foo() object method $obj->foo()Example $ pfunc isa /usr/share/perl/5.6.1/*.pm…
Linux NetKit (0.17) Nameftp – Internet file transfer program Synopsisftp [-46pinegvd ] [host [port ] ] pftp [-46inegvd ] [host [port ] ] DescriptionFtp is the user interface to the Internet standard File Transfer Protocol. The program allows a user to transfer files to and from a remote network site. Options may be specified at…
pfrom – fetch a list of the current mail via POP Synopsis[-4 | –krb4 ] [-5 | –krb5 ] [-v | –verbose ] [-c | -count ] [–header ] [-p port-spec | –-port= port-spec ] Descriptionis a script that does push –from. See Alsopush(8)
pamtopfm – Convert PFM (Portable Float Map) image to Netpbm format Synopsispfmtopam [-maxval=n] [-verbose] [imagefile] All options can be abbreviated to their shortest unique prefix. You may use two hyphens instead of one. You may separate an option name and its value with white space instead of an equals sign. DescriptionThis program is part of…
pflogsumm.pl – Produce Postfix MTA logfile summary Copyright (C) 1998-2010 by James S. Seymour, Release 1.1.3. Synopsis pflogsumm.pl -[eq] [-d <today|yesterday>] [–detail <cnt>] [–bounce_detail <cnt>] [–deferral_detail <cnt>] [-h <cnt>] [-i|–ignore_case] [–iso_date_time] [–mailq] [-m|–uucp_mung] [–no_bounce_detail] [–no_deferral_detail] [–no_no_msg_size] [–no_reject_detail] [–no_smtpd_warnings] [–problems_first] [–rej_add_from] [–reject_detail <cnt>] [–smtp_detail <cnt>] [–smtpd_stats] [–smtpd_warning_detail <cnt>] [–syslog_name=string] [-u <cnt>] [–verbose_msg_detail] [–verp_mung[=<n>]] [–zero_fill] [file1 [filen]]…