Skip site navigation (1) Skip section navigation (2)

Re: How to configure Postgre 8.2 to put the data base in a especific directory

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: David Rodríguez Canelón <drodriguez(at)alejandria(dot)biz>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to configure Postgre 8.2 to put the data base in a especific directory
Date: 2008-05-01 18:21:25
Message-ID: 481A0A25.3020609@Sheeky.Biz (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

pgsql-admin by date

Next:From: GeoffreyDate: 2008-05-01 19:54:25
Subject: Re: COPY errors when trying to convert from 7.4.19 to 8.3.1
Previous:From: Shane AmblerDate: 2008-05-01 18:19:36
Subject: Re: COPY errors when trying to convert from 7.4.19 to 8.3.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group