Does the same thing here. Sounds like a serious problem to me too.
Greg On Wed, 2002-03-20 at 20:46, Bruce Momjian wrote: > If I do this as any user: > > SELECT update_pg_pwd(); > > it crashes all backends and causes a server-wide restart. Is this > acceptable behavior? I am sure there are other cases too. Isn't it a > problem that we let ordinary users crash the server and cause a restart? > > --------------------------------------------------------------------------- > > LOG: server process (pid 23337) was terminated by signal 11 > LOG: terminating any other active server processes > LOG: all server processes terminated; reinitializing shared memory and semaphores > FATAL: The database system is starting up > LOG: database system was interrupted at 2002-03-21 03:42:08 CET > LOG: checkpoint record is at 0/43C048 > LOG: redo record is at 0/43C048; undo record is at 0/0; shutdown TRUE > LOG: next transaction id: 99; next oid: 24747 > LOG: database system was not properly shut down; automatic recovery in progress > LOG: redo starts at 0/43C088 > LOG: ReadRecord: record with zero length at 0/4421B4 > LOG: redo done at 0/442190 > LOG: database system is ready > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part