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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: PGDATA


  • From: Ragnar <gnari(at)hive(dot)is>
  • To: "sasan3(at)gmail(dot)com" <sasan3(at)gmail(dot)com>
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject: Re: PGDATA
  • Date: Sun, 26 Nov 2006 11:13:26 +0000
  • Message-id: <1164539606(dot)27070(dot)20(dot)camel(at)localhost(dot)localdomain>

On fös, 2006-11-24 at 16:14 -0800, sasan3(at)gmail(dot)com wrote:
> 
> Well.. you are correct!
> After studying the contents of "/etc/init.d/postfresql", I put
> "PGDATA=/home3/mylargedisk/data" in "/etc/sysconfig/pgsql/postgresql"
> and it now works.
> 
> So what the ..... is this PGDATA!!!!!! It must be a trivial concept
> cause nobody else is worried about how it works!!  And How do I get
> each database to be in a different directory?!!

are you looking for:

  CREATE TABLESPACE myts LOCATION '/foo';
  CREATE DATABASE mydb WITH TABLESPACE=myts;

?

gnari





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group