public inbox for [email protected]
help / color / mirror / Atom feedFrom: ji hwan song <[email protected]>
To: Sam Stearns <[email protected]>
Cc: Scott Ribe <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Alternate Datafile Location
Date: Fri, 30 Aug 2024 09:18:45 +0900
Message-ID: <CAHTrd7_P3g=9jn-6VHfsbJ9EKt98y1LtUvn6zjRkpyCxKKa0-w@mail.gmail.com> (raw)
In-Reply-To: <CAN6TVjn50xywz0qKcVhra1GFmYF0n1g4s7gdBVMdUr1Dpt9cng@mail.gmail.com>
References: <CAN6TVjn=4TOm7OLOw7VoOBY9+XVe2YcxV_z1xZtF-Qp_7gddvA@mail.gmail.com>
<CANzqJaDLXqmNXM01sCQr-h-eJUGH+qPLymmLW8uv9A3qEzraAQ@mail.gmail.com>
<CAN6TVjmfO+nrJ6xhBci=EDKdmq0D4o3vYPNuZsvOfBw6TPV9=Q@mail.gmail.com>
<[email protected]>
<CAN6TVjm_ri4B5TRjuu-w3=OWoFPb+9Me1_zma8uDi0p4CTyALg@mail.gmail.com>
<[email protected]>
<CAN6TVjn50xywz0qKcVhra1GFmYF0n1g4s7gdBVMdUr1Dpt9cng@mail.gmail.com>
Inint db로 생성시키면 해당 경로에 시스템 테이블생성이됩니다..이게..사용이 많으면
문제가되겠죠..wall은별도로지정가능하고요..사용자클러스터 디비는..별도로 생성해서 관히하시면 되구요..기본 설치시 생성된디렉토리는
변경이어려우니.추가하려면 별도의 파일시스템을먼들어..링크를 걸어주세요.
2024년 8월 30일 (금) 오전 8:56, Sam Stearns <[email protected]>님이 작성:
> 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 <[email protected]>
> 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;
>
view thread (11+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Alternate Datafile Location
In-Reply-To: <CAHTrd7_P3g=9jn-6VHfsbJ9EKt98y1LtUvn6zjRkpyCxKKa0-w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox