Let's learn postgreSQL

First you have start the postgreSQL server.... # /etc/init.d/postgresql start step:1 Allow remote access to postgresql database.... First you open the file called /etc/postgresql/pg_hba.conf. # vim /etc/postgresql/8.1/main/pg_hba.conf Now append the following line. host all all ip_address net_mask auth_method "ip_address" means your ip. "net_mask" means net mask. "auth_method" means authentication method. There are few authentication methods. such as "password, trust, md5" like that... eg: host all all 192.168.0.2 255.255.255.0 trust When we add auth_method as 'trust', think as trust user. If we add as 'md5', have to issue password while connect to this machine. more details on postgresql doc then save and close step:2 Allow TCP/IP communication open the file called /etc/postgresql/8.1/main/postgresql.conf. (8.1 means version. It may be vary) Uncomment &quo

postgreSQL is an object-relational database management system(ORDBMS) based on postgres.It is an open-source product.It supports a large part of sql standards and offers many modern features. * complex queries * foreign keys * triggers * views * transactional integrity * multiversion concurrency control Also, postgreSQL can be extended by the user in many ways, for example by adding new * data types * functions * operators * aggregate functions * index methods * procedural languages There is a extension called postGIS to the postgreSQL. postGIS supports for geographical objects to the postgreSQL database, allowing it to be backend database for geographic information systems(GIS). And because of the liberal license, postgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic. How can we install postgresql in debian system..... Just search in your cache for postg