PostgreSQL kernel parameters and configuration script sharing that need to be modified in CentOS _postgresql

When PostgreSQL is deployed on CentOS, some operating system parameters need to be set up, and some of the official documents are listed (portal). In addition to these, there are other settings, such as the maximum number of processes allowed by a

Introduction to PostgreSQL time and date function usage

First, get the system time function 1.1 Get current full time   code is as follows copy code Select now (); david=# Select Now ();               now              ------------------------- ------  2013-04-12 15:3

CentOS 7 Common PostgreSQL commands

Logged in user After PostgreSQL is installed on CentOS 7, a postgres user is created by default. To use PostgreSQL, we need to switch to that user first: $ sudo-i-U postgres Then enter: $ psql You can enter the PostgreSQL command line. The

PostgreSQL Remote Code Execution Vulnerability (cve-2018-1058) Learning notes

0. Reference documents and Introduction:1. The Prophet Community Chybeta the great god--postgresql Remote Code execution Vulnerability Analysis and utilization-"cve-2018-1058"--a article2, the blog Park Hunchill--mac under the installation and use

The constraints of PostgreSQL

Constraint type: Check constraint, non-null constraint, UNIQUE constraint, primary key, foreign key1. CHECK constraintsSetting a value in a field must satisfy the condition of the constraint expression.Example: Limiting the age of people in 0~120 ,

PostgreSQL 10.0 compressed version of the pgadmin problem

PostgreSQL finally released the 10.0 official version! Download the compressed version of the updated version of the machine, and then open pgadmin always Error "The application server could not be contacted.", tried several methods on the web,

Java Connection PostgreSQL

Recently the company with PostgreSQL this database, see online said this database is still good, I used a bit, I was using Java to connect a database.In fact, each database is connected in roughly the same way, only with different drivers, with

PostgreSQL field name and table name case-sensitive issues

When creating a table, the table name and field name must be all lowercase , and then the query will not be error-able, either full-capitalization or full-lowercase, or camel mode. As long as there are uppercase letters in the name, or all uppercase,

PostgreSQL User Security Configuration

First, configuration instructions:Role Name: User011.user01 Permission Description:Connect to test database, cannot connect to other database when unauthorized;In the specified schema, create \ View \ Delete The table to view the object in the

Table name, field name capitalization problem in "Goto" PostgreSQL

When learning hibernate, the database uses PostgreSQL, the first lesson is thrown wrong, user entity mapping is not alive or alive cannot export the table. Always prompt this sentence:Error:syntax ERROR at or near "User". Later found that if the

PostgreSQL configuration file optimization

PostgreSQL configuration file optimizationConfiguration fileThe default configuration profile is the postgresql.conf file that is saved in the/etc/postgresql/version/main directoryIf you want to see if the parameter modification takes effect, you

[PostgreSQL] Ensure uniqueness in Postgres

Let's say we have a bank. Our bank wants to give each account for each user a unique name, for instance, "Personal" or "Checking." How can we do sure each account have a unique name for each user?ADD UNIQUE constraint when create a new table:CREATE

PostgreSQL----Table Partitioning

--The following description does not remember where it was copied?!Table partitioning is the logical separation of a large table into physical multiple small chunks, table partitioning provides several benefits:1. Some types of query performance can

PostgreSQL Index Classification and usage

1. Indexing methodThe PostgreSQL database supports single index, multi-column composite index, part index, unique index, expression index, implied index, and concurrent index.2. Indexing methodsPostgreSQL supports B-tree, hash, GiST, and GIN index

PostgreSQL Support Sys_guid ()

CREATE or REPLACE FUNCTION "Sys_guid" ()RETURNS "Pg_catalog". " VarChar "AS$BODY $DECLAREV_seed_value varchar (32);BEGINSelectMD5 (Inet_client_addr ():: varchar | |TimeOfDay () | |Inet_server_addr ():: varchar | |To_hex (Inet_client_port ()))into

Configs for PostgreSQL restart and PostgreSQL reload

--Configs requiring PostgreSQL restartselect name, setting, context from pg_settings where context = ' postmaster ';postgres=# select name, setting, contextpostgres-# from pg_settings where context = ' postmaster ';name | setting | Context----------

PostgreSQL partition (Reference)

1 build Large tables.2 Creating partition Inheritance   3 define rule or trigger? 1 Building Large TablesCREATE table student  (student_id bigserial, name varchar (+),  score smallint) 2 create partition Inheritance

PostgreSQL (Linux) Install, start, stop, restart

If we don ' t already has PostgreSQL installed, we must install it.$ sudo apt-get install PostgreSQLThis command installs the PostgreSQL server and various other packages.$ sudo update-rc.d-f postgresql removeremoving any system startup links

Talking about PostgreSQL database

The focus of recent work has been on database design, with this opportunity to take time to sort out some of my PostgreSQL Database Understanding, but also for the recent period of time to learn a summary. For many people who may not have heard of

Processing of null values in PostgreSQL

Processing of null values in PostgreSQL When a field value is null in the addition, subtraction, multiplication, division, and Division operations, the output results often disappoint us and we cannot get the expected values, you can use coalesce to

Total Pages: 77 1 .... 44 45 46 47 48 .... 77 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.