From drodriguez@alejandria.biz Wed Apr 30 20:48:14 2008 Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 2F4302E00CC for ; Wed, 30 Apr 2008 17:48:14 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84468-09 for ; Wed, 30 Apr 2008 17:48:08 -0300 (ADT) X-Greylist: delayed 00:38:58.987078 by SQLgrey-1.7.5 Received: from altamira.alejandria.biz (unknown [200.7.113.36]) by developer.postgresql.org (Postfix) with ESMTP id 695412E00C7 for ; Wed, 30 Apr 2008 17:48:02 -0300 (ADT) Received: from Spooler by altamira.alejandria.biz (Mercury/32 v4.01b) ID MO001085; 30 Apr 2008 16:18:00 -0430 Received: from spooler by altamira.alejandria.biz (Mercury/32 v4.01b); 30 Apr 2008 13:15:31 -0430 Received: from ZONARENTAL (192.168.0.85) by altamira.alejandria.biz (Mercury/32 v4.01b) ID MG001084; 30 Apr 2008 13:15:21 -0430 Message-ID: <002001c8aae9$f5e66c80$5500a8c0@alejandria.biz> From: =?iso-8859-1?Q?David_Rodr=EDguez_Canel=F3n?= To: Cc: "Soporte" , Subject: How to configure Postgre 8.2 to put the data base in a especific directory Date: Wed, 30 Apr 2008 13:15:20 -0430 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001D_01C8AAC4.3DD39ED0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.101 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200805/3 X-Sequence-Number: 29087 This is a multi-part message in MIME format. ------=_NextPart_000_001D_01C8AAC4.3DD39ED0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. ------=_NextPart_000_001D_01C8AAC4.3DD39ED0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I put the tablespace in a specific = directory, but=20 Postgre created a copy of my database in de Postgre directory = (C:\Archivos=20 de programa\PostgreSQL\8.2\data\base\10818), taking all my free space. I = need to=20 know how i could set Postgre to create a database in a  = diferent=20 directory and drive than Postgre's.
 
 
------=_NextPart_000_001D_01C8AAC4.3DD39ED0-- From pgsql@Sheeky.Biz Thu May 1 18:21:31 2008 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