On Mon, Apr 18, 2005 at 16:55:45 -0400,
Bruce Momjian wrote:
>
> I would like to pick something that matches what a typical Unix system
> does because I think the _fancy_ solutions actually cause weird problems
> like denial-of-service attacks by just trying to log in.
>
> How do typical open
Bruce Momjian schreef:
Wim Bertels wrote:
LS,
is there a way of securing the postgresql-server against brute force
password cracking ?
iow: is there a way of setting eg a maximum number of login attempts, or
using a time-out or ..?
+ securing on server level
No, there is not. Does anyo
On Wed, Apr 13, 2005 at 04:20:40PM +0100, Lim, Terrin wrote:
> I'm trying to drop all tables in a database but I can't use DROP dbname
> as I don't have permission rights to do so. I also can't manually delete
> all the tables cause there are about 200 tables. How do i go about this?
> Thanks.
Her
Hi folks,
I configured the PAM authentication via pam_ldap.so, the authentication
works fine, but I get a lot of erros messagens in log such as:
pam_authenticate failed: Conversation error
Can anyone help me?
Thanks.
Tom Lane wrote:
Pallav Kalva <[EMAIL PROTECTED]> writes:
Postmaster is using these settings, SHOW tells me all the settings
are right as per the postgresql.conf settings. I am checking the log
rotation after restarting the postmaster, Postgres was restarted last
monday morning and it gen
On Apr 18, 2005, at 3:02 PM, Al-Amin Ali wrote:
users? (y/n)y
10. CREATE USER
11. -bash-2.05b$ createdb vsbabu
12. CREATE DATABASE
13. -bash-2.05b$ exit
14. [EMAIL PROTECTED] root]# exit
Now up to this point every thing was working fine.
But it seems that there is some commands that are not
there.
Pallav Kalva <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> What I suspect happened is that it rotated last Thursday midnight, but
>> since %U hadn't changed since Monday, it overwrote the same file it was
>> using before. Check to see what the oldest entry in the file is ...
>>
> It didnt
Tom Lane wrote:
Pallav Kalva <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
What I suspect happened is that it rotated last Thursday midnight, but
since %U hadn't changed since Monday, it overwrote the same file it was
using before. Check to see what the oldest entry in the file is ...
hi,
i'm using postgres version 7.4.1 and it run very stable until, may be,
4 weeks ago.
now the postmaster hangs sometimes for a while (actually since 2 hours)
and doesn't accept connections but comes back anytime. there is no
possibility to stop the postmaster. even a kill -9 (it's only the
d
Pallav Kalva <[EMAIL PROTECTED]> writes:
> I am sorry for the confusion, what i meant was the oldest entry on the
> log file was on last monday and most recent was this morning and the
> file didnt rotate yet.
Looking at the code, it will have decided to append not truncate because
%U hadn't cha
Rolf Staege <[EMAIL PROTECTED]> writes:
> i'm using postgres version 7.4.1 and it run very stable until, may be,
> 4 weeks ago.
> now the postmaster hangs sometimes for a while (actually since 2 hours)
> and doesn't accept connections but comes back anytime. there is no
> possibility to stop th
Can't people use PAM to get this effect if they want it?
what if u use pam with ldap, then u can use pg brute force cracking to
obtain the ldap password, which is probably a bigger problem
For most people password guessing isn't going to be a big problem as
the database won't be accessible from to
Pallav Kalva wrote:
Hi Tom,
Postmaster is using these settings, SHOW tells me all the settings
are right as per the postgresql.conf settings. I am checking the log
rotation after restarting the postmaster, Postgres was restarted last
monday morning and it generated a new log file postgresql
Geoffrey wrote:
Pallav Kalva wrote:
Hi Tom,
Postmaster is using these settings, SHOW tells me all the
settings are right as per the postgresql.conf settings. I am checking
the log rotation after restarting the postmaster, Postgres was
restarted last monday morning and it generated a new log
On Tue, 2005-04-19 at 09:38, Rolf Staege wrote:
> hi,
> i'm using postgres version 7.4.1 and it run very stable until, may be,
> 4 weeks ago.
> now the postmaster hangs sometimes for a while (actually since 2 hours)
> and doesn't accept connections but comes back anytime. there is no
> possibil
Hi all.
I'm running 7.4, and I recently did a few upgrades, which seem to have
broken it. I believe that all of them were php updates.
Anywho, my service configuration shows that postmaster is
stopped. I can't find an instance of it in my system monitor.
Can you help me to figure out if its
As I see it you have two choices... hack postgresql directly to add in
emailing functionality to the elog mechanisms in postgresql or write
some type of script/daemon to parse the postgresql logs to look for
error messages. A fairly simple script set up to run continuously or via
cron could handle
On Tue, Apr 19, 2005 at 17:00:15 +0200,
Wim Bertels <[EMAIL PROTECTED]> wrote:
> >Can't people use PAM to get this effect if they want it?
>
> what if u use pam with ldap, then u can use pg brute force cracking to
> obtain the ldap password, which is probably a bigger problem
You don't have to
Hi all,
Does any one know why I have following inconsistant results from PostgreSQL?
Thanks in advance.
test=# select birthday from patient;
birthday
1960-02-01
1960-02-01
(2 rows)
test=# select used from patient;
used
--
N
N
(2 rows)
test=# select first_name, last_na
On Tue, Apr 19, 2005 at 01:27:09PM -0700, [EMAIL PROTECTED] wrote:
> test=# select used from patient;
> used
> --
> N
> N
> (2 rows)
Try
select '{' || used || '}' from patient;
> test=# select first_name, last_name, used, birthday from patient;
> first_name | last_name | used | birthd
It looks like you have some non-printing characters (like ansi
positioning characters or something) in your data.
On Tue, 2005-04-19 at 15:27, [EMAIL PROTECTED] wrote:
> Hi all,
> Does any one know why I have following inconsistant results from
> PostgreSQL?
> Thanks in advance.
>
> test=# selec
On Tuesday 19 April 2005 22:37, Bruno Wolff III seinde rooksignalen:
> On Tue, Apr 19, 2005 at 17:00:15 +0200,
>
> Wim Bertels <[EMAIL PROTECTED]> wrote:
> > >Can't people use PAM to get this effect if they want it?
> >
> > what if u use pam with ldap, then u can use pg brute force cracking to
>
On Tue, Apr 19, 2005 at 01:27:09PM -0700, [EMAIL PROTECTED] wrote:
>
> test=# select first_name, last_name, used, birthday from patient;
> first_name | last_name | used | birthday
> +---+--+
>| 1960-02-01DI | N
>| 1960-02-01DI | N
> (2 rows
On Tuesday 19 April 2005 1:46 pm, Alvaro Herrera wrote:
> Looks like you have some non-printable character in the used
> column.
I concur. Alternately you can (assuming you're running *nix which
probably has xxd and more) try this to see exactly what is in the
data:
psql -c "select * from patie
Hi all,
Does any one know why I have following inconsistant results from PostgreSQL under Cygwin?
When I switch the select order, or use "select * from patient", some values are missing from returned results.
What might be wrong?
Thanks in advance.
test=# select first_name, last_name, used,
Thanks Alvaro, you are right. Appreciate your quick help.
Jason
Alvaro Herrera <[EMAIL PROTECTED]>
04/19/2005 01:46 PM
To: Zuoxin Wang/CA/[EMAIL PROTECTED]
cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN]
On Tue, Apr 19, 2005 at
26 matches
Mail list logo
