Re: Changing default ../data/ directory

On 1/4/20 7:20 AM, Rich Shepard 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).

Not following above:

1) Are you looking for your current postgresql.conf?

2) Some examples of postgresql.conf?

More below.
> 
> 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
> 
> 

https://www.postgresql.org/docs/11/runtime-config-file-locations.html#GUC-DATA-DIRECTORY


-- 
Adrian Klaver
[email protected]