PostgreSQL database is the core of the SQL-Ledger accounting ERP solution where all accounting information is saved. So, a database needs to be in place before we can get to the business of installing and using SQL-Ledger. We have provided. the latest version, 8.3, of the PostgreSQL database server in the DVD. Extract the msi installer to a temporary directory and start the installation by executing the msi installer file. Follow the instructions in the PostgreSQL Installation Wizard dialog box and when it prompts for Installation options. do not select default settings. instead click on PostgreSQL in the menu tree and select 'Entire Feature will be installed on local hard drive.' And then click on the Next button. In the Server Configuration dialog box. we need to provide a User AccountName and its password. To create a user. right-click on My Computer and select Manage. The Computer Management window opens up. Here, expand the node of Local Users and Groups, and select Users. Now through Action New User. create a new user having User Name as "postgres" and Password as "postgres". Also in the ew User dialog box. uncheck the option for "User must change password at next logon".

Now provide the same user name and password in the Server Configuration dialog box of the PostgreSQL installation Wizard and click on Next. In the Initialize Database screen. set the Port number as 5432 and pass the Superuser Name and password as "postgres" and then complete the installation. Now log on to the database as postgres user; for this goto Start Run and type the following as the Run command:

Name: SQL-Ledger's.jpg Views: 623 Size: 69.8 KB

The screen that pops up prompts for a password. Enter the password that was set for the User ame "postgres" while creating the user from Computer management window. Once you enter the password and click enter. a new command prompt window comes. Here, change the directory to the bin directory of base installation of PostgreSQL server (in our case with all default settings as during installation). The directory happens to be "C:\Program Files\PosrgreSQL\8.3\bin". At the command prompt. after changing to PostgreSQL's bin directory. type the following command to create a new user for the SQL-Ledger database.

The final configuration step for PostgreSQL database is to set the client authentication for local TCP/IP connection. which can be set through file found in the data directory of PostgreSQL base installation. Open the file using otepad and at the bottom. where settings for IPv4 local connections are given. change the Method to trust from md5 and save the file.