From: | ji hwan song <song7357(at)gmail(dot)com> |
---|---|
To: | Sam Stearns <sam(dot)stearns(at)dat(dot)com> |
Cc: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Alternate Datafile Location |
Date: | 2024-08-30 00:18:45 |
Message-ID: | CAHTrd7_P3g=9jn-6VHfsbJ9EKt98y1LtUvn6zjRkpyCxKKa0-w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Inint db로 생성시키면 해당 경로에 시스템 테이블생성이됩니다..이게..사용이 많으면
문제가되겠죠..wall은별도로지정가능하고요..사용자클러스터 디비는..별도로 생성해서 관히하시면 되구요..기본 설치시 생성된디렉토리는
변경이어려우니.추가하려면 별도의 파일시스템을먼들어..링크를 걸어주세요.
2024년 8월 30일 (금) 오전 8:56, Sam Stearns <sam(dot)stearns(at)dat(dot)com>님이 작성:
> Ok, we were going with the approach of the Postgres software (cluster)
> being on the root filesystem then creating databases with data file storage
> on an alternate filesystem.
>
> It's sounding like the better approach would be to install the Postgres
> software (cluster with initdb) on a filesystem other than root. Do I have
> that right?
>
> On Fri, Aug 30, 2024 at 9:17 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
> wrote:
>
>> You should take a step back and read the basic documentation on PG
>> administration. For instance:
>> https://www.postgresql.org/docs/16/creating-cluster.html
>>
>> We (at least I) have been assuming that you wanted to create a new
>> database cluster, to run a server against that storage, using initdb. Using
>> an already running server to put data elsewhere, using createdb is
>> different, and requires that you create a tablespace first:
>> https://www.postgresql.org/docs/16/manage-ag-tablespaces.html
>>
>>
>
> --
>
> *Samuel Stearns*
> Lead Database Administrator
> *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com
> [image: DAT]
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rui DeSousa | 2024-08-30 02:22:35 | Re: Postgresql Software Location |
Previous Message | Sam Stearns | 2024-08-30 00:17:43 | Re: Alternate Datafile Location |