I got this message while installing postgres for DSpace - is it a big deal ?

[Ashim Kapoor]

Dear All,

Here is what I did / output / corresponding log file.

This is part which was in red text and has me worried:-

Ver Cluster Port Status Owner    Data directory              Log file
11  main    5432 down   postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log

Also the last line in the log file is :-

2020-03-04 11:42:37.522 IST [4933] [unknown]@[unknown] LOG:  incomplete startup packet

Is the above worrisome?

Many thanks,

Ashim

------------- snip ---------------------full details. ----------------------------

dspace@DSpace:~$ sudo apt-get install postgresql postgresql-contrib
Reading package lists... Done
Building dependency tree      
Reading state information... Done
The following additional packages will be installed:
  postgresql-11 postgresql-client-11 postgresql-client-common postgresql-common sysstat
Suggested packages:
  postgresql-doc postgresql-doc-11 libjson-perl isag
The following NEW packages will be installed:
  postgresql postgresql-11 postgresql-client-11 postgresql-client-common postgresql-common
  postgresql-contrib sysstat
0 upgraded, 7 newly installed, 0 to remove and 0 not upgraded.
Need to get 16.5 MB of archives.
After this operation, 54.7 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://debianmirror.nkn.in/debian buster/main amd64 postgresql-client-common all 200+deb10u3 [84.9 kB]
Get:2 http://debianmirror.nkn.in/debian buster/main amd64 postgresql-common all 200+deb10u3 [225 kB]
Get:3 http://debianmirror.nkn.in/debian buster/main amd64 postgresql all 11+200+deb10u3 [60.9 kB]
Get:4 http://debianmirror.nkn.in/debian buster/main amd64 postgresql-contrib all 11+200+deb10u3 [60.9 kB]
Get:5 http://debianmirror.nkn.in/debian buster/main amd64 sysstat amd64 12.0.3-2 [562 kB]
Get:6 http://security-cdn.debian.org/debian-security buster/updates/main amd64 postgresql-client-11 amd64 11.7-0+deb10u1 [1,390 kB]
Get:7 http://security-cdn.debian.org/debian-security buster/updates/main amd64 postgresql-11 amd64 11.7-0+deb10u1 [14.1 MB]
Fetched 16.5 MB in 14s (1,199 kB/s)                                                                
Preconfiguring packages ...
Selecting previously unselected package postgresql-client-common.
(Reading database ... 105776 files and directories currently installed.)
Preparing to unpack .../0-postgresql-client-common_200+deb10u3_all.deb ...
Unpacking postgresql-client-common (200+deb10u3) ...
Selecting previously unselected package postgresql-client-11.
Preparing to unpack .../1-postgresql-client-11_11.7-0+deb10u1_amd64.deb ...
Unpacking postgresql-client-11 (11.7-0+deb10u1) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../2-postgresql-common_200+deb10u3_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (200+deb10u3) ...
Selecting previously unselected package postgresql-11.
Preparing to unpack .../3-postgresql-11_11.7-0+deb10u1_amd64.deb ...
Unpacking postgresql-11 (11.7-0+deb10u1) ...
Selecting previously unselected package postgresql.
Preparing to unpack .../4-postgresql_11+200+deb10u3_all.deb ...
Unpacking postgresql (11+200+deb10u3) ...
Selecting previously unselected package postgresql-contrib.
Preparing to unpack .../5-postgresql-contrib_11+200+deb10u3_all.deb ...
Unpacking postgresql-contrib (11+200+deb10u3) ...
Selecting previously unselected package sysstat.
Preparing to unpack .../6-sysstat_12.0.3-2_amd64.deb ...
Unpacking sysstat (12.0.3-2) ...
Setting up postgresql-client-common (200+deb10u3) ...
Setting up postgresql-client-11 (11.7-0+deb10u1) ...
update-alternatives: using /usr/share/postgresql/11/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (200+deb10u3) ...
Adding user postgres to group ssl-cert

Creating config file /etc/postgresql-common/createcluster.conf with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
  en_us
Removing obsolete dictionary files:
Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service.
Setting up postgresql-11 (11.7-0+deb10u1) ...
Creating new PostgreSQL cluster 11/main ...
/usr/lib/postgresql/11/bin/initdb -D /var/lib/postgresql/11/main --auth-local peer --auth-host md5
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_IN".
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/postgresql/11/main ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... Asia/Kolkata
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:

    pg_ctlcluster 11 main start

Ver Cluster Port Status Owner    Data directory              Log file
11  main    5432 down   postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
update-alternatives: using /usr/share/postgresql/11/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
Setting up postgresql-contrib (11+200+deb10u3) ...
Setting up postgresql (11+200+deb10u3) ...
Setting up sysstat (12.0.3-2) ...

Creating config file /etc/default/sysstat with new version
update-alternatives: using /usr/bin/sar.sysstat to provide /usr/bin/sar (sar) in auto mode
Created symlink /etc/systemd/system/multi-user.target.wants/sysstat.service → /lib/systemd/system/sysstat.service.
Processing triggers for man-db (2.8.5-2) ...
Processing triggers for systemd (241-7~deb10u3) ...
dspace@DSpace:~$ cat /var/log/postgresql/postgresql-11-main.log
cat: /var/log/postgresql/postgresql-11-main.log: Permission denied
dspace@DSpace:~$ sudo cat /var/log/postgresql/postgresql-11-main.log
2020-03-04 11:42:36.945 IST [4925] LOG:  listening on IPv6 address "::1", port 5432
2020-03-04 11:42:36.945 IST [4925] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2020-03-04 11:42:36.946 IST [4925] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2020-03-04 11:42:36.958 IST [4926] LOG:  database system was shut down at 2020-03-04 11:42:34 IST
2020-03-04 11:42:36.961 IST [4925] LOG:  database system is ready to accept connections
2020-03-04 11:42:37.522 IST [4933] [unknown]@[unknown] LOG:  incomplete startup packet
dspace@DSpace:~$