Thanx Scott and Michael -----Original Message----- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 9:18 PM To: Nitin Verma Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] initlocation on 8.0+
On Mon, Jun 26, 2006 at 08:31:22AM -0700, Nitin Verma wrote: > I am using initlocation utility to have two separate PGDATAs, that can then > host different databases. In my case I only have one on each and I am using > version 7.3.2. > > But I am not able to find this utility on 8.1.0, is there an alternative > utility to this or this feature is no more supported. In 8.0 and later you can use tablespaces to put files in different locations. http://www.postgresql.org/docs/8.1/interactive/manage-ag-tablespaces.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match