Обсуждение: Request for information || Begining flow of postgresql

At 5:49pm -0500 Mon, 18 Nov 2013, Rohit Goyal wrote:
> I am very new to postgresql. I want to know from where the Postgresql
> code start to run.
>
> Can you please specify me  the specific file in Postgresql?

Do you mean how to access a running instance of Postgres?  Postgres is a
database, so generally you will access it through another program.  This
program may be an interactive DB administration tool, like PgAdmin, or
it may be an application (such as what one might build with Python or C).

If you want to directly interact with Postgres from the command line,
there is Psql[1].

As you are new to Postgres in general, I would suggest spending an hour
reading the Preface and Tutorial from PostreSQL's amazingly well-written
documentation[2].

If you are looking to develop Postgres, start with [3] and [4].

Cheers,

Kevin

[1] http://www.postgresql.org/docs/current/static/app-psql.html

[2] http://www.postgresql.org/docs/current/static/index.html

[3] http://www.postgresql.org/docs/current/static/internals.html

[4] http://wiki.postgresql.org/wiki/Developer_FAQ

On Mon, Nov 18, 2013 at 11:49 PM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:
> Hi All,
>
> I am very new to postgresql. I want to know from where the Postgresql code
> start to run.
>
> Can you please specify me  the specific file in Postgresql?

Do you mean backend/main/main.c ?

Luca

On Tue, Nov 19, 2013 at 10:22 AM, Rohit Goyal <rhtgyl.87@gmail.com> wrote:

> For example, if I insert a anew row into a table, then a new row in index
> will be inserted. I would like to know the sequential flow of functions or
> files called to insert data into a btree.
>

First of all, this is not a topic for the novice mailing list, rather
for the hackers one.
By I warn you, before asking there, you should have a look at the
documentation about PostgreSQL for developers and try to attach a
debugger to a live session in order to see what is happening behind
the scene.
In the meantime start reading all the READMEs in the backend source
tree, have a look at PageAddItem in storage/page/bufpage.c and
_bt_doinsert in access/nbtree/nbtinsert.c, this should give you an
idea about your questions.

Luca