Thread: postgresql help - steps are attatched this time

Downloading the PeerDirect PostgreSQL beta software

First, you need to download the software (3,872kb) from:

Installing the Software itself

Create a directory to install to, eg C:\pgsql. The name of the directory does not really matter but choose a name without spaces if possible.

Extract all files to this new directory.

Move the files from the subdirectory postgres_beta4 that has been created, directly into the pgsql directory. You can then delete the empty postgres_beta4 folder.

Now set the required environment variables.

Click the Windows Start button, then click Settings, then Control Panel and choose System. This will open up the System properties window. Go to the Advanced tab of the System Properties window and click on the Environment Variables button.

Click on the New button located in the System Variables box. A New System Variable box will appear. The first variable name to create is PGHOME, and it points to the directory where PostgreSQL has been placed... C:\pgsql in this case. Click OK.

Now repeat this process for the following variables:
  Variable Name: PGDATA    Variable Value: %PGHOME%\data
  Variable Name: PGLIB     Variable Value: %PGHOME%\lib
  Variable Name: PGHOST    Variable Value: localhost

Next click on Path in the list of System Variables, then click on Edit. Add the following to the end of the Variable Value:
  ;%PGHOME%\bin

Click OK to close the Edit System Variable box then OK to close the Environment Variables box. Click OK to close the System Properties box, then close the Control Panel. The environment is now set up.

The next step is to initialise the Data directory. To do this click on Start then Run and type:
 initdb

To install the service click on Start then Run and type:
 post_svc -install

 The service can be removed later if required by typing:

 post_svc -remove

To start the service click on Start then Run and type:
 pg_ctl start

Note: forwarded message attached.

Hi,

 

I followed the following steps to load postgresql under windows xp.

-Postmaster is running as a process.

-I can use createdb command under data directory

 

but I don't know how to get the pgsql prompt to execute pgsql commands.

 

Can you please help me!!!

 

 

Randeep

comprs2002@yahoo.com