Hi Rich Shepard, Step 1-: Stop the postgres services and change the path of the data directory in postgres.conf file.
Step 2-: rsync the flie to new path. And start the service. Step 3-: connect to postgres and check command output from psql shell SHOW data_directory; should see now data path. On Sat, 4 Jan 2020, 8:50 pm Rich Shepard, <rshep...@appl-ecosys.com> wrote: > 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 > > >
