pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUnable to connect remotely
6+ messages / 3 participants
[nested] [flat]
* Unable to connect remotely
@ 2014-10-17 22:12 Shay Gover <shay@kapotamar.com>
0 siblings, 2 replies; 6+ messages in thread
From: Shay Gover @ 2014-10-17 22:12 UTC (permalink / raw)
To: pgsql-admin
<html style="direction: ltr;">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<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">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 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 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>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to connect remotely
@ 2014-10-18 02:23 Raghu Ram <raghuchennuru@gmail.com>
parent: Shay Gover <shay@kapotamar.com>
1 sibling, 0 replies; 6+ messages in thread
From: Raghu Ram @ 2014-10-18 02:23 UTC (permalink / raw)
To: Shay Gover <shay@kapotamar.com>; +Cc: pgsql-admin
On Sat, Oct 18, 2014 at 3:42 AM, Shay Gover <shay@kapotamar.com> wrote:
> Hello everybody,
>
> 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).
>
> My setup:
> Ubuntu Server 14.04 x64 (Azure Cloud)
> PostgreSQL v9.3.5-0ubuntu0.14.04.1
> contrib package is also installed.
>
> 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?
>
>
Could you please share ERROR message,when you are connecting the database
server from Client ?
Thanks & Regards
Raghu Ram
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to connect remotely
@ 2014-10-18 18:06 Shay Gover <shay@kapotamar.com>
parent: Shay Gover <shay@kapotamar.com>
1 sibling, 1 reply; 6+ messages in thread
From: Shay Gover @ 2014-10-18 18:06 UTC (permalink / raw)
To: pgsql-admin
<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@gmail.com">jayknowsunix@gmail.com</a> wrote:<br>
</div>
<blockquote style="direction: ltr;"
cite="mid:638CECFF-7F53-4BEC-A58E-8939079192E7@gmail.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@kapotamar.com">shay@kapotamar.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>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to connect remotely
@ 2014-10-18 19:05 jayknowsunix@gmail.com
parent: Shay Gover <shay@kapotamar.com>
0 siblings, 1 reply; 6+ messages in thread
From: jayknowsunix@gmail.com @ 2014-10-18 19:05 UTC (permalink / raw)
To: Shay Gover <shay@kapotamar.com>; +Cc: pgsql-admin
Sounds maybe like a botched installation. The only pg_hba.conf that should be present is the one in $PGDATA. Also, depending on your configuration and how long it's been running, you may not have anything the pg_xlog directory other than a subdirectory. I think, if I'm recalling correctly, that the subdirectory is named archive. WAL segments get written out here based on the setting for wal_keep_segments in the postgresql.conf file.
Not really certain when pg_clogs get written out,
--
Jay
Sent from my iPad
> On Oct 18, 2014, at 2:06 PM, Shay Gover <shay@kapotamar.com> wrote:
>
> Hi everyone,
>
> 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.
> So now pg is up (according to ps -aux |grep post). However pg_ctl status says no server is running. What's wrong?
>
> About the logs: I have pg_xlog and pg_clog under PFDATA - nothing there.
>
> 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?
>
> Thanks
>
>
>> On 10/18/2014 03:48 AM, jayknowsunix@gmail.com wrote:
>> Hi Shay,
>>
>> Per your questions:
>> 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.
>> 2) your logfiles, unless you've butchered the postgresql.conf file, live in the $PGDATA/pg_log directory. Wherever that is on your system.
>> 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.
>>
>> Hope this helps,
>> Jay
>>
>> Sent from my iPad
>>
>> On Oct 17, 2014, at 6:12 PM, Shay Gover <shay@kapotamar.com> wrote:
>>
>>> Hello everybody,
>>>
>>> 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).
>>>
>>> My setup:
>>> Ubuntu Server 14.04 x64 (Azure Cloud)
>>> PostgreSQL v9.3.5-0ubuntu0.14.04.1
>>> contrib package is also installed.
>>> PostgreSQL is started on boot using Upstart. I've modified this script: https://gist.github.com/haad/6020401 (just version numbers)
>>>
>>> My Problems:
>>> 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?
>>> 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:
>>> LOG: database system is ready to accept connections
>>> LOG: autovacuum launcher started
>>> LOG: received SIGHUP, reloading configuration files
>>> LOG: received smart shutdown request
>>> LOG: autovacuum launcher shutting down
>>> LOG: shutting down
>>> LOG: database system is shut down
>>> LOG: database system was shut down at 2014-10-17 21:22:11 UTC
>>> LOG: database system is ready to accept connections
>>> LOG: autovacuum launcher started
>>> This log contains a single DB run.
>>> 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?
>>>
>>> Can you help me?
>>>
>>> Thanks,
>>>
>>> --
>>> Shay Gover
>>> IT Consultant
>>> Kapot Tamar
>
> --
> Shay Gover
> IT Consultant
> Kapot Tamar
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to connect remotely
@ 2014-10-18 19:10 Shay Gover <shay@kapotamar.com>
parent: jayknowsunix@gmail.com
0 siblings, 1 reply; 6+ messages in thread
From: Shay Gover @ 2014-10-18 19:10 UTC (permalink / raw)
To: pgsql-admin
<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">I've used Ubuntu Repositories to be on the
safe side. If this is really the source of the problem I'll build
from source.</font><br>
<div style="direction: ltr;" class="moz-cite-prefix">On 10/18/2014
10:05 PM, <a class="moz-txt-link-abbreviated" href="mailto:jayknowsunix@gmail.com">jayknowsunix@gmail.com</a> wrote:<br>
</div>
<blockquote style="direction: ltr;"
cite="mid:6C164257-D38C-461E-AE0B-108BCC090297@gmail.com"
type="cite">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div style="direction: ltr;">Sounds maybe like a botched
installation. The only pg_hba.conf that should be present is the
one in $PGDATA. Also, depending on your configuration and how
long it's been running, you may not have anything the pg_xlog
directory other than a subdirectory. I think, if I'm recalling
correctly, that the subdirectory is named archive. WAL segments
get written out here based on the setting for wal_keep_segments
in the postgresql.conf file.</div>
<div style="direction: ltr;"><br>
</div>
<div style="direction: ltr;">Not really certain when pg_clogs get
written out,</div>
<div style="direction: ltr;">--</div>
<div style="direction: ltr;">Jay<br>
<br>
Sent from my iPad</div>
<div style="direction: ltr;"><br>
On Oct 18, 2014, at 2:06 PM, Shay Gover <<a
moz-do-not-send="true" href="mailto:shay@kapotamar.com">shay@kapotamar.com</a>>
wrote:<br>
<br>
</div>
<blockquote style="direction: ltr;" type="cite">
<div style="direction: ltr;">
<meta content="text/html; charset=utf-8"
http-equiv="Content-Type">
<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 moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:jayknowsunix@gmail.com">jayknowsunix@gmail.com</a>
wrote:<br>
</div>
<blockquote style="direction: ltr;"
cite="mid:638CECFF-7F53-4BEC-A58E-8939079192E7@gmail.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@kapotamar.com">shay@kapotamar.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">
<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 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>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable to connect remotely
@ 2014-10-18 20:28 jayknowsunix@gmail.com
parent: Shay Gover <shay@kapotamar.com>
0 siblings, 0 replies; 6+ messages in thread
From: jayknowsunix@gmail.com @ 2014-10-18 20:28 UTC (permalink / raw)
To: Shay Gover <shay@kapotamar.com>; +Cc: pgsql-admin
Be advised, at least my experience, that many linux builds require certain "undocumented" configuration options. At least some of them are hard to find, and configure --help doesn't always show them. Without those, things do get put in different locations than where the rpm's do. Also, make sure you remove the current rpms. You might just want to do the remove, and reinstall the binaries anyway at first.
Sent from my iPad
> On Oct 18, 2014, at 3:10 PM, Shay Gover <shay@kapotamar.com> wrote:
>
> I've used Ubuntu Repositories to be on the safe side. If this is really the source of the problem I'll build from source.
>> On 10/18/2014 10:05 PM, jayknowsunix@gmail.com wrote:
>> Sounds maybe like a botched installation. The only pg_hba.conf that should be present is the one in $PGDATA. Also, depending on your configuration and how long it's been running, you may not have anything the pg_xlog directory other than a subdirectory. I think, if I'm recalling correctly, that the subdirectory is named archive. WAL segments get written out here based on the setting for wal_keep_segments in the postgresql.conf file.
>>
>> Not really certain when pg_clogs get written out,
>> --
>> Jay
>>
>> Sent from my iPad
>>
>> On Oct 18, 2014, at 2:06 PM, Shay Gover <shay@kapotamar.com> wrote:
>>
>>> Hi everyone,
>>>
>>> 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.
>>> So now pg is up (according to ps -aux |grep post). However pg_ctl status says no server is running. What's wrong?
>>>
>>> About the logs: I have pg_xlog and pg_clog under PFDATA - nothing there.
>>>
>>> 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?
>>>
>>> Thanks
>>>
>>>
>>>> On 10/18/2014 03:48 AM, jayknowsunix@gmail.com wrote:
>>>> Hi Shay,
>>>>
>>>> Per your questions:
>>>> 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.
>>>> 2) your logfiles, unless you've butchered the postgresql.conf file, live in the $PGDATA/pg_log directory. Wherever that is on your system.
>>>> 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.
>>>>
>>>> Hope this helps,
>>>> Jay
>>>>
>>>> Sent from my iPad
>>>>
>>>> On Oct 17, 2014, at 6:12 PM, Shay Gover <shay@kapotamar.com> wrote:
>>>>
>>>>> Hello everybody,
>>>>>
>>>>> 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).
>>>>>
>>>>> My setup:
>>>>> Ubuntu Server 14.04 x64 (Azure Cloud)
>>>>> PostgreSQL v9.3.5-0ubuntu0.14.04.1
>>>>> contrib package is also installed.
>>>>> PostgreSQL is started on boot using Upstart. I've modified this script: https://gist.github.com/haad/6020401 (just version numbers)
>>>>>
>>>>> My Problems:
>>>>> 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?
>>>>> 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:
>>>>> LOG: database system is ready to accept connections
>>>>> LOG: autovacuum launcher started
>>>>> LOG: received SIGHUP, reloading configuration files
>>>>> LOG: received smart shutdown request
>>>>> LOG: autovacuum launcher shutting down
>>>>> LOG: shutting down
>>>>> LOG: database system is shut down
>>>>> LOG: database system was shut down at 2014-10-17 21:22:11 UTC
>>>>> LOG: database system is ready to accept connections
>>>>> LOG: autovacuum launcher started
>>>>> This log contains a single DB run.
>>>>> 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?
>>>>>
>>>>> Can you help me?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> --
>>>>> Shay Gover
>>>>> IT Consultant
>>>>> Kapot Tamar
>>>
>>> --
>>> Shay Gover
>>> IT Consultant
>>> Kapot Tamar
>
> --
> Shay Gover
> IT Consultant
> Kapot Tamar
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2014-10-18 20:28 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-10-17 22:12 Unable to connect remotely Shay Gover <shay@kapotamar.com>
2014-10-18 02:23 ` Raghu Ram <raghuchennuru@gmail.com>
2014-10-18 18:06 ` Shay Gover <shay@kapotamar.com>
2014-10-18 19:05 ` jayknowsunix@gmail.com
2014-10-18 19:10 ` Shay Gover <shay@kapotamar.com>
2014-10-18 20:28 ` jayknowsunix@gmail.com
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox