Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 558C89F9B4F for ; Thu, 23 Aug 2007 14:12:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 76043-06-2 for ; Thu, 23 Aug 2007 14:12:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 059299FA164 for ; Thu, 23 Aug 2007 14:12:11 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 7F6EF54D7D; Thu, 23 Aug 2007 18:08:22 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id C8A24274060; Thu, 23 Aug 2007 18:08:22 +0100 (BST) Message-ID: <46CDBF06.8010501@archonet.com> Date: Thu, 23 Aug 2007 18:08:22 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: "Campbell, Lance" Cc: pgsql-performance@postgresql.org Subject: Re: Installing PostgreSQL References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/263 X-Sequence-Number: 26393 Campbell, Lance wrote: > Should installation questions be sent here or to the admin listserv? Probably the pgsql-general/admin/novice lists > OS: redhat linux RHES? > Version of PostgreSQL: 8.2.4 OK > I had a group that now manages our server set up a directory/partition > for us to put postgreSQL into. The directory is called pgsql_data. The > directory is more than a regular directory. It contains a subdirectory > called "lost+found". I would assume this is a logical partition. No - if you get filesystem corruption any recovered disk-blocks are put into files here. All your disk partitions will have such a directory. > I > tried installing postgreSQL directly into this directory but it failed > since there is a file in this directory, "lost+found". Is there a way > around this? Worst case scenario I will create a subdirectory called > data and put the install in there. That's what you want to do. Apart from anything else it lets you set ownership & permission of the directory. > I would have preferred to put it > directly into the pgsql_data. There would be no other files that would > have gone into the directory/partition other than postgreSQL. Would it > be possible for me to install postgreSQL into a sub directory of > pgsql_data and then move the files up a directory into pgsql_data? Just symlink your directory to the correct place if that's what you want. Partition at: /mnt/pg_disk Directory is: /mnt/pg_disk/data symlink to: /var/db/data -- Richard Huxton Archonet Ltd