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
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,
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
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 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
>
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 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
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 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
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
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
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
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
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
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
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
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
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
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 ...
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
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.
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
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.
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
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 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
26 matches
Mail list logo
