[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] Strange behaviour with Xfs filesystem and unix_socket_directory
From: Denis Gasparin <denis () edistar ! com>
Date: 2007-07-24 16:09:59
Message-ID: 46A62457.6010503 () edistar ! com
[Download RAW message or body]
Setting PGHOST solved the problem!
It was not clear to me that pg_ctl is actually a client and it doesn't
read the configuration from postgresql.conf
Thank you,
Denis
Tom Lane ha scritto:
> Denis Gasparin <denis@edistar.com> writes:
>
>> We configured the unix_socket_directory in postgresql.conf to point to a
>> folder in a xfs filesystem.
>>
>
> I don't think pg_ctl can deal with nondefault settings of
> unix_socket_directory, because it does not make any attempt to parse the
> postmaster's postgresql.conf file. So it's still trying to contact the
> postmaster in /tmp, and of course not seeing any evidence the postmaster
> is up.
>
> You'll find that most other clients fail similarly.
>
> You might be able to make it work if you set PGHOST to the socket
> directory before running pg_ctl (and other clients). But I think
> if you really want this, you would be best advised to alter the default
> socket directory at build time, instead (see DEFAULT_PGSOCKET_DIR in
> pg_config_manual.h).
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
[Attachment #3 (text/html)]
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Setting PGHOST solved the problem!<br>
<br>
It was not clear to me that pg_ctl is actually a client and it doesn't
read the configuration from postgresql.conf<br>
<br>
Thank you,<br>
Denis<br>
<br>
Tom Lane ha scritto:
<blockquote cite="mid:9419.1185288138@sss.pgh.pa.us" type="cite">
<pre wrap="">Denis Gasparin <a class="moz-txt-link-rfc2396E" \
href="mailto:denis@edistar.com"><denis@edistar.com></a> writes: </pre>
<blockquote type="cite">
<pre wrap="">We configured the unix_socket_directory in postgresql.conf to point \
to a folder in a xfs filesystem.
</pre>
</blockquote>
<pre wrap=""><!---->
I don't think pg_ctl can deal with nondefault settings of
unix_socket_directory, because it does not make any attempt to parse the
postmaster's postgresql.conf file. So it's still trying to contact the
postmaster in /tmp, and of course not seeing any evidence the postmaster
is up.
You'll find that most other clients fail similarly.
You might be able to make it work if you set PGHOST to the socket
directory before running pg_ctl (and other clients). But I think
if you really want this, you would be best advised to alter the default
socket directory at build time, instead (see DEFAULT_PGSOCKET_DIR in
pg_config_manual.h).
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to <a class="moz-txt-link-abbreviated" \
href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a> so that your \
message can get through to the mailing list cleanly
</pre>
</blockquote>
<br>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic