From: | nikhil raj <nikhilraj474(at)gmail(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Changing default ../data/ directory |
Date: | 2020-01-04 16:06:19 |
Message-ID: | CAG1ps1yEMyP40QGVVPzBRjgPdqS3WJYgUsagGwWYJSW3PsWUeQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)appl-ecosys(dot)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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-01-04 16:17:25 | Re: Changing default ../data/ directory |
Previous Message | Rich Shepard | 2020-01-04 15:20:44 | Changing default ../data/ directory |