Steps for installing Postgresql in Eclipse

Modified from http://wiki.postgresql.org/wiki/Working_with_Eclipse
you can use this link to see the snapshots of the proceedings wherever applicable.

Requirements:

Ubuntu OS, Eclipse for C/C++, CVS (if you use CVS below)

You can set up PostgreSQL either by downloading a copy of the sources and using CVS for version control, or by using the PostgreSQL repository directly from Eclipse (after installing eGit). Instructions for both options are below, you can use either one

Setting up PostgreSQL with GIT

git clone -b REL_16_4 --single-branch https://git.postgresql.org/git/postgresql.git

Setting up PostgreSQL with Eclipse Using GIT

Eclipse should have git built in. If your version does not, first install git support by using Help > Install New Software).
Open File => Import, select Git => Projects from Git and click Next. Select "URI" and click Next.a Now you will have to enter the repository's location as https://git.postgresql.org/git/postgresql.git
Deselect all branches, then select 14 (or 14.5) Stable and proceed to clone Postgresql.
After this software is downloaded, which may take a while. Finally you will come to a software import wizard. Choose New Project Wizard and click on next.
Select the C/C++, Makefile Project with Existing Code and click next; you will then have to enter the code location which will be of the form "homedir/git/postgresql" (replace "homedir" with your home directory path, e.g. /home/sudarsha).
Click on Finish
Your project should now be ready (under the name "postgresql")
Don't try building your project using eclipse yet. Follow steps below first to configure eclipse, before doing a make.

Configuring PostgreSQL

IMPORTANT Read all instructions in this section, and then follow the steps in Steps in building and running PostgreSQL to set up environment variables and then configure, build, and install postgresql.
In case the make fails during build due to missing libraries, make sure they are installed using your Ubuntu software center or synaptic package manager (or equivalent). Some of the packages that are often missing and needed are:
- libreadline6-dev
- zlib1g-dev
- bison
- flex

Run Configurations in Eclipse:

First make sure you have configured postgresql, created a database, run postgresql in single mode successfully. After that, switch back to Eclipse.
Select the Project Explorer view. If you cannot see it, add it with the button in the left bottom.
In the Project Explorer view right click on the Projectname (postgres or postgresql-14), and select "Run As >> Run Configurations".
Select "C/C++ Application:", and click on the new configuration button on the top left (the text on the right helps you identify the button).
The path to the postgres binary should be added in the box titled C/C++ application; for example, "/home/sudarsha/git/postgresql14/install/bin/postgres"
Switch to the tab "Arguments". At "Program arguments" type the arguments
"--single -D PGDATADIR test"
where PGDATADIR is the directory where the database was created, e.g "/home/sudarsha/git/postgresql/install/data"
and test is the name of the database you created following the instructions in http://www.cse.iitb.ac.in/dbms/Data/Courses/CS631/PostgreSQL-Resources/pgsql_demo.txt
Then click the "Apply" button. Click "Run" to start the program. should see following in your console:

PostgreSQL stand-alone backend 14.5
backend>

You can run your commandss here, and you can press ctrl-D to exit. To start up the console again, choose the project, and click on the Run button (a green button with a play/rightarrow symbol)
(In server mode you will see the message: LOG: database system was shut down at (current date and time) UTC
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
)