Re: Changing default ../data/ directory - Mailing list pgsql-general

From nikhil raj
Subject Re: Changing default ../data/ directory
Date
Msg-id CAG1ps1yEMyP40QGVVPzBRjgPdqS3WJYgUsagGwWYJSW3PsWUeQ@mail.gmail.com
Whole thread Raw
In response to Changing default ../data/ directory  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Changing default ../data/ directory
List pgsql-general
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, <rshepard@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


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Changing default ../data/ directory
Next
From: Adrian Klaver
Date:
Subject: Re: Changing default ../data/ directory