Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ┌────────────────────────────────────────────────────────────────────┐
- │ • MobaXterm 10.2 • │
- │ (SSH client, X-server and networking tools) │
- │ │
- │ ➤ SSH session to jeanfelix@149.202.82.131 │
- │ • SSH compression : ✔ │
- │ • SSH-browser : ✔ │
- │ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
- │ • DISPLAY : ✔ (automatically set on remote server) │
- │ │
- │ ➤ For more info, ctrl+click on help or visit our website │
- └────────────────────────────────────────────────────────────────────┘
- Last login: Thu Mar 30 18:02:03 2017 from 236-131-190-109.isp.overthebox.ovh
- [jeanfelix@postgre1 ~]$
- ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
- Session stopped
- - Press <return> to exit tab
- - Press R to restart session
- - Press S to save terminal output to file
- Network error: Software caused connection abort
- ┌────────────────────────────────────────────────────────────────────┐
- │ • MobaXterm 10.2 • │
- │ (SSH client, X-server and networking tools) │
- │ │
- │ ➤ SSH session to jeanfelix@149.202.82.131 │
- │ • SSH compression : ✔ │
- │ • SSH-browser : ✔ │
- │ • X11-forwarding : ✔ (remote display is forwarded through SSH) │
- │ • DISPLAY : ✔ (automatically set on remote server) │
- │ │
- │ ➤ For more info, ctrl+click on help or visit our website │
- └────────────────────────────────────────────────────────────────────┘
- Last login: Fri Mar 31 09:14:13 2017 from lputeaux-656-1-62-139.w80-12.abo.wanadoo.fr
- [jeanfelix@postgre1 ~]$ sudo systemctl start posrtgresql-9.6
- [sudo] password for jeanfelix:
- Failed to start posrtgresql-9.6.service: Unit not found.
- [jeanfelix@postgre1 ~]$ sudo systemctl start postgresql-9.6
- 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.
- [jeanfelix@postgre1 ~]$ journalctl -xe
- -- Unit session-163.scope has begun starting up.
- Mar 31 16:13:04 postgre1 systemd-logind[603]: New session 164 of user jeanfelix.
- -- Subject: A new session 164 has been created for user jeanfelix
- -- Defined-By: systemd
- -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
- -- Documentation: http://www.freedesktop.org/wiki/Software/systemd/multiseat
- --
- -- A new session with the ID 164 has been created for the user jeanfelix.
- --
- -- The leading process of the session is 19728.
- Mar 31 16:13:04 postgre1 systemd[1]: Started Session 164 of user jeanfelix.
- -- Subject: Unit session-164.scope has finished start-up
- -- Defined-By: systemd
- -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
- --
- -- Unit session-164.scope has finished starting up.
- --
- -- The start-up result is done.
- Mar 31 16:13:04 postgre1 sshd[19724]: pam_unix(sshd:session): session opened for user jeanfelix by (uid=0)
- Mar 31 16:13:04 postgre1 systemd[1]: Starting Session 164 of user jeanfelix.
- -- Subject: Unit session-164.scope has begun start-up
- -- Defined-By: systemd
- -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
- --
- -- Unit session-164.scope has begun starting up.
- Mar 31 16:13:04 postgre1 sshd[19728]: pam_unix(sshd:session): session opened for user jeanfelix by (uid=0)
- Mar 31 16:13:05 postgre1 dbus-daemon[584]: dbus[584]: [system] Activating service name='org.freedesktop.problems' (using servicehelper)
- Mar 31 16:13:05 postgre1 dbus[584]: [system] Activating service name='org.freedesktop.problems' (using servicehelper)
- Mar 31 16:13:05 postgre1 dbus[584]: [system] Successfully activated service 'org.freedesktop.problems'
- Mar 31 16:13:05 postgre1 dbus-daemon[584]: dbus[584]: [system] Successfully activated service 'org.freedesktop.problems'
- Mar 31 16:13:21 postgre1 sudo[19793]: jeanfelix : TTY=pts/1 ; PWD=/home/jeanfelix ; USER=root ; COMMAND=/bin/systemctl start posrtgresql-9.6
- 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
- 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-
- Mar 31 16:13:58 postgre1 sudo[19815]: jeanfelix : TTY=pts/1 ; PWD=/home/jeanfelix ; USER=root ; COMMAND=/bin/systemctl start postgresql-9.6
- 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
- Mar 31 16:13:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
- -- Subject: Unit postgresql-9.6.service has begun start-up
- -- Defined-By: systemd
- -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
- --
- -- Unit postgresql-9.6.service has begun starting up.
- Mar 31 16:13:58 postgre1 postmaster[19830]: < 2017-03-31 16:13:58.495 CEST > LOG: redirecting log output to logging collector process
- 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".
- Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
- Mar 31 16:13:58 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
- -- Subject: Unit postgresql-9.6.service has failed
- -- Defined-By: systemd
- -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
- --
- -- Unit postgresql-9.6.service has failed.
- --
- -- The result is failed.
- Mar 31 16:13:58 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
- Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service failed.
- 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-
- [jeanfelix@postgre1 ~]$ sudo journalctl -u postgresql-9.6.service --since yesterday
- [sudo] password for jeanfelix:
- -- Logs begin at Thu 2017-03-30 17:57:32 CEST, end at Fri 2017-03-31 16:23:26 CEST. --
- Mar 30 17:57:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
- Mar 30 17:58:00 postgre1 postmaster[995]: < 2017-03-30 17:58:00.403 CEST > LOG: redirecting log output to logging collector process
- 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".
- Mar 30 17:58:00 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
- Mar 30 17:58:00 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
- Mar 30 17:58:00 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
- Mar 30 17:58:00 postgre1 systemd[1]: postgresql-9.6.service failed.
- Mar 30 18:02:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
- Mar 30 18:02:58 postgre1 postmaster[2868]: < 2017-03-30 18:02:58.564 CEST > LOG: redirecting log output to logging collector process
- 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".
- Mar 30 18:02:58 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
- Mar 30 18:02:58 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
- Mar 30 18:02:58 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
- Mar 30 18:02:58 postgre1 systemd[1]: postgresql-9.6.service failed.
- Mar 30 18:12:10 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
- Mar 30 18:12:10 postgre1 postmaster[3023]: < 2017-03-30 18:12:10.223 CEST > LOG: redirecting log output to logging collector process
- 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".
- Mar 30 18:12:10 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
- Mar 30 18:12:10 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
- Mar 30 18:12:10 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
- Mar 30 18:12:10 postgre1 systemd[1]: postgresql-9.6.service failed.
- Mar 31 16:13:58 postgre1 systemd[1]: Starting PostgreSQL 9.6 database server...
- Mar 31 16:13:58 postgre1 postmaster[19830]: < 2017-03-31 16:13:58.495 CEST > LOG: redirecting log output to logging collector process
- 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".
- Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service: main process exited, code=exited, status=1/FAILURE
- Mar 31 16:13:58 postgre1 systemd[1]: Failed to start PostgreSQL 9.6 database server.
- Mar 31 16:13:58 postgre1 systemd[1]: Unit postgresql-9.6.service entered failed state.
- Mar 31 16:13:58 postgre1 systemd[1]: postgresql-9.6.service failed.
- [jeanfelix@postgre1 ~]$ su - postgres
- Password:
- ^C
- [jeanfelix@postgre1 ~]$ sudo su - postgres
- [sudo] password for jeanfelix:
- Last login: Thu Mar 30 18:07:46 CEST 2017 on pts/0
- -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log
- -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log/postgresql-
- postgresql-Fri.log postgresql-Thu.log postgresql-Wed.log
- -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log/postgresql-
- postgresql-Fri.log postgresql-Thu.log postgresql-Wed.log
- -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_log/postgresql-Thu.log
- -bash-4.2$ vi /var/lib/pgsql/9.6/data/pg_hba.conf
- -bash-4.2$ vi /var/lib/pgsql/9.6/data/postgresql.conf
- # -----------------------------
- # PostgreSQL configuration file
- # -----------------------------
- #
- # This file consists of lines of the form:
- #
- # name = value
- #
- # (The "=" is optional.) Whitespace may be used. Comments are introduced with
- # "#" anywhere on a line. The complete list of parameter names and allowed
- # values can be found in the PostgreSQL documentation.
- #
- # The commented-out settings shown in this file represent the default values.
- # Re-commenting a setting is NOT sufficient to revert it to the default value;
- # you need to reload the server.
- #
- # This file is read on server startup and when the server receives a SIGHUP
- # signal. If you edit the file on a running system, you have to SIGHUP the
- # server for the changes to take effect, or use "pg_ctl reload". Some
- # parameters, which are marked below, require a server shutdown and restart to
- # take effect.
- #
- # Any parameter can also be given as a command-line option to the server, e.g.,
- # "postgres -c log_connections=on". Some parameters can be changed at run time
- # with the "SET" SQL command.
- #
- # Memory units: kB = kilobytes Time units: ms = milliseconds
- # MB = megabytes s = seconds
- # GB = gigabytes min = minutes
- # TB = terabytes h = hours
- # d = days
- #------------------------------------------------------------------------------
- # FILE LOCATIONS
- #------------------------------------------------------------------------------
- # The default values of these variables are driven from the -D command-line
- # option or PGDATA environment variable, represented here as ConfigDir.
- #data_directory = 'ConfigDir' # use data in another directory
- # (change requires restart)
- #hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file
- # (change requires restart)
- #ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file
- # (change requires restart)
- # If external_pid_file is not explicitly set, no extra PID file is written.
- #external_pid_file = '' # write an extra PID file
- # (change requires restart)
- #------------------------------------------------------------------------------
- # CONNECTIONS AND AUTHENTICATION
- #------------------------------------------------------------------------------
- "~/9.6/data/postgresql.conf" 641L, 22252C
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement