Re: postgres start up error

From: "Anthony, Craig Talmadge" <craig(at)psu(dot)edu>
To: Azimuddin Mohammed <azimeiu(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: postgres start up error
Date: 2018-03-19 18:40:05
Message-ID: BY2PR0201MB075955D96FF4BDD1782A1384A8D40@BY2PR0201MB0759.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

looks like a typo in your postgresql.conf file, poostgresql should be postgresql

________________________________
From: Azimuddin Mohammed <azimeiu(at)gmail(dot)com>
Sent: Monday, March 19, 2018 2:07:21 PM
To: pgsql-admin; pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: postgres start up error

Hello Admins,
When I am rebooting my postgres server I am getting below error. postgres user is not able to create a directory in /var/run, var/run is owned by root in our organization. So I have to create the directory manually, chnage the permissoin and start postgres.
Is there a way I can change the /var/run folder to any other location where I can manage the postgres permission.

< 2018-03-13:16:45.272 EDT > FATAL: could not create lock file "/var/run/poostgresql direcectory

postmaster[4117]: < 2018-03-19 13:16:45.272 EDT > LOG: database system is shut down

postgresql-9.6.servicemain process exited, code=exited, status=1/FAILURE

Mar 19 13:16:45..com systemd[1]: Failed to start PostgreSQL 9.6 database server.

Mar 19 13:16:45...com systemd[1]: Unit postgresql-9.6.service entered failed state.

--

Regards,
Azim

[https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Dwebmail%26utm_term%3Dicon&data=02%7C01%7Ccraig%40psu.edu%7Cd52501df303f45748b5108d58dc45a62%7C7cf48d453ddb4389a9c1c115526eb52e%7C0%7C0%7C636570796836830850&sdata=04juSBzSR4ICDs%2FHabrMXA5rHqmAPtNhWoLYj6j7uKI%3D&reserved=0> Virus-free. www.avast.com<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.avast.com%2Fsig-email%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Dwebmail%26utm_term%3Dlink&data=02%7C01%7Ccraig%40psu.edu%7Cd52501df303f45748b5108d58dc45a62%7C7cf48d453ddb4389a9c1c115526eb52e%7C0%7C0%7C636570796836830850&sdata=tTsB0dONiOcOxvSHzo33ZYONZ7DX3F6EaItSuyBhR0Q%3D&reserved=0>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Terry Phelps 2018-03-19 19:10:35 Compile error while building postgresql 10.3
Previous Message Azimuddin Mohammed 2018-03-19 18:07:21 postgres start up error