Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id A8E5B2E007C for ; Thu, 1 May 2008 15:21:31 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 11597-01 for ; Thu, 1 May 2008 15:21:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ipmail01.adl6.internode.on.net (ipmail01.adl6.internode.on.net [203.16.214.146]) by developer.postgresql.org (Postfix) with ESMTP id 484552E007A for ; Thu, 1 May 2008 15:21:27 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnoCAEelGUjLevdHiGdsb2JhbAAsgSeQCwEBAQ8gmlk X-IronPort-AV: E=Sophos;i="4.27,422,1204464600"; d="scan'208";a="93720476" Received: from ppp247-71.static.internode.on.net (HELO DevBox.local) ([203.122.247.71]) by ipmail01.adl6.internode.on.net with ESMTP; 02 May 2008 03:51:26 +0930 Message-ID: <481A0A25.3020609@Sheeky.Biz> Date: Fri, 02 May 2008 03:51:25 +0930 From: Shane Ambler User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213) MIME-Version: 1.0 To: =?ISO-8859-1?Q?David_Rodr=EDguez_Canel=F3n?= CC: pgsql-admin@postgresql.org Subject: Re: How to configure Postgre 8.2 to put the data base in a especific directory References: <002001c8aae9$f5e66c80$5500a8c0@alejandria.biz> In-Reply-To: <002001c8aae9$f5e66c80$5500a8c0@alejandria.biz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/18 X-Sequence-Number: 29102 David Rodríguez Canelón wrote: > I put the tablespace in a specific directory, but Postgre created a > copy of my database in de Postgre directory (C:\Archivos de > programa\PostgreSQL\8.2\data\base\10818), taking all my free space. I > need to know how i could set Postgre to create a database in a > diferent directory and drive than Postgre's. > > Did you specify the tablespace when creating the db? or create the tablespace after the db? Is the drive NTFS or FAT32? (system and the tablespace drive) What version of windows? -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz