Geek Answers Handbook

Where are the Postgresql 9.1 logs? (not starting with FreeBSD 10)

I tried to find solutions, but nothing helps.

I need to backup my pgsql data from an application that I have not used for several months. I found that the postgresql server is not working. But he cannot start it.

I run pg_ctl -D /usr/local/pgsql/data -l logging.log -w -s startas pgsqluser (su pgsql). The output says that it cannot start the server and tells me to check the logs. But logging.log is an empty file. Any default log file that I found on the Internet has been modified a few months ago or is empty or does not even exist.

I don’t know how to find the error, because the logs are empty or I just don’t know where to look for them.

Important note: it worked a few months ago, but during this time there were almost no changes (it is possible to change the host name).

  • Postgres v9.1
  • System: FreeBSD 10.0-RC4
+4
source share
1 answer

Some versions of FreeBSD ports have PostgreSQL installed with syslog enabled. You can confirm this by looking at /usr/local/pgsql/data/postgresql.conf for log_destination = 'syslog'

If so, the log output should be visible in / var / log / messages

+2
source

More articles:


All Articles