From: | Scott Whitney <scott(at)journyx(dot)com> |
---|---|
To: | srilinux <srilinux09(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: unable to find data folder postgres9.4 |
Date: | 2017-03-22 18:45:04 |
Message-ID: | 5f83d3c6-e98c-443e-a79e-4d72afe4969d@email.android.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(at)gmail(dot)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(at)postgresql(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Whitney | 2017-03-22 18:46:19 | Re: unable to find data folder postgres9.4 |
Previous Message | John Scalia | 2017-03-22 18:39:09 | Re: unable to find data folder postgres9.4 |