Say hello to wlv001, my new Linux server. This machine is destined to be my front end Apache box. I have it up and running, but already there have been challenges...

Here are the details on the hardware:

• ASUS RS100-E6/PI2
• Intel® Xeon® Processor X3440
• 8GB 1066MHz DDR3 ECC Reg w/Par CL7 DIMM (Kit of 2) QR, x8 w/Therm Sen
• 2 X Seagate Barracuda 7200.12 SATA 3Gb/s 1TB Hard Drive
• ASUS EN8400GS Silent/P/512M

Social Bookmarks :                                              

  Export this post to PDF document

Add a comment

Posted by Wyatt on December 31, 2010 7:21:00 AM EST #

Download the Windows zip from EnterpriseDB site and unzip to some directory. For this demonstration, I'll assume C:\_apps\pgsql.

C:\>cd \_apps\pgsql

Initialize a new database. This location could be anywhere you like, for simplicity's sake I'll create a directory named data inside the pgsql directory.

C:\_apps\pgsql>mkdir data
C:\_apps\pgsql>bin\initdb.exe -D data

After a series of debug messages you should finally receive the following.

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    "bin\postgres" -D "data"
or
    "bin\pg_ctl" -D "data" -l logfile start

Social Bookmarks :                                              

  Export this post to PDF document

Add a comment

Posted by Wyatt on December 16, 2010 3:36:00 AM EST #