{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/BashOnWindows/issues/61","repository_url":"https://api.github.com/repos/Microsoft/BashOnWindows","labels_url":"https://api.github.com/repos/Microsoft/BashOnWindows/issues/61/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/BashOnWindows/issues/61/comments","events_url":"https://api.github.com/repos/Microsoft/BashOnWindows/issues/61/events","html_url":"https://github.com/Microsoft/BashOnWindows/issues/61","id":146876200,"number":61,"title":"install postgresql issue","user":{"login":"jiangjianxiao","id":1088741,"avatar_url":"https://avatars.githubusercontent.com/u/1088741?v=3","gravatar_id":"","url":"https://api.github.com/users/jiangjianxiao","html_url":"https://github.com/jiangjianxiao","followers_url":"https://api.github.com/users/jiangjianxiao/followers","following_url":"https://api.github.com/users/jiangjianxiao/following{/other_user}","gists_url":"https://api.github.com/users/jiangjianxiao/gists{/gist_id}","starred_url":"https://api.github.com/users/jiangjianxiao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jiangjianxiao/subscriptions","organizations_url":"https://api.github.com/users/jiangjianxiao/orgs","repos_url":"https://api.github.com/users/jiangjianxiao/repos","events_url":"https://api.github.com/users/jiangjianxiao/events{/privacy}","received_events_url":"https://api.github.com/users/jiangjianxiao/received_events","type":"User","site_admin":false},"labels":[{"id":353748836,"url":"https://api.github.com/repos/Microsoft/BashOnWindows/labels/bug","name":"bug","color":"ee0701","default":true},{"id":468076882,"url":"https://api.github.com/repos/Microsoft/BashOnWindows/labels/postgress","name":"postgress","color":"006b75","default":false},{"id":379300108,"url":"https://api.github.com/repos/Microsoft/BashOnWindows/labels/workaround-available","name":"workaround-available","color":"5319e7","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":71,"created_at":"2016-04-08T09:35:40Z","updated_at":"2017-01-17T20:42:29Z","closed_at":null,"body":"# pg_createcluster 9.5 main --start\n\n```\nCreating new cluster 9.5/main ...\n  config /etc/postgresql/9.5/main\n  data   /var/lib/postgresql/9.5/main\n  locale en_US.UTF-8\nFATAL:  could not create shared memory segment: Invalid argument\nDETAIL:  Failed system call was shmget(key=1, size=56, 03600).\nHINT:  This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter, or possibly that it is less than your kernel's SHMMIN parameter.\n        The PostgreSQL documentation contains more information about shared memory configuration.\nchild process exited with exit code 1\ninitdb: removing contents of data directory \"/var/lib/postgresql/9.5/main\"\nError: initdb failed\n\n```\n\nsysctl -w kernel.shmmax=1\nsysctl: cannot stat /proc/sys/kernel/shmmax: No such file or directory\n"},"comment":{"url":"https://api.github.com/repos/Microsoft/BashOnWindows/issues/comments/273293457","html_url":"https://github.com/Microsoft/BashOnWindows/issues/61#issuecomment-273293457","issue_url":"https://api.github.com/repos/Microsoft/BashOnWindows/issues/61","id":273293457,"user":{"login":"arjennienhuis","id":15640868,"avatar_url":"https://avatars.githubusercontent.com/u/15640868?v=3","gravatar_id":"","url":"https://api.github.com/users/arjennienhuis","html_url":"https://github.com/arjennienhuis","followers_url":"https://api.github.com/users/arjennienhuis/followers","following_url":"https://api.github.com/users/arjennienhuis/following{/other_user}","gists_url":"https://api.github.com/users/arjennienhuis/gists{/gist_id}","starred_url":"https://api.github.com/users/arjennienhuis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arjennienhuis/subscriptions","organizations_url":"https://api.github.com/users/arjennienhuis/orgs","repos_url":"https://api.github.com/users/arjennienhuis/repos","events_url":"https://api.github.com/users/arjennienhuis/events{/privacy}","received_events_url":"https://api.github.com/users/arjennienhuis/received_events","type":"User","site_admin":false},"created_at":"2017-01-17T20:42:29Z","updated_at":"2017-01-17T20:42:29Z","body":"````\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ sudo apt install postgresql-9.5\r\nReading package lists... Done\r\nBuilding dependency tree\r\nReading state information... Done\r\nThe following additional packages will be installed:\r\n  libpq5 libsensors4 libxslt1.1 postgresql-client-9.5 postgresql-client-common postgresql-common\r\n  postgresql-contrib-9.5 ssl-cert sysstat\r\nSuggested packages:\r\n  lm-sensors locales-all postgresql-doc-9.5 libdbd-pg-perl openssl-blacklist isag\r\nThe following NEW packages will be installed:\r\n  libpq5 libsensors4 libxslt1.1 postgresql-9.5 postgresql-client-9.5 postgresql-client-common postgresql-common\r\n  postgresql-contrib-9.5 ssl-cert sysstat\r\n0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded.\r\nNeed to get 4,978 kB of archives.\r\nAfter this operation, 20.0 MB of additional disk space will be used.\r\nDo you want to continue? [Y/n]\r\nGet:1 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 libpq5 amd64 9.5.4-0ubuntu0.16.04 [77.8 kB]\r\nGet:2 http://archive.ubuntu.com/ubuntu xenial/main amd64 libsensors4 amd64 1:3.4.0-2 [28.4 kB]\r\nGet:3 http://archive.ubuntu.com/ubuntu xenial/main amd64 libxslt1.1 amd64 1.1.28-2.1 [145 kB]\r\nGet:4 http://archive.ubuntu.com/ubuntu xenial/main amd64 postgresql-client-common all 173 [28.3 kB]\r\nGet:5 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 postgresql-client-9.5 amd64 9.5.4-0ubuntu0.16.04 [860 kB]\r\nGet:6 http://archive.ubuntu.com/ubuntu xenial/main amd64 ssl-cert all 1.0.37 [16.9 kB]\r\nGet:7 http://archive.ubuntu.com/ubuntu xenial/main amd64 postgresql-common all 173 [153 kB]\r\nGet:8 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 postgresql-9.5 amd64 9.5.4-0ubuntu0.16.04 [2,980 kB]\r\nGet:9 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 postgresql-contrib-9.5 amd64 9.5.4-0ubuntu0.16.04 [446 kB]\r\nGet:10 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 sysstat amd64 11.2.0-1ubuntu0.1 [243 kB]\r\nFetched 4,978 kB in 1s (3,139 kB/s)\r\nSelecting previously unselected package libpq5:amd64.\r\n(Reading database ... 25453 files and directories currently installed.)\r\nSelecting previously unselected package libsensors4:amd64...........................................................]\r\nSelecting previously unselected package libxslt1.1:amd64............................................................]\r\nSelecting previously unselected package postgresql-client-common....................................................]\r\nSelecting previously unselected package postgresql-client-9.5.......................................................]\r\nSelecting previously unselected package ssl-cert....................................................................]\r\nSelecting previously unselected package postgresql-common...........................................................]\r\nAdding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'.......................]\r\nSelecting previously unselected package postgresql-9.5.####.........................................................]\r\nSelecting previously unselected package postgresql-contrib-9.5.##...................................................]\r\nSelecting previously unselected package sysstat.######################..............................................]\r\nProcessing triggers for libc-bin (2.23-0ubuntu3) ...########################........................................]\r\nProcessing triggers for man-db (2.7.5-1) ...\r\nProcessing triggers for systemd (229-4ubuntu8) ...\r\nProcessing triggers for ureadahead (0.100.0-19) ...\r\nupdate-alternatives: using /usr/share/postgresql/9.5/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1Adding user postgres to group ssl-cert###############################################################...............]\r\n\r\nCreating config file /etc/postgresql-common/createcluster.conf with new version\r\n\r\nCreating config file /etc/logrotate.d/postgresql-common with new version\r\nBuilding PostgreSQL dictionaries from installed myspell/hunspell packages...\r\nRemoving obsolete dictionary files:\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nUnescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/(?<!\\\\)\\${ <-- HERE ([^}]+)}/ at /usr/sbin/pam_getenv line 78.\r\nCreating new cluster 9.5/main ...\r\n  config /etc/postgresql/9.5/main\r\n  data   /var/lib/postgresql/9.5/main\r\n  locale C\r\n  socket /var/run/postgresql\r\n  port   5432\r\nupdate-alternatives: using /usr/share/postgresql/9.5/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode\r\nProgress: [ 96%] [###############################################################################################...]\r\nCreating config file /etc/default/sysstat with new version\r\nProcessing triggers for libc-bin (2.23-0ubuntu3) ...###############################################################.]\r\nProcessing triggers for systemd (229-4ubuntu8) ...\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ psql\r\npsql: could not connect to server: No such file or directory\r\n        Is the server running locally and accepting\r\n        connections on Unix domain socket \"/var/run/postgresql/.s.PGSQL.5432\"?\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ pg_lsclusters\r\nVer Cluster Port Status Owner    Data directory               Log file\r\n9.5 main    5432 down   postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ sudo lcluster 9.5 main start\r\nThe PostgreSQL server failed to start. Please check the log output:\r\n2017-01-17 21:00:49 STD [2474-1] LOG:  database system was shut down at 2017-01-17 20:59:36 STD\r\n2017-01-17 21:00:49 STD [2474-2] LOG:  MultiXact member wraparound protections are now enabled\r\n2017-01-17 21:00:49 STD [2478-1] LOG:  autovacuum launcher started\r\n2017-01-17 21:00:49 STD [2473-1] LOG:  database system is ready to accept connections\r\n2017-01-17 21:00:50 STD [2480-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:50 STD [2483-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:51 STD [2486-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:51 STD [2489-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:52 STD [2492-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:52 STD [2495-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:53 STD [2498-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:54 STD [2501-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:54 STD [2504-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:55 STD [2507-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:55 STD [2510-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\n2017-01-17 21:00:56 STD [2513-1] [unknown]@[unknown] LOG:  incomplete startup packet\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ psql\r\npsql: could not get socket error status: Invalid argument\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ sudo sed -i s/md5$/trust/  /etc/postgresql/9.5/main/pg_hba.conf\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ sudo pg_ctlcluster 9.5 main reload\r\narjen@DESKTOP-PVQK426:/mnt/c/Users/Arjen$ psql --host 127.0.0.1 --user postgres\r\npsql (9.5.4)\r\nSSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)\r\nType \"help\" for help.\r\n\r\npostgres=#\r\n````\r\n\r\nWhich is insecure because it disables all password checking"}}
{"actor":{"display_login":"arjennienhuis"}}