Re: BUG #16261: Not able to start Postgres

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Abhishree hn <abhishreehn(at)crgroup(dot)co(dot)in>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16261: Not able to start Postgres
Date: 2020-02-17 12:58:58
Message-ID: 29275F36-FC96-4D0C-83D0-BB081D5C2233@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On 17 Feb 2020, at 13:29, Abhishree hn <abhishreehn(at)crgroup(dot)co(dot)in> wrote:
>
> Hi Daniel,
>
> please find the logs below.

Please retain all addresses in your reply.

> The files belonging to this database system will be owned by user "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale "en_US.UTF-8".
> The default database encoding has accordingly been set to "UTF8".
> The default text search configuration will be set to "english".
>
> Data page checksums are disabled.
>
> fixing permissions on existing directory /var/lib/pgsql/9.6/data ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers ... 128MB
> selecting dynamic shared memory implementation ... posix
> creating configuration files ... ok
> running bootstrap script ... ok
> performing post-bootstrap initialization ... ok
> syncing data to disk ... ok
>
> Success. You can now start the database server using:
>
> /usr/pgsql-9.6/bin/pg_ctl -D /var/lib/pgsql/9.6/data -l logfile start
>
> < 2018-11-02 19:13:03.637 UTC > LOG: redirecting log output to logging collector process
> < 2018-11-02 19:13:03.637 UTC > HINT: Future log output will appear in directory "pg_log".
> < 2018-11-02 19:31:50.580 UTC > LOG: redirecting log output to logging collector process
> < 2018-11-02 19:31:50.580 UTC > HINT: Future log output will appear in directory "pg_log".
> < 2018-11-02 19:35:07.110 UTC > LOG: redirecting log output to logging collector process
> < 2018-11-02 19:35:07.110 UTC > HINT: Future log output will appear in directory "pg_log".
> < 2018-12-04 10:59:50.478 UTC > FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": No such file or directory
> < 2018-12-04 10:59:50.478 UTC > LOG: database system is shut down

This log entry might be related to the database not starting. Does that
directory exist and if so, is it writeable by the process?

cheers ./daniel

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message GABORIEAU Olivier 2020-02-17 13:02:23 RE: BUG #16257: 12.2 rpm packages size increase vs 12.1
Previous Message Daniel Gustafsson 2020-02-17 12:10:21 Re: BUG #16261: Not able to start Postgres