From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ron Watkins <rwatki(at)gmail(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Differing data directories |
Date: | 2018-02-22 16:45:57 |
Message-ID: | CAKFQuwarkyefOo5YPb+d60emn0v9=ROHq-w18pinVPVcTFnELA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thu, Feb 22, 2018 at 9:28 AM, Ron Watkins <rwatki(at)gmail(dot)com> wrote:
> I have a postgresql server setup/installed (finally).
>
> Currently, it’s installed data directory is: /var/lib/pgsql/10/data
>
> However, I need to put a database into a custom filesystem.
>
> Is it possible to have multiple PGDATA directories, and if so, how?
>
>
>
> Currently, the postgres database is under /var/lib/pgsql/10/data, but I
> need my main database to be in a different filesystem…
>
>
>
Short answer, just "initdb" a new cluster and point it to the desired
location.
https://www.postgresql.org/docs/10/static/app-initdb.html
Now, the answer becomes longer since you will now have two clusters. You
will either want to remove the existing one or ensure the two play nicely.
It is further complicated by the means by which you installed and what
services have been setup.
All databases in a cluster share the same storage location by default
though you can create tablespaces and put different databases on different
tablespaces. But that likely adds more complexity to the running setup
than you need - at least by creating a new cluster and getting it to work
properly you only need to deal with complexity during the initial setup.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Watkins | 2018-02-22 18:21:15 | New DB cluster. |
Previous Message | Ron Watkins | 2018-02-22 16:28:09 | Differing data directories |