API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 31st, 2017
562
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.11 KB | None | 0 0
raw download clone embed print report
  1. ┌────────────────────────────────────────────────────────────────────┐
  2. │ • MobaXterm 10.2 • │
  3. │ (SSH client, X-server and networking tools) │
  4. │ │
  5. │ ➤ SSH session to jeanfelix@149.202.82.131 │
  6. │ • SSH compression : ✔ │
  7. │ • SSH-browser : ✔ │
  8. │ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
  9. │ • DISPLAY : ✔ (automatically set on remote server) │
  10. │ │
  11. │ ➤ For more info, ctrl+click on help or visit our website │
  12. └────────────────────────────────────────────────────────────────────┘
  13.  
  14. Last login: Thu Mar 30 18:02:03 2017 from 236-131-190-109.isp.overthebox.ovh
  15. [jeanfelix@postgre1 ~]$
  16. ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
  17.  
  18. Session stopped
  19. - Press <return> to exit tab
  20. - Press R to restart session
  21. - Press S to save terminal output to file
  22.  
  23. Network error: Software caused connection abort
  24. ┌────────────────────────────────────────────────────────────────────┐
  25. │ • MobaXterm 10.2 • │
  26. │ (SSH client, X-server and networking tools) │
  27. │ │
  28. │ ➤ SSH session to jeanfelix@149.202.82.131 │
  29. │ • SSH compression : ✔ │
  30. │ • SSH-browser : ✔ │
  31. │ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
  32. │ • DISPLAY : ✔ (automatically set on remote server) │
  33. │ │
  34. │ ➤ For more info, ctrl+click on help or visit our website │
  35. └────────────────────────────────────────────────────────────────────┘
  36.  
  37. Last login: Fri Mar 31 09:14:13 2017 from lputeaux-656-1-62-139.w80-12.abo.wanadoo.fr
  38. [jeanfelix@postgre1 ~]$ sudo systemctl start posrtgresql-9.6
  39. [sudo] password for jeanfelix:
  40. Failed to start posrtgresql-9.6.service: Unit not found.
  41. [jeanfelix@postgre1 ~]$ sudo systemctl start postgresql-9.6
  42. Job for postgresql-9.6.service failed because the control process exited with error code. See "systemctl status postgresql-9.6.service" and "journalctl -xe" for details.
  43. [jeanfelix@postgre1 ~]$ journalctl -xe
  44. -- Unit session-163.scope has begun starting up.
  45. Mar 31 16:13:04 postgre1 systemd-logind[603]: New session 164 of user jeanfelix.
  46. -- Subject: A new session 164 has been created for user jeanfelix
  47. -- Defined-By: systemd
  48. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  49. -- Documentation: http://www.freedesktop.org/wiki/Software/systemd/multiseat
  50. --
  51. -- A new session with the ID 164 has been created for the user jeanfelix.
  52. --
  53. -- The leading process of the session is 19728.
  54. Mar 31 16:13:04 postgre1 systemd[1]: Started Session 164 of user jeanfelix.
  55. -- Subject: Unit session-164.scope has finished start-up
  56. -- Defined-By: systemd
  57. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  58. --
  59. -- Unit session-164.scope has finished starting up.
  60. --
  61. -- The start-up result is done.
  62. Mar 31 16:13:04 postgre1 sshd[19724]: pam_unix(sshd:session): session opened for user jeanfelix by (uid=0)
  63. Mar 31 16:13:04 postgre1 systemd[1]: Starting Session 164 of user jeanfelix.
  64. -- Subject: Unit session-164.scope has begun start-up
  65. -- Defined-By: systemd
  66. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  67. --
  68. -- Unit session-164.scope has begun starting up.
  69. Mar 31 16:13:04 postgre1 sshd[19728]: pam_unix(sshd:session): session opened for user jeanfelix by (uid=0)
  70. Mar 31 16:13:05 postgre1 dbus-daemon[584]: dbus[584]: [system] Activating service name='org.freedesktop.problems' (using servicehelper)
  71. Mar 31 16:13:05 postgre1 dbus[584]: [system] Activating service name='org.freedesktop.problems' (using servicehelper)
  72. Mar 31 16:13:05 postgre1 dbus[584]: [system] Successfully activated service 'org.freedesktop.problems'
  73. Mar 31 16:13:05 postgre1 dbus-daemon[584]: dbus[584]: [system] Successfully activated service 'org.freedesktop.problems'
  74. Mar 31 16:13:21 postgre1 sudo[19793]: jeanfelix : TTY=pts/1 ; PWD=/home/jeanfelix ; USER=root ; COMMAND=/bin/systemctl start posrtgresql-9.6
  75. Mar 31 16:13:21 postgre1 polkitd[577]: Registered Authentication Agent for unix-process:19797:8016767 (system bus name :1.488 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/Poli
  76. Mar 31 16:13:21 postgre1 polkitd[577]: Unregistered Authentication Agent for unix-process:19797:8016767 (system bus name :1.488, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-
  77. Mar 31 16:13:58 postgre1 sudo[19815]: jeanfelix : TTY=pts/1 ; PWD=/home/jeanfelix ; USER=root ; COMMAND=/bin/systemctl start postgresql-9.6
  78. Mar 31 16:13:58 postgre1 polkitd[577]: Registered Authentication Agent for unix-process:19816:8020439 (system bus name :1.489 [/usr/bin/pkttyagent --notify-fd 5 --fallback], object path /org/freedesktop/Poli
  79. Mar 31 16:13:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
  80. -- Subject: Unit postgresql-9.6.service has begun start-up
  81. -- Defined-By: systemd
  82. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  83. --
  84. -- Unit postgresql-9.6.service has begun starting up.
  85. Mar 31 16:13:58 postgre1 postmaster[19830]: < 2017-03-31 16:13:58.495 CEST > LOG: redirecting log output to logging collector process
  86. Mar 31 16:13:58 postgre1 postmaster[19830]: < 2017-03-31 16:13:58.495 CEST > HINT: Future log output will appear in directory "pg_log".
  87. Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
  88. Mar 31 16:13:58 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
  89. -- Subject: Unit postgresql-9.6.service has failed
  90. -- Defined-By: systemd
  91. -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
  92. --
  93. -- Unit postgresql-9.6.service has failed.
  94. --
  95. -- The result is failed.
  96. Mar 31 16:13:58 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
  97. Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service failed.
  98. Mar 31 16:13:58 postgre1 polkitd[577]: Unregistered Authentication Agent for unix-process:19816:8020439 (system bus name :1.489, object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.UTF-
  99. [jeanfelix@postgre1 ~]$ sudo journalctl -u postgresql-9.6.service --since yesterday
  100. [sudo] password for jeanfelix:
  101. -- Logs begin at Thu 2017-03-30 17:57:32 CEST, end at Fri 2017-03-31 16:23:26 CEST. --
  102. Mar 30 17:57:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
  103. Mar 30 17:58:00 postgre1 postmaster[995]: < 2017-03-30 17:58:00.403 CEST > LOG: redirecting log output to logging collector process
  104. Mar 30 17:58:00 postgre1 postmaster[995]: < 2017-03-30 17:58:00.403 CEST > HINT: Future log output will appear in directory "pg_log".
  105. Mar 30 17:58:00 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
  106. Mar 30 17:58:00 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
  107. Mar 30 17:58:00 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
  108. Mar 30 17:58:00 postgre1 systemd[1]: postgresql-9.6.service failed.
  109. Mar 30 18:02:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
  110. Mar 30 18:02:58 postgre1 postmaster[2868]: < 2017-03-30 18:02:58.564 CEST > LOG: redirecting log output to logging collector process
  111. Mar 30 18:02:58 postgre1 postmaster[2868]: < 2017-03-30 18:02:58.564 CEST > HINT: Future log output will appear in directory "pg_log".
  112. Mar 30 18:02:58 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
  113. Mar 30 18:02:58 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
  114. Mar 30 18:02:58 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
  115. Mar 30 18:02:58 postgre1 systemd[1]: postgresql-9.6.service failed.
  116. Mar 30 18:12:10 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
  117. Mar 30 18:12:10 postgre1 postmaster[3023]: < 2017-03-30 18:12:10.223 CEST > LOG: redirecting log output to logging collector process
  118. Mar 30 18:12:10 postgre1 postmaster[3023]: < 2017-03-30 18:12:10.223 CEST > HINT: Future log output will appear in directory "pg_log".
  119. Mar 30 18:12:10 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
  120. Mar 30 18:12:10 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
  121. Mar 30 18:12:10 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
  122. Mar 30 18:12:10 postgre1 systemd[1]: postgresql-9.6.service failed.
  123. Mar 31 16:13:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
  124. Mar 31 16:13:58 postgre1 postmaster[19830]: < 2017-03-31 16:13:58.495 CEST > LOG: redirecting log output to logging collector process
  125. Mar 31 16:13:58 postgre1 postmaster[19830]: < 2017-03-31 16:13:58.495 CEST > HINT: Future log output will appear in directory "pg_log".
  126. Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
  127. Mar 31 16:13:58 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
  128. Mar 31 16:13:58 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
  129. Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service failed.
  130. [jeanfelix@postgre1 ~]$ su - postgres
  131. Password:
  132. ^C
  133. [jeanfelix@postgre1 ~]$ sudo su - postgres
  134. [sudo] password for jeanfelix:
  135. Last login: Thu Mar 30 18:07:46 CEST 2017 on pts/0
  136. -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log
  137. -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log/postgresql-
  138. postgresql-Fri.log postgresql-Thu.log postgresql-Wed.log
  139. -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log/postgresql-
  140. postgresql-Fri.log postgresql-Thu.log postgresql-Wed.log
  141. -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log/postgresql-Thu.log
  142. -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_hba.conf
  143. # specifies the number of significant bits in the mask. A host name
  144. # that starts with a dot (.) matches a suffix of the actual host name.
  145. # Alternatively, you can write an IP address and netmask in separate
  146. # columns to specify the set of hosts. Instead of a CIDR-address, you
  147. # can write "samehost" to match any of the server's own IP addresses,
  148. # or "samenet" to match any address in any subnet that the server is
  149. # directly connected to.
  150. #
  151. # METHOD can be "trust", "reject", "md5", "password", "gss", "sspi",
  152. # "ident", "peer", "pam", "ldap", "radius" or "cert". Note that
  153. # "password" sends passwords in clear text; "md5" is preferred since
  154. # it sends encrypted passwords.
  155. #
  156. # OPTIONS are a set of options for the authentication in the format
  157. # NAME=VALUE. The available options depend on the different
  158. # authentication methods -- refer to the "Client Authentication"
  159. # section in the documentation for a list of which options are
  160. # available for which authentication methods.
  161. #
  162. # Database and user names containing spaces, commas, quotes and other
  163. # special characters must be quoted. Quoting one of the keywords
  164. # "all", "sameuser", "samerole" or "replication" makes the name lose
  165. # its special character, and just match a database or username with
  166. # that name.
  167. #
  168. # This file is read on server startup and when the postmaster receives
  169. # a SIGHUP signal. If you edit the file on a running system, you have
  170. # to SIGHUP the postmaster for the changes to take effect. You can
  171. # use "pg_ctl reload" to do that.
  172.  
  173. # Put your actual configuration here
  174. # ----------------------------------
  175. #
  176. # If you want to allow non-local connections, you need to add more
  177. # "host" records. In that case you will also need to make PostgreSQL
  178. # listen on a non-local interface via the listen_addresses
  179. # configuration parameter, or via the -i or -h command line switches.
  180.  
  181.  
  182.  
  183. # TYPE DATABASE USER ADDRESS METHOD
  184.  
  185. # "local" is for Unix domain socket connections only
  186. local all all peer
  187. # IPv4 local connections:
  188. host all all 127.0.0.1/32 ident
  189. host all all 0.0.0.0/0 md5
  190. hostssl replication replicator 192.168.58.1/16 md5
  191. # IPv6 local connections:
  192. host all all ::1/128 ident
  193. # Allow replication connections from localhost, by a user with the
  194. # replication privilege.
  195. #local replication postgres peer
  196. #host replication postgres 127.0.0.1/32 ident
  197. #host replication postgres ::1/128 ident
  198. Type :quit<Enter> to exit Vim
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!