Forwarding to -hackers as per README

-----Пересланное сообщение-----

From: Markus Bertheau <twanger@bluetwanger.de>
To: pgsql-bugs@postgresql.org
Subject: [BUGS] pg_autovacuum segv
Date: 09 Oct 2003 17:30:48 +0200

(gdb) run
Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum 
[2003-10-09 05:28:13 PM] Failed connection to database template1 with error: FATAL:  user "root" does not exist
.

Program received signal SIGSEGV, Segmentation fault.
0x0804a132 in check_stats_enabled (dbi=0x804e2f0) at pg_autovacuum.c:739
739                     strcmp("on", PQgetvalue(res, 0, PQfnumber(res, "stats_row_level")));
(gdb) bt
#0  0x0804a132 in check_stats_enabled (dbi=0x804e2f0) at pg_autovacuum.c:739
#1  0x0804a9b3 in main (argc=1, argv=0xbfffdf64) at pg_autovacuum.c:1004
#2  0x40103657 in __libc_start_main (main=0x804a8e4 <main>, argc=1, ubp_av=0xbfffdf64, init=0x8048b30 <_init>, 
    fini=0x804afd0 <_fini>, rtld_fini=0x4000dcd4 <_dl_fini>, stack_end=0xbfffdf5c) at ../sysdeps/generic/libc-start.c:129
(gdb) 

This is on a i386 Redhat 7.2 with pg7.3.4 installed.

-- 
Markus Bertheau <twanger@bluetwanger.de>


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


10 Oct 2003 14:45:55 +0200
Markus Bertheau <twanger@bluetwanger.de>
[Fwd: [BUGS] pg_autovacuum segv]
In the last exciting episode, twanger@bluetwanger.de (Markus Bertheau) wrote:
> Forwarding to -hackers as per README
>
> -----ÐÐµÑÐµÑÐ»Ð°Ð½Ð½Ð¾Ðµ ÑÐ¾Ð¾Ð±ÑÐµÐ½Ð¸Ðµ-----
>
> From: Markus Bertheau <twanger@bluetwanger.de>
> To: pgsql-bugs@postgresql.org
> Subject: [BUGS] pg_autovacuum segv
> Date: 09 Oct 2003 17:30:48 +0200
>
> (gdb) run
> Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum 
> [2003-10-09 05:28:13 PM] Failed connection to database template1 with error: FATAL:  user "root" does not exist

It should probably have died more gracefully, but what happened here
should be clear enough.

You ran the program as root, and so it assumed that it should connect
as PostgreSQL user "root."  That user does not exist, so the
connection failed.

You'll need to specify a user, or establish "root" as a superuser.
-- 
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www3.sympatico.ca/cbbrowne/spreadsheets.html
"Bother," said Pooh as he struggled with sendmail.cf.
"It never does quite what I want."
"I wish Christopher Robin were here.". 

Fri, 10 Oct 2003 10:13:24 -0400
Christopher Browne <cbbrowne@acm.org>
Re: [Fwd: [BUGS] pg_autovacuum segv]

OK, I committed a fix so it will not segfault on root starting it.

---------------------------------------------------------------------------

Christopher Browne wrote:
> In the last exciting episode, twanger@bluetwanger.de (Markus Bertheau) wrote:
> > Forwarding to -hackers as per README
> >
> > -----?????????????????????? ??????????????????-----
> >
> > From: Markus Bertheau <twanger@bluetwanger.de>
> > To: pgsql-bugs@postgresql.org
> > Subject: [BUGS] pg_autovacuum segv
> > Date: 09 Oct 2003 17:30:48 +0200
> >
> > (gdb) run
> > Starting program: /root/src/postgresql-7.4beta4/contrib/pg_autovacuum/pg_autovacuum 
> > [2003-10-09 05:28:13 PM] Failed connection to database template1 with error: FATAL:  user "root" does not exist
> 
> It should probably have died more gracefully, but what happened here
> should be clear enough.
> 
> You ran the program as root, and so it assumed that it should connect
> as PostgreSQL user "root."  That user does not exist, so the
> connection failed.
> 
> You'll need to specify a user, or establish "root" as a superuser.
> -- 
> wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
> http://www3.sympatico.ca/cbbrowne/spreadsheets.html
> "Bother," said Pooh as he struggled with sendmail.cf.
> "It never does quite what I want."
> "I wish Christopher Robin were here.". 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Fri, 10 Oct 2003 15:26:44 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [Fwd: [BUGS] pg_autovacuum segv]