<html style="direction: rtl;">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
bgcolor="#FFFFFF" text="#000066">
<font face="David CLM"><big>Hi everyone,<br>
<br>
First of all it's appears that there was something wrong with my
Upstart conf file (Ubuntu is using Upstart instead of SysV init.
Next year they'll also move to Systemd). Jay and Raghu: That
solved my connection problem and /var/run problem.<br>
So now pg is up (according to ps -aux |grep post). However <font
face="monospace">pg_ctl status</font> says no server is
running. What's wrong? <br>
<br>
About the logs: I have pg_xlog and pg_clog under PFDATA -
nothing there.<br>
<br>
Remote connection: When I try to connect to the server I get an
error that my user is not present at pg_hba.conf. However, I see
that I have 2 such files: One in PGDATA and one in
/etc/postgresql/9.3/main/. What's the difference between them?<br>
<br>
Thanks<br>
</big><br>
<br>
</font>
<div style="direction: ltr;" class="moz-cite-prefix">On 10/18/2014
03:48 AM, <a class="moz-txt-link-abbreviated" href="mailto:jayknowsunix(at)gmail(dot)com">jayknowsunix(at)gmail(dot)com</a> wrote:<br>
</div>
<blockquote style="direction: ltr;"
cite="mid:638CECFF-7F53-4BEC-A58E-8939079192E7(at)gmail(dot)com"
type="cite">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div style="direction: ltr;">Hi Shay,</div>
<div style="direction: ltr;"><br>
</div>
<div style="direction: ltr;">Per your questions:</div>
<div style="direction: ltr;">1) from my experience, /var/run is
only used to write a PID file, but this file is usually only
created by your system's service commands. I don't use Ubuntu,
only CentOS, so my command is "service postgresql-9.3 [start |
stop | status| ... ] and the script writes the PID file. The
CentOS script also writes out a /var/subsys/lock file for
postgresql.</div>
<div style="direction: ltr;">2) your logfiles, unless you've
butchered the postgresql.conf file, live in the $PGDATA/pg_log
directory. Wherever that is on your system.<br>
3) i probably can't help much here, but first if you're running
selinux, I'd probably turn that off first. Next, check if
iptables is running and possibly blocking your response. Either
turn that off or add a rule to permit this port.</div>
<div style="direction: ltr;"><br>
</div>
<div style="direction: ltr;">Hope this helps,</div>
<div style="direction: ltr;">Jay</div>
<div style="direction: ltr;"><br>
Sent from my iPad</div>
<div style="direction: ltr;"><br>
On Oct 17, 2014, at 6:12 PM, Shay Gover <<a
moz-do-not-send="true" href="mailto:shay(at)kapotamar(dot)com">shay(at)kapotamar(dot)com</a>>
wrote:<br>
<br>
</div>
<blockquote style="direction: ltr;" type="cite">
<div style="direction: ltr;">
<meta http-equiv="content-type" content="text/html;
charset=utf-8">
<font face="David CLM">Hello everybody,<br>
<br>
I've just installed PostgreSQL and I'm unable to connect to
it remotely from my main desktop (I'm trying to connect with
pgAdmin 3).<br>
<br>
My setup:<br>
Ubuntu Server 14.04 x64 (Azure Cloud)<br>
PostgreSQL v9.3.5-0ubuntu0.14.04.1<br>
contrib package is also installed.<br>
PostgreSQL is started on boot using Upstart. I've modified
this script: <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="https://gist.github.com/haad/6020401">https://gist.github.com/haad/6020401</a>
(just version numbers)<br>
<br>
My Problems:<br>
1) For some reason, when I've installed pg,
/var/run/postgresql was missing. I've manually created this
folder and gave my pg user write permissions. Is that a bug?<br>
2) I've tried to change the log config in
/etc/postgresql/9.3/main/postgresql.conf but it won't work.
I think that pg is ignoring that file. I also have no idea
where is pg log file (I tried /var/log/postgresql - not
there). I tried starting the DB manually with pg_ctl -l but
the log does say much:<br>
LOG: database system is ready to accept connections<br>
LOG: autovacuum launcher started<br>
LOG: received SIGHUP, reloading configuration files<br>
LOG: received smart shutdown request<br>
LOG: autovacuum launcher shutting down<br>
LOG: shutting down<br>
LOG: database system is shut down<br>
LOG: database system was shut down at 2014-10-17
21:22:11 UTC<br>
LOG: database system is ready to accept connections<br>
LOG: autovacuum launcher started<br>
This log contains a single DB run.<br>
3) I'm unable to connect from my main desktop. Server is
listening according to netstat. There is no firewall on the
server and I've created an Azure endpoint for port 5432.
Ideas?<br>
<br>
Can you help me? <br>
<br>
Thanks,<br>
<br>
</font>
<div style="direction: ltr;" class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html;
charset=utf-8">
<title></title>
<meta name="generator" content="LibreOffice 4.3.0.4
(Windows)">
<meta name="created" content="00:00:00">
<meta name="changed" content="2014-08-23T05:53:57.511000000">
<style type="text/css">
p { direction: inherit; color: #000066 }
</style>
<p style="direction: ltr;"><font face="Liberation Serif,
serif"><span lang="en-US"><font face="Times New Roman"><font
style="font-size: 14pt" size="4">Shay Gover<br>
IT Consultant<br>
<a moz-do-not-send="true"
href="www.kapot-tamar.com">Kapot Tamar</a> </font></font></span></font>
</p>
</div>
</div>
</blockquote>
</blockquote>
<br>
<div style="direction: ltr;" class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title></title>
<meta name="generator" content="LibreOffice 4.3.0.4 (Windows)">
<meta name="created" content="00:00:00">
<meta name="changed" content="2014-08-23T05:53:57.511000000">
<style type="text/css">
p { direction: inherit; color: #000066 }
</style>
<p><font face="Liberation Serif, serif"><span lang="en-US"><font
face="Times New Roman"><font style="font-size: 14pt"
size="4">Shay
Gover<br>
IT Consultant<br>
<a href="www.kapot-tamar.com">Kapot Tamar</a>
</font></font></span></font>
</p>
</div>
</body>
</html>