Re: Issue: Creating Symlink for data directory of postgresql inCentOS7

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 postgres, I’m 
> still unable to restart postgres after modifications.
> 
> I’ve also modified ‘/var/lib/pgsql/postgresql.conf’ and 
> ‘/usr/lib/systemd/system/postgresql.service’ to point the $PGDATA 
> location to the actual destination as respectively:
> 
> data_directory = '/data/postgresql/data'
> 
> Environment=PGDATA=/data/postgresql/data
> 
> Can you guys help ? I tried searching a solution for this problem but 
> still couldn’t get a perfect solution.
> 
> Here’s what I’m seeing in:
> 
>>>> systemctl status postgresql.service
> 
> postgresql.service - PostgreSQL database server
> 
>     Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; 
> vendor preset: disabled)
> 
>     Active: failed (Result: exit-code) since Fri 2019-07-12 10:00:51 
> UTC; 38s ago
> 
>    Process: 8852 ExecStartPre=/usr/bin/postgresql-check-db-dir ${PGDATA} 
> (code=exited, status=1/FAILURE)
> 
> Main PID: 29483 (code=exited, status=0/SUCCESS)
> 
> Jul 12 10:00:51 systemd[1]: Starting PostgreSQL database server...
> 
> Jul 12 10:00:51 systemd[1]: postgresql.service: control process exited, 
> code=exited status=1
> 
> Jul 12 10:00:51 systemd[1]: Failed to start PostgreSQL database server.
> 
> Jul 12 10:00:51 systemd[1]: Unit postgresql.service entered failed state.
> 
> Jul 12 10:00:51 systemd[1]: postgresql.service failed.
> 
>>>> /var/log/messages
> 
> Jul 12 10:00:51 systemd: Starting PostgreSQL database server...
> 
> 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 postgresql-check-db-dir: See 
> /usr/share/doc/postgresql-9.2.24/README.rpm-dist for more information.
> 
> Jul 12 10:00:51 systemd: postgresql.service: control process exited, 
> code=exited status=1
> 
> Jul 12 10:00:51 systemd: Failed to start PostgreSQL database server.
> 
> Jul 12 10:00:51 systemd: Unit postgresql.service entered failed state.
> 
> Jul 12 10:00:51 systemd: postgresql.service failed.
> 
> -Shibayan
> 
> This communication is the property of CenturyLink and may contain 
> confidential or privileged information. Unauthorized use of this 
> communication is strictly prohibited and may be unlawful. If you have 
> received this communication in error, please immediately notify the 
> sender by reply e-mail and destroy all copies of the communication and 
> any attachments.


-- 
Adrian Klaver
adrian.klaver@aklaver.com