CHAPTER 25 INSTALLING POSTGRESQL 5. Initialize the (Abyss web server)
CHAPTER 25 INSTALLING POSTGRESQL 5. Initialize the Database Cluster: If you chose to install PostgreSQL as a service, you also have the option to further tweak the server s default configuration. Pictured in Figure 25-1, this screen s title may be a tad misleading to some readers, as cluster tends to be defined as a database or other server type consisting of more than one node. However, the PostgreSQL community defines this term as a collection of databases accessed through a particular daemon instance. With that in mind, you can see that there are several options presented on this screen: 1. Initialize Database Cluster: This option determines whether the database cluster should be initialized (created). Of course, you want to leave this enabled. 2. Port Number: By default, the PostgreSQL server accepts connections on port 5432. Unless you have specific reasons for changing this value, using port 5432 is fine. 3. Addresses: Left unchecked, this setting disallows any PostgreSQL connections other than those originating from the local server. If you plan to run PostgreSQL and the application on the same server (for instance, run a Web site in which both the Web and database server reside on the same machine), leave this unchecked. Otherwise, enable this feature. If you require the ability to connect from remote locations, keep in mind that this isn t the only required step. You also need to modify the pg_hba.conf file, introduced in Chapter 29. 4. Locale: This setting determines PostgreSQL s default locale, which defines settings specific to a particular culture, such as character, number, and monetary formatting and character ordering. Over 150 locales are presently supported, including locales targeting areas as far flung as Greece, Finland, Ecuador, and Thailand. If you re in the United States, set this value to English, United States. 5. Encoding: Because of the disparity of characters, accent marks, and character ordering among languages, you want to make sure that PostgreSQL properly handles encoding according to your specific needs. You do so by choosing the proper encoding with this option. By default this is set to SQL_ASCII. 6. PostgreSQL Administrator Account: Next up are the administrator (Superuser) name and corresponding Password fields. Note that this is different from the previously created account used to operate the service daemon it s the PostgreSQL account that you ll use to administer the internal server workings such as user and database creation. For security reasons, the chosen password should in no circumstances be the same as that used for the service daemon user, assuming that you specified one rather than allowing PostgreSQL to choose one for you. By default, this username is set to postgres, although you re free to choose any name you please.
You want to have a cheap webhost for your apache application, then check apache web hosting services.