Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux