Cheap web hosting - 586 CHAPTER 25 INSTALLING POSTGRESQL 2. User

586 CHAPTER 25 INSTALLING POSTGRESQL 2. User Interfaces: This category includes the psql and pgAdmin III GUI applications, both of which are scheduled for installation by default. Both applications are introduced in Chapter 27. 3. Database Drivers: This category includes the JDBC, Npgsql, ODBC, and OLEDB drivers, all of which are scheduled for installation by default. If you don t plan to use PostgreSQL in conjunction with Java-, .NET-, ODBC-, or OLEDB-compatible technologies, respectively, then cancel their installation to save some drive space. 4. Development: This category includes various development-related files and utilities, all of which are not scheduled for installation by default and are not required for the purposes of this book. During this stage you also have the opportunity to change the installation directory, with the default being set to C:Program FilesPostgreSQLX.X. Because spaces in pathnames can be somewhat of an annoyance when writing scripts, consider changing this to C:pgsql or something similar. Once this is complete, click Next to continue. 4. Service Configuration: This step involves setting several very important parameters: 1. Install as a Service: You re first prompted to install PostgreSQL as a service, which means it will turn on and off automatically along with the operating system. You ll learn more about running PostgreSQL as a service in the later section, Starting and Stopping PostgreSQL Automatically. When running PostgreSQL as mission-critical applications, you ll certainly want to leave this enabled; however, for testing environments, you may choose to start and stop it manually. Doing so is also covered in the aforementioned section. If you choose to not install PostgreSQL as a service, then the remaining five parameters are irrelevant, so you should continue to Step 5. 2. Service Name: If you do choose to install PostgreSQL as a service, this field represents the name of the service; you can set this field to anything you please, although the default is just fine. 3. Account Name: This field specifies the name of the user who owns the PostgreSQL daemon process. Consider leaving this set to postgres(unless you have good reasons for doing otherwise), which causes this account to be created and used expressly for operating the PostgreSQL daemon. You re also free to specify the name of an existing account; however, this account cannot be a privileged user, such as Administrator! 4. Account Domain: This field specifies the server s commonly used network name. This is set to your server s specified domain name by default. 5. Daemon Account: Finally, you re prompted to enter and verify a password via the Account password and Verify password fields, respectively. Be sure to choose a sufficiently difficult password, yet something you can remember. You also have the option of leaving this blank, which prompts PostgreSQL to create a random password for you. If you allow PostgreSQL to choose the password, it will not communicate the password to you, because this account should be used for no purpose other than to operate the daemon account, and therefore there is no particular reason to know this password.
If you are looking for cheap and quality webhost to host and run your website check Jboss Web Hosting services.

Leave a Reply