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|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|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|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|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>

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|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|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.

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

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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