pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to configure Postgre 8.2 to put the data base in a especific directory
2+ messages / 2 participants
[nested] [flat]
* How to configure Postgre 8.2 to put the data base in a especific directory
@ 2008-04-30 17:45 David Rodríguez Canelón <drodriguez@alejandria.biz>
0 siblings, 1 reply; 2+ messages in thread
From: David Rodríguez Canelón @ 2008-04-30 17:45 UTC (permalink / raw)
To: pgsql-admin; +Cc: Soporte <Soporte@altamira.alejandria.biz>; dpacheco@alejandria.biz
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to configure Postgre 8.2 to put the data base in a especific directory
@ 2008-05-01 18:21 Shane Ambler <pgsql@Sheeky.Biz>
parent: David Rodríguez Canelón <drodriguez@alejandria.biz>
0 siblings, 0 replies; 2+ messages in thread
From: Shane Ambler @ 2008-05-01 18:21 UTC (permalink / raw)
To: David Rodríguez Canelón <drodriguez@alejandria.biz>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-05-01 18:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-30 17:45 How to configure Postgre 8.2 to put the data base in a especific directory David Rodríguez Canelón <drodriguez@alejandria.biz>
2008-05-01 18:21 ` Shane Ambler <pgsql@Sheeky.Biz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox