| 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: | 2006-11-26 11:13:26 |
| Message-ID: | 1164539606.27070.20.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas H. | 2006-11-26 13:18:32 | have pg_restore create a new database? |
| Previous Message | Thomas Kellerer | 2006-11-26 09:11:32 | Re: Development of cross-platform GUI for Open Source DBs |