Postgresql 8.3 nie uruchamia si

taksiarz · Post autor: **taksiarz** » 30 lipca 2013, 08:29

Witam.

Mam problem na Debianie 5.0 z postgresql 8.3. Po ponownym uruchomieniu serwera nie uruchamia się postgresql.

Z palca wpisałem jako root:

Kod: Zaznacz cały

/etc/init.d/postgresql-8.3 start

otrzymuję:

Kod: Zaznacz cały

 failded!

Plik:

Kod: Zaznacz cały

/var/log/postgresql-8.3

jest pusty, ten aktualny.

Proszę o wskazówki i pomoc. Na tym serwerze jest uruchomiony LTmandat. A pracownik, który to wszystko instalował wyjechał.

czarownik · Post autor: **czarownik** » 30 lipca 2013, 11:52

A czy na pewno robisz to jako root? A robiłeś najpierw stop a potem start?

Sprawdź, czy masz coś w /var/log/syslog i w konfiguracji PostreSQL gdzie zapisujesz logi.

taksiarz · Post autor: **taksiarz** » 30 lipca 2013, 12:16

Robię to jako root. Nie dawałem stop. Spróbuję. Przejżę jeszcze logi.

Kod: Zaznacz cały

lt-mandaty:~# /etc/init.d/postgresql-8.3 stop
Stopping PostgreSQL 8.3 database server: main.
lt-mandaty:~# /etc/init.d/postgresql-8.3 start
Starting PostgreSQL 8.3 database server: mainThe PostgreSQL server failed to start. Please check the log output. failed!
 failed!

/var/log/syslog

Kod: Zaznacz cały

Jul 29 06:31:26 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database
Jul 29 06:36:26 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011.
Jul 29 06:36:26 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database
Jul 29 06:41:26 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011.
Jul 29 06:41:27 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database
Jul 29 06:46:27 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011.
Jul 29 06:46:27 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database
Jul 29 06:51:28 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011.
Jul 29 06:51:28 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database
@

czarownik · Post autor: **czarownik** » 30 lipca 2013, 13:44

Przedstaw wynik (jako root):

Kod: Zaznacz cały

nano /etc/postgresql/8.3/main/postgresql.conf | grep log_

taksiarz · Post autor: **taksiarz** » 30 lipca 2013, 14:08

Kod: Zaznacz cały

lt-mandaty:~# vim /etc/postgresql/8.3/main/postgresql.conf
#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

#log_destination = 'stderr'             # Valid values are combinations of
                                        # stderr, csvlog, syslog and eventlog,
                                        # depending on platform.  csvlog
                                        # requires logging_collector to be on.

# This is used when logging to stderr:
#logging_collector = off                # Enable capturing of stderr and csvlog
                                        # into log files. Required to be on for
                                        # csvlogs.
                                        # (change requires restart)

# These are only used if logging_collector is on:
#log_directory = 'pg_log'               # directory where log files are written,
                                        # can be absolute or relative to PGDATA
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'        # log file name pattern,
                                        # can include strftime() escapes
#log_truncate_on_rotation = off         # If on, an existing log file of the
                                        # same name as the new log file will be
                                        # truncated rather than appended to.
                                        # But such truncation only occurs on
                                        # time-driven rotation, not on restarts
                                        # or size-driven rotation.  Default is
                                        # off, meaning append to existing files
                                        # in all cases.
#log_rotation_age = 1d                  # Automatic rotation of logfiles will
                                        # happen after that time.  0 to disable.
#log_rotation_size = 10MB               # Automatic rotation of logfiles will
                                        # happen after that much log output.
                                        # 0 to disable.

# These are relevant when logging to syslog:

Przepraszam, ale przez puttiego się loguje na serwer.
Inny forumowicz pisał coś o pliku lock.

czarownik · Post autor: **czarownik** » 05 sierpnia 2013, 08:15

taksiarz pisze: /var/log/syslog

Kod: Zaznacz cały

 Jul 29 06:31:26 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database Jul 29 06:36:26 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011. Jul 29 06:36:26 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database Jul 29 06:41:26 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011. Jul 29 06:41:27 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database Jul 29 06:46:27 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011. Jul 29 06:46:27 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database Jul 29 06:51:28 lt-mandaty ddclient[2206]: WARNING:  forcing update of ltm001.dyndns.ws from 80.53.21.177 to 80.53.21.177; 30 days since last update on Tue Oct 18 08:14:36 2011. Jul 29 06:51:28 lt-mandaty ddclient[2206]: FAILED:   updating ltm001.dyndns.ws: nohost: The hostname specified does not exist in the database @

A w pliku kernel.log nic nie ma?

Postgresql 8.3 nie uruchamia si

Postgresql 8.3 nie uruchamia się