On fös, 2006-11-24 at 16:14 -0800, sasan3@gmail.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