| From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
|---|---|
| To: | "Tomeh, Husam" <htomeh(at)firstam(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: pg_ctl -D? |
| Date: | 2006-10-04 17:03:19 |
| Message-ID: | 20061004170319.GA12674@cns.vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, Oct 04, 2006 at 08:19:31AM -0700, Tomeh, Husam wrote:
>
> Postgres expects all your data files to be in one location. The
> workaround if you have chosen to spread them is to use symbolic links to
> point to that one location again.
Apparently, not. I used tablespaces to spread out indexes and tables. Anyway,
pg found the other data after starting with just the base:
pg_ctl -D /var/pgsql/data -l logfile start
testdb=# \db
List of tablespaces
Name | Owner | Location
------------+------------+-----------------
pg_default | postgresql |
pg_global | postgresql |
testts | postgresql | /opt/pgsql/data
(3 rows)
This may come back to bite me some other way. Having all the data on one
drive doesn't make any sense to me at all. Would this not cause i/o bottlenecks?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ray Stell | 2006-10-04 17:05:36 | Re: pg_ctl -D? |
| Previous Message | Tom Lane | 2006-10-04 16:57:35 | Re: pg_ctl -D? |