backend process

On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote:

I'm a new user of postgreSQL

I was loking at the documentation and testing some
things and I make:

select * from pg_stat_database;

pg_stat_database is writen on the table of page 317,
one os the outputs is numbackends that is the number
of
active backend server processes. I would like to know
what is a active backend server processes.

In PostgreSQL every connection spawns a new backend that operates on the
database semi-independently, cooperating with the other backends by
means of shared memory.

Scott Marlowe <smarlowe@g2switchworks.com> writes:

On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote:

active backend server processes. I would like to know
what is a active backend server processes.

In PostgreSQL every connection spawns a new backend that operates on the
database semi-independently, cooperating with the other backends by
means of shared memory.

See
http://www.postgresql.org/docs/8.0/static/tutorial-arch.html
http://www.postgresql.org/docs/8.0/static/connect-estab.html

regards, tom lane