Server management

Server Select

The server now hosted or leased, it is self-purchasing ordinary accessories in the computer city, and it is assembled. In these people, the server is just a high-end home. Desktop. The server mainly experiences the security and system stability of the data, and more well-known server brands generally provide thermal plugging in dual power and hard drives, which is difficult to implement on their own assembled servers. These are the main differences, but as a brother of the poor, it is estimated that it is economically difficult to purchase well-known brand server. In this case, Xun Tian Technology believes that the webmaster brothers should choose the most cost-effective server. Hard truth.

Try to choose the server you use yourself, do not cause waste of resources. Now people have money, they don't move, they will do a double to strong. When they come, they found that the website often can't open, and it really thought that their traffic is high, but it is not necessarily. You have to know that now the website is slow, the interoperability of telecommunications and Unicom should first consider.

First, the switch hierarchy where the server hosted

The layout of the computer room is located is generally the switch to the Gigabit switch to the traffic switch to the cabinet, one server to the middle of the router How many routes have, perhaps only the engineers of the machine room know that regular machine rooms are not allowed to enter the main switch room, nor allowing access to others, only allowing the company where the company is located.

Second, the number of servers in the cabinet is

as a server rental, you want to make the server beat the server, so that he can put a few more in a cabinet. Machine. Fortunately, the current server is not so small, but to make such a high cost, use it to earn money, so it is useless. According to the cabinet of the computer room, it is generally 48U cabinet. You can put 24 machines. There is a shelf between the machine and the machine, where there is a heat dissipation, so 24 sets, but I don't guarantee up to 24. There is a black heart IDC, even the space does not let go, directly put him 30 servers. So if your server hosts in the cabinet with a lot of servers, and this cabinet is just a large traffic customer, then you will find your server is slower than the virtual host.

Book Introduction

This book is generally arranged in the reading order of a new user. But every chapter is self-contained, you can read independently. This book information is arranged in accordance with the aforementioned style. If the reader needs to view a complete description of a specific command, then you should look at the Part VI.

Content characteristics

The style of writing is to let friends who don't have a good knowledge can understand, so those who need to make their own servers can start to browse this book. Book. The other parts of this book are relevant to regulation and management, this part of the material assumes readers are things that readers who often use the PostgreSQL database system should be familiar. We encourage readers to read Part I and Part II to get additional information.

Works directory

Table of Contents

14. Installation Guide

14.1. Simplicity

14.2. Requires

14.3. Get source code

14.4. If you are upgrading

14.5. Installation process

14.6. After installation, set < /> (P>

15.Services installation client

16. Operating system environment

16.1. PostgreSQL User Account

16.2. Create a database cluster

16.3. Start database server

16.4. Manage kernel resources

16.5. Close Server

16.6. Encryption option

16.7. Safety TCP / IP linkage

16.8 with SSL. Safety TCP / IP connection with SSH tunnel

17. Server configuration

17.1. Setting parameter

17.2. File location

17.3. Connection and authentication

17.4. Resource consumption

17.5. Solden log

17.6. Query planning

17.7. Error report and log

17.8. Runtime statistics //> (清理

17.11. Lock Manage

Server management

17.12. Version and Platform Compatibility

17.12. /> (P)

17.14. Customized option

17.15. Developer option

17.16. Short option

18. Database role and permissions

18.1. Database role

18.2. Role property

18.3. Permissions

18.4. Role member

18.5. Function and trigger

19. Manage database

19.1. Overview

19.2. Create Database < /> (PLAD)

19.4. Database Configuration

19.5. Delete Database

19.6. Table space

20. User authentication

20.1. Pg_hba.conf file

20.2. Certification Law

20.3. Authentication problem

21. Area

21.1. Area support

21.2. Character set Support

< P> 22. Daily database maintenance work

22.1. Daily cleaning

22.2. Reconstruction of index

22.3. Log file maintenance

23. Backup and recovery

23.1. SQL dump

23.2. Backup of file system level

23.3. Online backup, instant recovery (Pitr)

23.4. Migrate

24 between different versions. Monitor database activities

24.1. Standard UNIX Tool

24.2. Statistical Collector

24.3. View the lock

25. Observe the use of disk usage

25.1. Judgment the amount of usage of the disk

25.2. Disk is full Failure

26. Reliability and Precraft Logs

26.1. Reliability

26.2. Prenivation Log (WAL)

< P> 26.3. WAL configuration

26.4. WAL internal

27. Return test

27.1. Run test

27.2. Test assessment

27.3. Platform related comparison file

Related Articles