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

1.postgreSQL introduction:

PostgreSQL is a powerful open source object relational database system that uses and extends the SQL language and combines many capabilities to securely store and extend the most complex data workloads.

2.postgreSQL features:

Free, open source, highly scalable. Data integrity, concurrency, reliability, disaster recovery. It's clear.

3.postgreSQL installation:

System environment; Ubuntu16.04 LTS

Install postgreSQL using source code compilation:

Download postgreSQL: # wget-- no-cookies-- the directory where no-check-certificate https://ftp.postgresql.org/pub/source/v9.5.14/postgresql-9.5.14.tar.gz created the installation: # mkdir / data/ {services,packages Untar}-p installation dependency package: # apt-get install-y libreadline6-dev libxslt-dev zlib1g-dev systemtap-sdt-dev libxml2-dev decompression package: # tar-zxvf postgresql-9.5.14.tar.gz-C / data/untar/ # cd / data/untar/postgresql-9.5.14/ #. / configure-- prefix=/data/services/postgresql9\ -- datarootdir=/data/services/postgresql9/postdata\-- with-pgport=5432-- with-python-- with-libxml\-- with-libxslt-- without-ldap-- enable-thread-safety-- enable-dtrace # make & & make install / / prompt after compilation and installation: PostgreSQL installation complete.

Set the postgresql shared library search path:

Method 1: define variables for LD_LIBRARY_PATH. # export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/services/postgresql9/lib method 2: add to the shared library file: # cat / etc/ld.so.conf.d/postgresql.conf / data/services/postgresql9/lib # ldconfig / / effective immediately

Library files are used when linking (static and shared libraries) and running (only programs that use shared libraries), and their search paths are set in the system. In general, Linux systems use / lib and / usr/lib directories as the default library search paths. The purpose of the ldconfig command is to cache the library files under the path listed in / etc/ld.so.conf.d/*.conf to / etc/ld.so.cache for use.

Add shared library to linux system details: https://blog.csdn.net/lu_embedded/article/details/56675653

View the shared library:

Set the environment variable:

# echo "export PATH=$PATH:/data/services/postgresql9/bin" > > / etc/profile # source / etc/profile / / effective immediately.

Create a postgres account and set the password:

# useradd-d / data/services/postgresql9/-M postgres # echo-e "123456\ n123456" | passwd postgres changes the owner and group: # chown-R postgres.postgres / data/services/postgresql9/

Create the data directory and initialize the data directory:

# mkdir / data/services/postgresql9/data # su-postgres $bin/initdb-D / data/services/postgresql9/data/

Modify the configuration file: # grep-Ev'^ [] * $| ^ # / data/services/postgresql9/data/postgresql.conf data_directory ='/ data/services/postgresql9/data' # database installation path Directory for data storage hba_file ='/ data/services/postgresql9/data/pg_hba.conf' # Host-based authentication file ident_file ='/ data/services/postgresql9/data/pg_ident.conf' # configuration file for user name mapping external_pid_file ='/ data/services/postgresql9/postgresql.pid' # for extra management programs The process pid file listen_addresses ='*'# specifies the TCP/IP addresses on which the server listens for client connections port = 5432 # listening on the database TCP port max_connections = 100 # maximum number of connections. Unix_socket_directories ='/ tmp' # listens on the socket directory from the Unix domain of the client connection shared_buffers = 128MB # sets the amount of shared memory buffers that the database server will use, the default value. Dynamic_shared_memory_type = posix # specifies that the server uses POSIX shared memory allocated by shm_open. Log_line_prefix ='% t [% pmurl% l]% Q% ubiquitous% d' # sets the log output format. Log_timezone = 'PRC' # sets the time zone that database log files use when writing log files, datestyle =' iso, ymd' # date style, timezone = 'PRC' # sets server and client time zones. Lc_messages = 'en_US.UTF-8' # language of the system error message. Lc_monetary = 'zh_CN.UTF-8' # sets the language in which currency values are displayed lc_numeric =' zh_CN.UTF-8' # sets the language used to format numbers. Lc_time = 'zh_CN.UTF-8' # sets the language used to format the time and date. Default_text_search_config = 'pg_catalog.english' # Select the text search configuration used by the text search feature.

Set the language and encoding settings of the system under ubuntu16.04:

# apt-get install-y language-pack-zh-hant language-pack-zh-hans language-selector-gnome # dpkg-reconfigure locales choose zh_CN.UTF-8 and en_US.UTF-8 encoding. Encoding configuration file: / var/lib/locales/supported.d/ there are three files under this file: en zh-hans zh-hant # dpkg-reconfigure-- force locales forces updates for the settings to take effect.

Start the service:

$bin/pg_ctl-D / data/services/postgresql9/data/-l logfile start or: $. / bin/postmaster-D / data/services/postgresql9/data > logfile 2 > & 1 &

two。 Connect to the postgresSQL:

$. / bin/psql

View client character encodings:

View the server character encoding:

Console commands for PostgreSQL:

\ h: view the SQL command explanation. \?: view a list of psql commands. \ I sqlfile: call the file with the suffix sql and output it. \ l: list all databases. \ C [databasename]: connect to other databases. \ d: lists all tables in the current database. \ d [tablename]: lists the table structure. \ d + [tablename]: view the basic situation of the table. \ du: list all users. \ e: open a text editor. \ conninfo: lists the current database and connection information.

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.