torontosoli.blogg.se

Postgresql documentation
Postgresql documentation










  1. #Postgresql documentation install
  2. #Postgresql documentation free

You may receive a notice regarding that any of the above packages are blocked by any or all of the following packages: dev-db/postgresql-libs, dev-db/postgresql-client, or dev-db/libpq. pt_BR -ro -ru -sk -sl -sv -tr -zh_CN -zh_TW" 0 kB uuid -xml zlib" LINGUAS="-af -cs -de -es -fa -fr -hr -hu -it -ko -nb -pl Nls perl python -pg_legacytimestamp (-selinux) readline ssl -tcl -threads Root # emerge -ask dev-db/postgresql dev-db/postgresql-9.3.5 USE="doc -kerberos -ldap -pg_legacytimestamp Usually pthreadsĮnable server side UUID generation (via dev-libs/ossp-uuid).

#Postgresql documentation install

!!internal use only!! Security Enhanced Linux support, this must be set by the selinux profile or breakage will occurĭisable to build and install the clients and libraries only.Īdd support for SSL/TLS connections (Secure Socket Layer / Transport Layer Security)īuild static versions of dynamic libraries as wellĮnable use of systemd-specific libraries and features like socket activation or session trackingĪdd threads support for various packages. If you want to get meaningful backtraces see Įnable ICU (Internationalization Components for Unicode) support, using dev-libs/icuĪdd LDAP support (Lightweight Directory Access Protocol)Įnable support for lz4 compression (as implemented in app-arch/lz4)Īdd Native Language Support (using gettextGNU locale utilities)Īdd support for PAM (Pluggable Authentication Modules)DANGEROUS to arbitrarily flipĪdd optional support/bindings for the Perl languageĪdd optional support/bindings for the Python languageĮnable support for libreadline, a GNU line-editing library that almost everyone wants Only Gentoo specific issues will be covered and some basic configuration guidelines.Įnable extra debug codepaths, like asserts and extra output. So, a lot of details will be left out in this quick start guide. The official documentation is somewhere in the neighborhood of 2,000 pages. There is quite a bit that will not be covered.

postgresql documentation

Read the PostgreSQL Versioning Policy for more information. That would require migration which is described in this guide.Īdditionally, bug and security fixes, which are delivered via minor version updates, can be applied without fear of corrupting the database or the PostgreSQL installation itself 9.3.4 can be updated to 9.3.5 as they are guaranteed to be compatible and require no more interaction from you than to emerge it and restart the server process neither migration, reconfiguration nor initialization are necessary. Also, this prevents a database, corresponding libraries or executables from being overwritten by an incompatible update. This is useful in such circumstances where you need to move data from an older database to a new database, or need to have a production and a testing database on the same machine. This allows you to have two major versions of PostgreSQL operating simultaneously 9.0-9.4 libraries and servers can be installed and serve at the same time. The PostgreSQL ebuilds in Portage feature slotting based on the major version. Adjust the commands in this article as necessary for your specific version.

postgresql documentation

This article assumes that you will be installing the latest, stable version of PostgreSQL at the time of this writing, the version was 9.3.5. The ebuild covered by this article is dev-db/postgresql. This article will guide you through the Gentoo specific steps to install the PostgreSQL RDBMS. Visit the About page on for more information. It supports such things as transactions, schemata and foreign keys, and is often touted to adhere to the SQL standards more strictly and be more secure, by default, than any other database, commercial or otherwise.

#Postgresql documentation free

PostgreSQL is a free and open source relational database management system (RDBMS). 7.4 "ERROR: timezone directory stack overflow" or "FATAL: too many private dirs demanded".7.3 Missing config files in /etc/postgresql-9.x and /var/lib/postgresql/9.x/data.

postgresql documentation postgresql documentation

  • 7.2 Server lacks instrumentation functions.
  • 5.4 Pre-9.0 migration: From the obsolete ebuilds.
  • 5.3 Pre-9.0 migration: With the new ebuilds.
  • 3.1 Where the configuration files are located.
  • 2.3 Preparing to initialize the database cluster.











  • Postgresql documentation