RE: Issue: Creating Symlink for data directory of postgresql in CentOS7

; Chatterjee, Shibayan ; pgsql-gene...@postgresql.org Subject: Re: Issue: Creating Symlink for data directory of postgresql in CentOS7 Adrian Klaver wrote: > On 7/13/19 4:30 AM, Laurenz Albe wrote: > > On Fri, 2019-07-12 at 18:08 +, Chatterjee, Shibayan wrote: > > > > Jul 12 10

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

On Sun, Jul 14, 2019 at 5:05 PM Laurenz Albe wrote: > Since you say that there was a regular data directory there, that would point > to permission problems. I'm not a systemd expert, but since we are _before_ starting the cluster, the checks should be run as superuser, so I don't see how a permi

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

Adrian Klaver wrote: > On 7/13/19 4:30 AM, Laurenz Albe wrote: > > On Fri, 2019-07-12 at 18:08 +, Chatterjee, Shibayan wrote: > > > > Jul 12 10:00:51 postgresql-check-db-dir: "/data/postgresql/data" is > > > > missing or empty. > > > > Jul 12 10:00:51 postgresql-check-db-dir: Use "postgresql-s

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

On 7/13/19 4:30 AM, Laurenz Albe wrote: On Fri, 2019-07-12 at 18:08 +, Chatterjee, Shibayan wrote: Jul 12 10:00:51 postgresql-check-db-dir: "/data/postgresql/data" is missing or empty. Jul 12 10:00:51 postgresql-check-db-dir: Use "postgresql-setup initdb" to initialize the database cluster

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

On Fri, 2019-07-12 at 18:08 +, Chatterjee, Shibayan wrote: > > Jul 12 10:00:51 postgresql-check-db-dir: "/data/postgresql/data" is missing > > or empty. > > Jul 12 10:00:51 postgresql-check-db-dir: Use "postgresql-setup initdb" to > > initialize the database cluster. > > Jul 12 10:00:51 postg

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

On Sat, Jul 13, 2019 at 5:12 AM Chatterjee, Shibayan wrote: > For sure there's all the necessary files in '/data/postgresql/data'. The > startup process cannot read it, because of sym link. > Executing init-db return the below message: > I suspect this could be a systemd problem. What if you try

RE: Issue: Creating Symlink for data directory of postgresql in CentOS7

ssue: Creating Symlink for data directory of postgresql in CentOS7 On Fri, Jul 12, 2019 at 4:47 PM Laurenz Albe wrote: > So there is some "postgresql-check-db-dir" (not part of PostgreSQL) > that complains that there is nothing in /data/postgresql/data. Is that > accu

RE: Issue: Creating Symlink for data directory of postgresql in CentOS7

Message- From: Laurenz Albe Sent: Friday, July 12, 2019 8:47 AM To: Chatterjee, Shibayan ; pgsql-gene...@postgresql.org Subject: Re: Issue: Creating Symlink for data directory of postgresql in CentOS7 On Fri, 2019-07-12 at 10:11 +, Chatterjee, Shibayan wrote: > I’m trying to create

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

On Fri, Jul 12, 2019 at 4:47 PM Laurenz Albe wrote: > So there is some "postgresql-check-db-dir" (not part of PostgreSQL) that > complains > that there is nothing in /data/postgresql/data. Is that accurate? > According to this

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

On Fri, 2019-07-12 at 10:11 +, Chatterjee, Shibayan wrote: > I’m trying to create a symlink for ‘data’ directory present in > ‘/var/lib/pgsql/’, pointing to different location. > After providing exact access permissions and ownership to postgres, I’m still > unable to restart postgres after m

Re: Issue: Creating Symlink for data directory of postgresql in CentOS7

On 7/12/19 3:11 AM, Chatterjee, Shibayan wrote: Hi, I’m trying to create a symlink for ‘data’ directory present in ‘/var/lib/pgsql/’, pointing to different location. Can you show the actual symlink and it containing directory? After providing exact access permissions and ownership to postg