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:~$ -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CAGEJAoF1GqT3pT%3Db2Lh74CUyWwFdhXPRG22GBKkJKBEzbzaV2A%40mail.gmail.com.
