newbie Administrator

This is a multi-part message in MIME format.

--Boundary_(ID_jnhBnXCwNBq1T2INHUWQbQ)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT

I have recently inherited a Linux server running pgsql and need to lock
someone out but have so far been unsuccessful.

I have changed the Linux passwords

I have changed the passwords on the 3 users listed on the Database

Now the problem is the person (server) I need to block access can still
connect to the database. I have verified this by changing a record in the
database and the changes were reflected on the other server. I looked for
pg_hba.conf and there isn't one that I can find so I am wondering if it is a
persistent connection and if it is how do I kill it? Will restarting the
server drop the connection

--Boundary_(ID_jnhBnXCwNBq1T2INHUWQbQ)
Content-type: text/html; charset=us-ascii
Content-transfer-encoding: 7BIT

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal>I have recently inherited a Linux server running pgsql and
need to lock someone out but have so far been unsuccessful.<o:p></o:p></p>

<p class=MsoNormal><o:p> </o:p></p>

<p class=MsoNormal>I have changed the Linux passwords<o:p></o:p></p>

<p class=MsoNormal>I have changed the passwords on the 3 users listed on the
Database<o:p></o:p></p>

<p class=MsoNormal><o:p> </o:p></p>

<p class=MsoNormal>Now the problem is the person (server) I need to block
access can still connect to the database. I have verified this by
changing a record in the database and the changes were reflected on the other
server. I looked for pg_hba.conf and there isn’t one that I can
find so I am wondering if it is a persistent connection and if it is how do I
kill it? Will restarting the server drop the connection<o:p></o:p></p>

</div>

</body>

</html>

--Boundary_(ID_jnhBnXCwNBq1T2INHUWQbQ)--

On Thu, 2009-07-23 at 19:30 -0400, Scott Holmes wrote:
> I have recently inherited a Linux server running pgsql and need to
> lock someone out but have so far been unsuccessful.
>
>
>
> I have changed the Linux passwords
>
> I have changed the passwords on the 3 users listed on the Database
>
>
>
> Now the problem is the person (server) I need to block access can
> still connect to the database. I have verified this by changing a
> record in the database and the changes were reflected on the other
> server. I looked for pg_hba.conf and there isn=E2=80=99t one that I ca=
n find
> so I am wondering if it is a persistent connection and if it is how do
> I kill it? Will restarting the server drop the connection

Yes restarting the database will drop the connection.

I guarantee you, you have a pg_hba.conf somewhere.

Joshua D. Drake

>
--
PostgreSQL - XMPP: jdrake [at] jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

This is a multi-part message in MIME format.
--------------010200090205040603040200
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello Scott,

Hm. Having no pg_hba.conf file definitely sounds odd.

I'd try this command while logged in via psql:

SHOW hba_file;

The output should show you the path to the pg_hba.conf file, which you
can then edit to limit the connections to the database.

Hope that helps. =)

Lacey
>
> I have recently inherited a Linux server running pgsql and need to
> lock someone out but have so far been unsuccessful.
>
>
>
> I have changed the Linux passwords
>
> I have changed the passwords on the 3 users listed on the Database
>
>
>
> Now the problem is the person (server) I need to block access can
> still connect to the database. I have verified this by changing a
> record in the database and the changes were reflected on the other
> server. I looked for pg_hba.conf and there isn't one that I can find
> so I am wondering if it is a persistent connection and if it is how do
> I kill it? Will restarting the server drop the connection
>

--
Lacey Powers

The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 104
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--------------010200090205040603040200
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hello Scott, <br>
<br>
Hm. Having no pg_hba.conf file definitely sounds odd. <br>
<br>
I'd try this command while logged in via psql:<br>
<br>
SHOW hba_file;<br>
<br>
The output should show you the path to the pg_hba.conf file, which you
can then edit to limit the connections to the database.<br>
<br>
Hope that helps. =)<br>
<br>
Lacey<br>
</tt>
<blockquote
cite="mid:004b01ca0bed$8dfa3460$a9ee9d20$%25holmes [at] AMBERRead y.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>

</style>

<div class="Section1">
<p class="MsoNormal">I have recently inherited a Linux server running
pgsql and
need to lock someone out but have so far been unsuccessful.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have changed the Linux passwords<o:p></o:p></p>
<p class="MsoNormal">I have changed the passwords on the 3 users
listed on the
Database<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Now the problem is the person (server) I need to
block
access can still connect to the database. I have verified this by
changing a record in the database and the changes were reflected on the
other
server. I looked for pg_hba.conf and there isn’t one that I can
find so I am wondering if it is a persistent connection and if it is
how do I
kill it? Will restarting the server drop the connection<o:p></o:p></p>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Lacey Powers

The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 104
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
</pre>
</body>
</html>

--------------010200090205040603040200--

newbie Administrator

Re: newbie Administrator

Re: newbie Administrator