Re: Alternate Datafile Location - Mailing list pgsql-admin
Inint db로 생성시키면 해당 경로에 시스템 테이블생성이됩니다..이게..사용이 많으면 문제가되겠죠..wall은별도로지정가능하고요..사용자클러스터 디비는..별도로 생성해서 관히하시면 되구요..기본 설치시 생성된디렉토리는 변경이어려우니.추가하려면 별도의 파일시스템을먼들어..링크를 걸어주세요.
2024년 8월 30일 (금) 오전 8:56, Sam Stearns <sam.stearns@dat.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@elevated-dev.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
pgsql-admin by date: