Обсуждение: initlocation on 8.0+
Hi All, 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. Regards, Nitin Verma
On Mon, 2006-06-26 at 10:31, Nitin Verma wrote: > Hi All, > > 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. Locations was a useful little hack to use as an interim until table spaces got implemented. Look for table spaces in the docs, that's what you want now. They're much less error prone, in general, than were locations.
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
Thanx Scott and Michael -----Original Message----- From: Michael Fuhr [mailto:mike@fuhr.org] 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