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
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 work22.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 configuration26.4. WAL internal
27. Return test
27.1. Run test
27.2. Test assessment
27.3. Platform related comparison file