blocks|key|1287366|text|只需询问您的数据库：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1287367|SELECT+
++++*+
FROM+
++++pg_settings+
WHERE+
++++category+IN(+'Reporting+and+Logging+/+Where+to+Log'+,+'File+Locations')
ORDER+BY+
++++category,
++++name;|code-block|syntax|javascript|1287368|在我的例子中，它在"/Library/PostgreSQL/8.4/data/pg_log“中。|1287369|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Just ask your database:

<pre><code>SELECT 
 * 
FROM 
 pg_settings 
WHERE 
 category IN( 'Reporting and Logging / Where to Log' , 'File Locations')
ORDER BY 
 category,
 name;
</code></pre>

In my case, it's in "/Library/PostgreSQL/8.4/data/pg_log"

blocks|key|1287399|text|在OS+X上，如果您使用的是PostgreSQL的EnterpriseDB安装，您的日志文件将位于/Library/PostgreSQL/8.4/data/pg_log中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1287400|当然，无论您运行的是哪个版本号，您都希望替换为8.4。|1287401|entityMap^0|1D|Z|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

On OS X, if you're using the EnterpriseDB installation of PostgreSQL, your log files will be in <code>/Library/PostgreSQL/8.4/data/pg_log</code>

Of course, you'll want to substitute 8.4 for whichever version number you're running.

blocks|key|1287441|text|用于在启动时启动Postgres的plist也可以设置日志文件：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1287442|$+dir+~/Library/LaunchAgents
org.postgresql.postgres.plist

$+cat+~/Library/LaunchAgents/org.postgresql.postgres.plist
<?xml+version="1.0"+encoding="UTF-8"?>
<!DOCTYPE+plist+PUBLIC+"-//Apple//DTD+PLIST+1.0//EN"+"http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist+version="1.0">
<dict>
++[...]
++<key>StandardErrorPath</key>
++<string>/usr/local/var/postgres/server.log</string>
</dict>
</plist>|code-block|syntax|javascript|1287443|因此，在这种情况下，/usr/local/var/postgres/server.log。|1287444|entityMap^0|H|5|0|0|A|Y|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

The <code>plist</code> used to launch your Postgres on boot may also set the logfile:

<pre><code>$ dir ~/Library/LaunchAgents
org.postgresql.postgres.plist

$ cat ~/Library/LaunchAgents/org.postgresql.postgres.plist
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"&gt;
&lt;plist version="1.0"&gt;
&lt;dict&gt;
 [...]
 &lt;key&gt;StandardErrorPath&lt;/key&gt;
 &lt;string&gt;/usr/local/var/postgres/server.log&lt;/string&gt;
&lt;/dict&gt;
&lt;/plist&gt;
</code></pre>

So in this case, <code>/usr/local/var/postgres/server.log</code>.

blocks|key|1287495|text|我的mac上安装了不同版本的Postgresql+(带macports)，所有日志都可以在这里找到|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1287496|/opt/local/var/log/postgresql84/postgres.log
/opt/local/var/log/postgresql91/postgres.log
/opt/local/var/log/postgresql92/postgres.log|code-block|syntax|javascript|1287497|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I have different Postgresql versions installed on my mac (with macports), and all the logs can be found here

<pre><code>/opt/local/var/log/postgresql84/postgres.log
/opt/local/var/log/postgresql91/postgres.log
/opt/local/var/log/postgresql92/postgres.log
</code></pre>

blocks|key|1072702|text|在OSX+Homebrew安装中，可以在以下位置找到日志：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072703|/usr/local/var/log/postgres.log+|code-block|syntax|javascript|1072704|或用于旧版本的postgres+(<+9.6)|1072705|/usr/local/var/postgres/server.log|1072706|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

On OSX Homebrew installation the log can be found at:

<pre><code>/usr/local/var/log/postgres.log 
</code></pre>

or for older version of postgres (&lt; 9.6)

<pre><code>/usr/local/var/postgres/server.log
</code></pre>

blocks|key|1287579|text|Postgresapp+9.3.5.1及更高版本会保留服务器日志。日志位于名为postgres-server.log的数据目录中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1287580|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Postgresapp 9.3.5.1 and later keep a server log. The log is inside the data directory, named postgres-server.log.

blocks|key|1072804|text|如果您使用的是Postgres.app，则可以在首选项对话框中找到数据目录位置。在该目录中，日志位于postgres-server.log。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1072805|例如，在我的机器上，日志是/Users/nofinator/Library/Application+Support/Postgres/var-9.4/postgres-server.log。|1072806|entityMap|0|LINK|mutability|MUTABLE|url|http://postgresapp.com/^0|1E|J|7|C|0|0|D|29|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

If you are using <a href="http://postgresapp.com/" rel="noreferrer">Postgres.app</a>, you can find the Data Directory location in the Preferences dialog box. In that directory, the log is at <code>postgres-server.log</code>.

For example, on my machine, the log is at <code>/Users/nofinator/Library/Application Support/Postgres/var-9.4/postgres-server.log</code>.

blocks|key|1072862|text|对于使用自制软件安装postgres的苹果M1(Big+Sur)用户来说，位置是-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1072863|+/opt/homebrew/var/log/postgres.log|code-block|syntax|javascript|1072864|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For Apple M1(Big Sur) users who installed postgres using homebrew the location is -
<pre><code> /opt/homebrew/var/log/postgres.log
</code></pre>

I would like to take a look at the PostgreSQL log files to see what my app writes to them but I can't find them.

Any ideas?

Where are the PostgreSQL logs on macOS?

日志文件

PostgreSQL

数据库

服务器

我想看看PostgreSQL日志文件，看看我的应用程序写了什么，但我找不到它们。有什么想法吗？

问macOS上的PostgreSQL日志在哪里？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问macOS上的PostgreSQL日志在哪里？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问macOS上的PostgreSQL日志在哪里？
EN