Saturday 7 February 2009

PostgreSQL - Creating a New Tablespace and Database

Using pcAdmin III it is straightforward to setup a new Tablespace and Database for use with your PostgeSQL installation. The only 'gotcha' is that you need to specify an absolute path to the Tablespace and the user 'postgres' must be the owner of that directory.



On Windows you can set the owner using the properties of the directory, on the Mac however you will need to so something similar to this:

sudo chown -v postgres data

Make sure you have changed into the parent directory of 'data' before you execute the above command.

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development


Arten Science RSS Feed

No comments: