tailieunhanh - Beginning Databases with Postgre SQL phần 2

chương này, chúng tôi sẽ xem xét cài đặt và thiết lập PostgreSQL trên hệ điều hành khác nhau. Nếu bạn cần phải cài đặt nó trên một hệ thống Linux, các gói nhị phân biên dịch sẵn cung cấp một con đường dễ dàng. Nếu bạn đang chạy hệ điều hành UNIX | II II CHAPTER 3 Getting Started with PostgreSQL In this chapter we will look at installing and setting up PostgreSQL on various operating systems. If you need to install it on a Linux system precompiled binary packages provide an easy route. If you are running a UNIX or UNIX-like system such as Linux FreeBSD AIX Solaris HP-UX or Mac OS X it is not difficult to compile PostgreSQL from the source code. We will also cover how to install and set up PostgreSQL on Windows platforms using the Windows installer introduced in PostgreSQL version . Earlier versions can be installed on Windows but this requires some additional software to create a UNIX-like environment. We therefore recommend version or later for Windows systems. Finally we will prepare for the examples in the following chapters by creating the sample database discussed in Chapter 2. In particular this chapter will cover the following topics Installing PostgreSQL from Linux binaries Installing PostgreSQL from the source code Setting up PostgreSQL on Linux and UNIX systems Installing and setting up PostgreSQL on Windows Creating a database with tables and adding data Installing PostgreSQL on Linux and UNIX Systems If you are running a Linux system installed from a recent distribution you may already have PostgreSQL installed or available to you as an installable package on the operating system installation disks. If not you can use RPM packages to install PostgreSQL on many Linux distributions or flavors. Additionally you can build and install PostgreSQL from the source code on just about any UNIX-compatible system. 43 44 CHAPTER 3 GETTING STARTED WITH POSTGRESQL Installing PostgreSQL from Linux Binaries Probably the easiest way to install PostgreSQL on Linux is by using precompiled binary packages. The binaries for PostgreSQL are available for download as RPM RPM Package Manager formerly Red Hat Package Manager packages for various Linux distributions. At the time of writing this book RPM packages are .