From: Scott Whitney <scott@journyx.com>
To: srilinux <srilinux09@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: unable to find data folder postgres9.4
Date: Wed, 22 Mar 2017 18:45:04 +0000
Message-ID: <5f83d3c6-e98c-443e-a79e-4d72afe4969d@email.android.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
You can absolutely move it. I have found the easiest way is via a symlink. You need to ensure everything is stopped, AND there are no open files.
When I do something that intrinsic, I like to do it in single user mode after rebooting the server.
You can also just point your startup files to the proper date directories. I have 5 production PG servers.
Let's talk about the internal one.
Internal cluster (port 5432)
Replication of my training server (6432)
Replication of my production customers (7432)
I use these for DR, backups and support. EVERYTHING is under /pgdata then /internal /prod and /training. This is done with the startup scripts.
If this is not enough information, let me know, and I can add actual example files.
On Mar 22, 2017 1:29 PM, srilinux <srilinux09@gmail.com> wrote:
what will happen if I move /var/lib/pgsql to /var/lib/pgsqlBackup ?
will it cause any problems as this is mounted ?
--
View this message in context: http://www.postgresql-archive.org/unable-to-find-data-folder-postgres9-4-tp5951044p5951347.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, srilinux09@gmail.com
Subject: Re: unable to find data folder postgres9.4
In-Reply-To: <5f83d3c6-e98c-443e-a79e-4d72afe4969d@email.android.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox