Re: unable to find data folder postgres9.4

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/

Browse pgsql-admin by date

  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