| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Changing default ../data/ directory |
| Date: | 2020-01-04 15:20:44 |
| Message-ID: | alpine.LNX.2.20.2001040706160.30638@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I run Slackware (currently -14.2/x86_64) and postgres-11.5. The data
directory has always been located in /var/lib/pgsql/<version>/data. This
data directory is located in the / partition on a 240G SSD.
There's another 2T HDD with a /data partition and I want to both move the
current /var/lib/pgsql/data cluster to /data/pgsql/11 and have all future
databases use that location.
The PGDATA environment variable used to be used for this (but I never did
get it satisfactorily working). Web searches show changing initdb or,
perhaps, postgresql.conf (there is a /usr/share/postgresql.conf.sample but
no postgresql.conf).
As this is all new to me I want to learn how to:
1) Define a postgresl.conf and learn where it should be located.
2) Move all current databased in /var/lib/pgsql/11/data to /data/pgsql/11.
3) Create all new databases in /data/pgsql/11 by default.
I'm sure it's in the manual yet I'm unsure just where to start reading.
Rich
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nikhil raj | 2020-01-04 16:06:19 | Re: Changing default ../data/ directory |
| Previous Message | Paula Kirsch | 2020-01-04 11:54:41 | When should parameters be passed as text v. binary? |