Postgresql-config - Revision history

Makopoppo: postgresql support has been removed

2011-05-22T05:25:19Z

postgresql support has been removed

Show changes

Fritigern at 14:59, 19 November 2010

2010-11-19T14:59:47Z

Brentseidel: Add reference to PostgreSQL web site.

2009-05-30T00:56:48Z

Add reference to PostgreSQL web site.

Ideia Boa at 00:07, 22 May 2009

2009-05-22T00:07:06Z

Brentseidel: /* PostgreSQL User and Schema Creation */

2009-05-08T18:20:27Z

‎PostgreSQL User and Schema Creation

Tlaukkan: /* PostgreSQL configuration */

2009-02-18T17:17:30Z

‎PostgreSQL configuration

Tlaukkan: /* Installation */

2009-02-18T17:15:12Z

‎Installation

Fly-man-: /* Keep it Simple */

2009-02-10T20:23:11Z

‎Keep it Simple

Fly-man- at 20:20, 10 February 2009

2009-02-10T20:20:36Z

Fly-man- at 20:15, 10 February 2009

2009-02-10T20:15:54Z

← Older revision		Revision as of 14:59, 19 November 2010
Line 137:		Line 137:
	OpenSim.exe		OpenSim.exe
	</source>		</source>
		+
		+	[[Category:Database]]

@@ Line 6: / Line 6: @@
 I won't lie to you, setting up PostgreSQL on a Linux machine might look simple but it's a pain in the ass when you're not comfortable
-with using phpPgAdmin (kinda like phpMyadmin for MySQL)
+with using phpPgAdmin (kinda like phpMyadmin for MySQL).  For more information on PostreSQL, see http://www.postgresql.org/ the official PostgreSQL site.
 == PostgreSQL Installation ==

← Older revision		Revision as of 00:07, 22 May 2009
Line 1:		Line 1:
		+	__NOTOC__
		+	{{Template:Quicklinks}}
		+	<br />
		+
	=PostgreSQL configuration=		=PostgreSQL configuration=

@@ Line 58: / Line 58: @@
 * Create user opensim.
 * Create database opensim with owner opensim.
 == Setting up the OpenSim to use Postgresql ==

← Older revision		Revision as of 17:17, 18 February 2009
Line 52:		Line 52:

	And all should be working.		And all should be working.
		+
		+	== PostgreSQL User and Schema Creation ==
		+
		+	Someone who can try this out please log exact steps for linux:
		+
		+	* Create user opensim.
		+	* Create database opensim with owner opensim.

	== Setting up the OpenSim to use Postgresql ==		== Setting up the OpenSim to use Postgresql ==

@@ Line 4: / Line 4: @@
 with using phpPgAdmin (kinda like phpMyadmin for MySQL)
-== Installation ==
+== PostgreSQL Installation ==
 If you are on a Linux machine, use your favorite package manager to get the Postgresql package from your distribution

@@ Line 93: / Line 93: @@
 ; User Source NHibernate Example (DIALECT;DRIVER;CONNECTSTRING)
 user_source = "PostgreSQLDialect;NpgsqlDriver;Server=localhost;Database=opensim;User ID=opensim;Password=opensim;";
 </source>

← Older revision		Revision as of 20:20, 10 February 2009
Line 52:		Line 52:

	And all should be working.		And all should be working.
		+
		+	== Setting up the OpenSim to use Postgresql ==
		+
		+	For an example how to setup the OpenSim.ini to use Postgresql:
		+
		+	<source lang=text>
		+	; ##
		+	; ## STORAGE
		+	; ##
		+
		+	; * Prim Storage - only leave one storage_plugin uncommented *
		+	storage_plugin = "OpenSim.Data.NHibernate.dll" ; for nhibernate
		+
		+	; Storage Source NHibernate example (DIALECT;DRIVER;CONNECTSTRING)
		+	storage_connection_string="PostgreSQLDialect;NpgsqlDriver;Server=localhost;Database=opensim;User ID=opensim;Password=opensim;";
		+
		+	; Asset database provider
		+	asset_plugin = "OpenSim.Data.NHibernate.dll" ; for nhibernate
		+
		+	; the Asset DB source. This only works for sqlite, mysql, and nhibernate for now
		+	; Asset Source NHibernate example (DIALECT;DRIVER;CONNECTSTRING)
		+	asset_source = "PostgreSQLDialect;NpgsqlDriver;Server=localhost;Database=opensim;User ID=opensim;Password=opensim;";
		+
		+	; Inventory database provider
		+	inventory_plugin = "OpenSim.Data.NHibernate.dll" ; for nhibernate
		+
		+	; Inventory Source NHibernate example (DIALECT;DRIVER;CONNECTSTRING)
		+	inventory_source = "PostgreSQLDialect;NpgsqlDriver;Server=localhost;Database=opensim;User ID=opensim;Password=opensim;";
		+
		+	; User Data Database provider
		+	;
		+	; Multiple providers can be specified by separating them with commas (whitespace is unimportant)
		+	; If multiple providers are specified then if a profile is requested, each is queried until one
		+	; provides a valid profile, or until all providers have been queried.
		+	; Unfortunately the order of querying is currently undefined (it may not be the order in which
		+	; providers are specified here). This needs to be fixed
		+	;
		+	userDatabase_plugin = "OpenSim.Data.NHibernate.dll" ; for nhibernate
		+
		+	; User Source NHibernate Example (DIALECT;DRIVER;CONNECTSTRING)
		+	user_source = "PostgreSQLDialect;NpgsqlDriver;Server=localhost;Database=opensim;User ID=opensim;Password=opensim;";
		+	</source>

@@ Line 12: / Line 12: @@
 Now we need to reset the password for the ‘postgres’ admin account for the server, so we can use this for all of the system administration tasks. Type the following at the command-line (substitute in the password you want to use for your administrator account):
 $ sudo su postgres -c psql template1
 template1=# ALTER USER postgres WITH PASSWORD 'password';
 template1=# \q
 That alters the password for within the database, now we need to do the same for the unix user ‘postgres’:
 $ sudo passwd -d postgres
 $ sudo su postgres -c passwd
 Now enter the same password that you used previously.
@@ Line 25: / Line 29: @@
 Finally, we need to open up the server so that we can access and use it remotely - unless you only want to access the database on the local machine. To do this, first, we need to edit the postgresql.conf file:
 $ sudo vi /etc/postgresql/8.2/main/postgresql.conf
 Now, to edit a couple of lines in the ‘Connections and Authentication’ section…
 Change the line:
-#listen_addresses = 'localhost' to listen_addresses = '*'
+<code>#listen_addresses = 'localhost' to listen_addresses = '*'</code>
 and also change the line:
-#password_encryption = on  to password_encryption = on
+<code>#password_encryption = on
 Save the file.
@@ Line 40: / Line 49: @@
 That’s it, now all you have to do is restart the server:
-$ sudo /etc/init.d/postgresql-8.2 restart
+<code>$ sudo /etc/init.d/postgresql-8.2 restart</code>
 And all should be working.