NAME pg_test_timing – measure timing overhead SYNOPSIS pg_test_timing [option…] DESCRIPTION pg_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. OPTIONS pg_test_timing accepts the following command-line options: -d duration,…
NAME pg_test_fsync – determine fastest wal_sync_method for PostgreSQL SYNOPSIS pg_test_fsync [option…] DESCRIPTION pg_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…
NAME pg_standby – supports the creation of a PostgreSQL warm standby server SYNOPSIS pg_standby [option…] archivelocation nextwalfile xlogfilepath [restartwalfile] DESCRIPTION pg_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…
NAME pg_restore – restore a PostgreSQL database from an archive file created by pg_dump SYNOPSIS pg_restore [connection-option…] [option…] [filename] DESCRIPTION pg_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…
NAME 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] datadir DESCRIPTION pg_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…
NAME pg_receivexlog – streams transaction logs from a PostgreSQL cluster SYNOPSIS pg_receivexlog [option…] DESCRIPTION pg_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…
NAME pg_dumpall – extract a PostgreSQL database cluster into a script file SYNOPSIS pg_dumpall [connection-option…] [option…] DESCRIPTION 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(1) to restore the databases. It does…
NAME pg_dump – extract a PostgreSQL database into a script file or other archive file SYNOPSIS pg_dump [connection-option…] [option…] [dbname] DESCRIPTION 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)….
NAME 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…
NAME pg_controldata – display control information of a PostgreSQL database cluster SYNOPSIS pg_controldata [option] [datadir] DESCRIPTION pg_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…
NAME pg_config – retrieve information about the installed version of PostgreSQL SYNOPSIS pg_config [option…] DESCRIPTION The 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. OPTIONS…
NAME pg_basebackup – take a base backup of a PostgreSQL cluster SYNOPSIS pg_basebackup [option…] DESCRIPTION pg_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)”,…
NAME pg_archivecleanup – clean up PostgreSQL WAL archive files SYNOPSIS pg_archivecleanup [option…] archivelocation oldestkeptwalfile DESCRIPTION pg_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…
NAME pg – browse pagewise through text files SYNOPSIS pg [–number] [-p string] [-cefnrs] [+line] [+/pattern/] [file…] DESCRIPTION pg 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…
NAME pfunc – grep for perl functions SYNOPSIS pfunc subroutine FILES… DESCRIPTION pfunc 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…
Linux NetKit (0.17) NAME ftp – Internet file transfer program SYNOPSIS ftp [-46pinegvd ] [host [port ] ] pftp [-46inegvd ] [host [port ] ] DESCRIPTION Ftp 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…
NAME 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 ] DESCRIPTION is a script that does push –from. SEE ALSO push(8) Index
NAME pamtopfm – Convert PFM (Portable Float Map) image to Netpbm format SYNOPSIS pfmtopam [-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. DESCRIPTION This program…
NAME 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]] pflogsumm.pl – [help | version] If no file(s) specified, reads from stdin.Output is to stdout. DESCRIPTION Pflogsumm is a log analyzer/summarizer for the Postfix MTA. It…
NAME pfcat – grep out function definitions from perlfunc DESCRIPTION This program uses podgrep program to search your configuration’s perlfunc for function definitions. It honors a -f flag to format through pod2text and a -p flag to send the output through the pager. (Actually, it just passes these to podgrep.) EXAMPLES $ pfcat seek (find…