initlocation on 8.0+

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