Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Detailed explanation of PostgreSQL configuration parameters and solutions to configuration errors (2)

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

. / configure compilation parameter description:-- prefix specifies the installation directory. -- bindir specifies the directory of the executable program-- sysconfdir sets the directory of various configuration files by default. -- libdir sets the location where libraries and dynamically loadable modules are installed. -- includedir sets the directory where C and C + + header files are installed-- datarootdir sets the root of various types of read-only data files. Share directory. -- datadir sets the directory of read-only data files used by the installer. The default is DATAROOTDIR. -- localedir sets the directory used to install locale data. The default is DATAROOTDIR/locale. The man pages included with mandir PostgreSQL will be installed in this directory. Man directory. -- docdir sets the root of the installation documentation file. -- htmldir PostgreSQL's HTML format documents will be installed in this directory. The default is DATAROOTDIR. -- with-extra-version = STRING appends STRING to the PostgreSQL version number-- with-libraries is used to search the base. Enable-nls enables native language support (NLS), that is, the ability to display program messages in languages other than English. -- with-pgport is set to the default port number of the server and client. The default value is 5432. With-perl supports the perl language. With-python supports the python language. With-TCL supports the PL/Tcl language. -- with-tclconfig contains the configuration information needed to build a module that interfaces with Tcl. The with-GSSAPI build supports GSSAPI authentication. -- with-openssl build supports SSL (encrypted) connections-- with-pam supports construction using PAM (pluggable authentication module).-- with-ldap uses LDAP to support construction authentication and connection parameter lookup.-- without-readline disables command line editing and history in psql.-- with-libedit-preferred facilitates the use of BSD-licensed libedit libraries. Readline is used by default. -- with-bonjour builds using Bonjour support-- with-uuid=LIBRARY builds uuid-ossp modules using specified UUID libraries.-- with-libxml builds using libxml (enable SQL/XML support).-- with-libxslt uses libxslt when building xml2 modules. Xml2 relies on this library to perform the XSL transformation of XML. -- disable-integer-datetimes disables support for 64-bit integer storage for timestamps and intervals and stores date-time values as floating-point numbers. -- disable-float4-byval disables passing float4 values by value, causing them to be passed "by reference". This option degrades performance.-- disable-float8-byval disables passing float 8 values by value, causing them to be passed "by reference". This option degrades performance.-- with-segsize=SEGSIZE sets the segment size in gigabytes. The large table is divided into multiple operating system files, each of which is equal to the segment size-- with-blocksize=BLOCKSIZE sets the block size in kilobytes. This is the storage unit and I / O in the table. The default value is 8 kilobytes-with-wal-segsize=SEGSIZE sets the WAL segment size in megabytes. This is the size of each file in the WAL log. It may be useful to adjust this size to control the granularity of WAL log shipping. The default size is 16 megabytes. The value must be a power of 2 between 1 and 64 megabytes.-- with-wal-blocksize=BLOCKSIZE sets the WAL block size in kilobytes. This is the storage and I / O unit in the WAL log. The default value is 8 kilobytes. The value must be a power of 2 between 1 and 64 megabytes.-- disable-spinlocks disables ring locks. -- disable-thread-safety disables thread safety, and disables thread safety of client libraries. With-system-tzdata=DIRECTORYPostgreSQL contains its own time zone database, which requires date and time operations. The default is compatible with the linux time zone. -- without-zlib prevents the use of Zlib libraries. -- enable-debug compiles all programs and libraries using debug symbols. Enable-depend enables automatic dependency tracking. -- enable-dtrace compiles PostgreSQL and supports the dynamic tracking tool DTrace. -- enable-tap-tests enables testing using the Perl TAP tool.

Compilation error:

1. Readline reported an error:

Solution: check out the readline library: # ldconfig-p | grep readline # apt-get install-y libreadline6-dev

Solution: # apt-get install-y zlib1g-dev

Solution: # apt-get install-y libxml2-dev

Solution: # apt-get install-y systemtap-sdt-dev libxslt-dev

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report