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