PostgreSQL - Revision history

69.22.17.203: /* Creating a cluster */

2005-12-05T03:11:07Z

Creating a cluster

2005-12-04T20:17:46Z

2005-12-04T20:17:03Z

2005-12-04T20:03:58Z

Installation

2005-09-21T06:06:43Z

speling errore

2005-08-13T18:41:52Z

2005-08-13T18:40:23Z

2005-08-03T08:45:38Z

Speak about network configuration

2005-08-03T08:22:00Z

Explain user creation

2005-08-03T08:10:53Z

Extrain database creation

@@ Line 23: / Line 23: @@
 ===Creating a cluster===
-What is called cluster in PostgreSQL is the database disk area. The first step is to enable PostgreSQL, witch is done in ''/etc/rc.conf'' : add the following line at the end :
+What is called cluster in PostgreSQL is the database disk area. The first step is to enable PostgreSQL, which is done in ''/etc/rc.conf'' : add the following line at the end :
   postgresql_enable="YES"
@@ Line 31: / Line 31: @@
 If everything is good, you can now start PostgreSQL :
   /usr/local/etc/rc.d/010.pgsql.sh start
 ===Listening to the network (optional)===

← Older revision		Revision as of 20:17, 4 December 2005
Line 1:		Line 1:
−	PostgreSQL is an open source object-relational database management system released under the terms of the BSD ~~licence~~. It is based on '''postgres''', developed at the University of California at Berkeley Computer Science Department (Just like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.	+	PostgreSQL is an open source object-relational database management system released under the terms of the BSD license. It is based on '''postgres''', developed at the University of California at Berkeley Computer Science Department (Just like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.

	==Installation==		==Installation==

← Older revision		Revision as of 20:17, 4 December 2005
Line 1:		Line 1:
−	PostgreSQL is an open source object-relational database management system released under the terms of the BSD licence. It is based on '''postgres''', ~~developped~~ at the University of California at Berkeley Computer Science Department (Just like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.	+	PostgreSQL is an open source object-relational database management system released under the terms of the BSD licence. It is based on '''postgres''', developed at the University of California at Berkeley Computer Science Department (Just like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.

	==Installation==		==Installation==

@@ Line 11: / Line 11: @@
   pkg_add -r postgresql80-client postgresql80-server
-Additionnaly, you may want to install postgresql support to [[PHP]]. Depending on your PHP version, install :
+Additionally, you may want to install postgresql support to [[PHP]]. Depending on your PHP version, install :
   /usr/ports/databases/php4-pgsql

← Older revision		Revision as of 06:06, 21 September 2005
Line 1:		Line 1:
−	PostgreSQL is an open source object-relational database management system released under the terms of the BSD licence. It is based on '''postgres''', developped at the University of California at Berkeley Computer Science Department (~~Juste~~ like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.	+	PostgreSQL is an open source object-relational database management system released under the terms of the BSD licence. It is based on '''postgres''', developped at the University of California at Berkeley Computer Science Department (Just like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.

	==Installation==		==Installation==

@@ Line 33: / Line 33: @@
-===Listening to the network (optionnal)===
+===Listening to the network (optional)===
 By default, you will be able to use your database localy only. Edit the file ''~pgsql/data/postgresql.conf'' and uncomment the following line :
   listen_addresses = '*'
 You can also change the '''max_connections''' value. Restart PostgreSQL in order to have the changes effective (But you can do the next step before ;-) ).
-===Configuring connections (optionnal but recommanded !)===
+===Configuring connections (optional but recommended !)===
 An other step is required in order to be ready to use PostgreSQL over a network : telling the system ''who'' can access ''what''. This is the role of the ~/data/pg_hba.conf file.
 You may want to change some things as the default configuration is to accept all local connections and reject all others. Here we require authentification for a local connection or a connection from the network (192.168.0.xxx) :

← Older revision		Revision as of 18:40, 13 August 2005
Line 1:		Line 1:
−	PostgreSQL is an open source object-~~relationnal~~ database management system released under the terms of the BSD licence. It is based on '''postgres''', developped at the University of California at Berkeley Computer Science Department (Juste like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.	+	PostgreSQL is an open source object-relational database management system released under the terms of the BSD licence. It is based on '''postgres''', developped at the University of California at Berkeley Computer Science Department (Juste like [[BSD]]). It features many stuff [[MySQL]] lacks, such as transactional integrity or complex queries.

	==Installation==		==Installation==

@@ Line 31: / Line 31: @@
 If everything is good, you can now start PostgreSQL :
   /usr/local/etc/rc.d/010.pgsql.sh start
 ===Creating databases===
@@ Line 81: / Line 100: @@
   ALTER USER
   template1=#
 ==PostgreSQL Website==

@@ Line 62: / Line 62: @@
 * The '''CREATE USER''' query.
-I will explain this latter .... --[[User:Smortex|Smortex]] 02:16, 18 Jul 2005 (EDT)
+Let's create a ''bar'' user :
 ==PostgreSQL Website==

@@ Line 38: / Line 38: @@
 * The '''CREATE DATABASE''' query.
-I will explain this latter .... --[[User:Smortex|Smortex]] 02:16, 18 Jul 2005 (EDT)
+For example, let's create the ''foo'' database :
 ===Creating users===