Undeliverable Message - Mailing list pgsql-general
From | |
---|---|
Subject | Undeliverable Message |
Date | |
Msg-id | vines.n4,8+ybLVrA@SFRA0046. Whole thread Raw |
List | pgsql-general |
To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>] Cc: Subject: pgsql-general-digest V1 #381 Message not delivered to recipients below. Press F1 for help with VNM error codes. VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST VNM3043 -- MAILBOX IS FULL The message cannot be delivered because the recipient's mailbox contains the maximum number of messages, as set by the system administrator. The recipient must delete some messages before any other messages can be delivered. The maximum message limit for a user's mailbox is 10,000. The default message limit is 1000 messages. Administrators can set message limits using the Mailbox Settings function available in the Manage User menu (MUSER). When a user's mailbox reaches the limit, the user must delete some of the messages before the mailbox can accept any more incoming messages. ---------------------- Original Message Follows ---------------------- pgsql-general-digest Thursday, July 8 1999 Volume 01 : Number 381 Index: Re: [HACKERS] RE: [GENERAL] Transaction logging unsubscribe Does Apache has PostgreSQL module? Re: [GENERAL] Does Apache has PostgreSQL module? User priveledges just little BUG marino.lionello@bluewin.ch Re: [GENERAL] Problems with inequalities on numeric fields in 6.5 [none] ---------------------------------------------------------------------- Date: Wed, 7 Jul 1999 23:25:24 -0400 (EDT) From: Bruce Momjian <maillist@candle.pha.pa.us> Subject: Re: [HACKERS] RE: [GENERAL] Transaction logging Updated TODO: * Transaction log, so re-do log can be on a separate disk by with after-row images > > Added to TODO: > > > > * Transaction log, so re-do log can be on a separate disk by > > logging SQL queries, or before/after row images > > > I would drop the "log SQL queries idea". > No need to log before row images eighter, since this is the > current state of the row during rollforward. > (For asserts a checksum of the before image would be sufficient, > but IMHO not necessary.) > > I suggest: > * Transaction log that stores after row (or even only column) > images, > which can be put on a separate disk to allow rollforward after > a restore of a server. > > The "restore of a server" is a main problem here, but I suggest the > following > additional backup tool, that could be used for a "restore of a server" > which could then be used for a rollforward and would also be a lot faster > than a pg_dump: > > 1. place a vacuum lock on db (we don't want vacuum during backup) > 2. backup pg_log using direct file access (something like dd bs2k) > 3. backup the rest in any order (same as pg_log) > 4. release vacuum lock > > If this was restored, this should lead to a consistent database, > that has all transactions after the start of backup rolled back. > > Is there a nono in this idea? I feel it should work. > A problem is probably, that the first to touch a row with a committed update > stores this info in that row. There would probably need to be an undo for > this > after restore of the physical files. > > Andreas > > > - -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ------------------------------ Date: Thu, 08 Jul 1999 07:49:59 +0200 From: Leszek Rychlewski <leszek@bioinfobank.com> Subject: unsubscribe unsubscribe ------------------------------ Date: Thu, 08 Jul 1999 01:18:44 PDT From: Albert Chen <chen6178@hotmail.com> Subject: Does Apache has PostgreSQL module? Hi, I know there is a ApacheMysql module. Has ApachePostgres module? - -Albert ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com ------------------------------ Date: Thu, 8 Jul 1999 13:07:12 +0400 (MSD) From: Oleg Broytmann <phd@emerald.netskate.ru> Subject: Re: [GENERAL] Does Apache has PostgreSQL module? On Thu, 8 Jul 1999, Albert Chen wrote: > I know there is a ApacheMysql module. Has ApachePostgres module? Do you mean postgres authentication module? It is called mod_auth_pgsql, and you can hunt for this on http://modules.apache.org. Works pretty fine for me. > -Albert Oleg. - ---- Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net Programmers don't die, they just GOSUB without RETURN. ------------------------------ Date: Thu, 08 Jul 1999 09:21:12 -0500 From: Bob Kruger <bkruger@mindspring.com> Subject: User priveledges I have what may be a fairly simple question for the group, but for the life of me I missed it in the documentation. In writing some perl cgi scripts for postgres, I found that I would get an error message if a user without certain priveledges tried to do a select, insert, delete or whatever. What I would like to do is a quick scan prior to executing a perl script that would look at the user and see if they have the priveledge for the action they are about to attempt. An example would be that prior to a screen coming up that handles deletions, a query is made to see if the user even has this priveledge and the result is somehow captured so that they can either go on to a subroutine generating a HTML screen for deletion or a subroutine informing them they do not have the correct priveledge status, etc.... Any hints? Regards - Bob Kruger ------------------------------ Date: Thu, 8 Jul 1999 17:16:10 +0200 From: "Jonathan davis" <haj@idianet.net> Subject: just little BUG hello all normaly a UNIQUE PRIMARY KEY is unique but when you use a heritage, you can insert a duplicate key !!!! ------------------------------ Date: Thu, 08 Jul 1999 17:25:13 +0200 From: Marino Lionello <marino.lionello@bluewin.ch> Subject: marino.lionello@bluewin.ch unsubscribe ------------------------------ Date: Thu, 08 Jul 1999 11:44:32 -0300 From: Martin Weinberg <weinberg@osprey.phast.umass.edu> Subject: Re: [GENERAL] Problems with inequalities on numeric fields in 6.5 Bruce Momjian wrote on Wed, 07 Jul 1999 12:29:13 EDT >> Thanks, Bruce! >> >> Yes, I tried the latter query and it's the same: >> >> -------------------------------------------------- >> >> lmc>:float4; >> NOTICE: QUERY PLAN: >> >> Aggregate (costb349.97 rowsx8100 width >> -> Index Scan using j on lmctot (costb349.97 rowsx8100 width >> >> EXPLAIN >> >> -------------------------------------------------- >> I've tried all permutations of the conversions in the ranges with >> similar results (and vacuum analyzed several times as well as >> dumped and reloaded and reloaded from scracth). We have >> a larger database with 20M rows which has a similar behavior. >> >> There are 7092894 rows in database "lmc". So: >> >> (3.5-3.4)/(99.999-2.731) >> >> A clue? > >I have just fixed a problem with index size estimates. Try adding >#include <math.h> to the top of backend/optimizer/util/plancat.c. That >may fix the estimated number of tuples returned. However, it don't >think you are going to get better performance, since you are already >using the index in the above case. The only big win I can think of is >to use CLUSTER on that field. That should speed things up quite a bit. > Hi Bruce, Ok. Sorry about the delay. I added the math.h but that doesn't seem to change the query plan output. I then dropped all the indices, made a new one on three of the variables and clustered: create index m_col on lmctot using btree (j_m, h_m, k_m); cluster m_col on lmctot; vacuum analyze; where the j_m, h_m, k_m are three float4 fields. The cluster took about 18 hours on my 7.1 million records (this is a dual 450Mhz Xeon Linux box). Not sure why this was so slow. Anyway, this *hugely* improved queries of form: select count(*) from lmctot where j_m>3.4::float4 and j_m<3.5: although the explain query plan output is identical. However using h_m or k_m (not the first variable in the index) appears to be doing a sequential scan. Is that right? I then made indices on h_m and k_m, vacuum analyzed and tried again, but got identical performance. If this is the way it is, so be it, but I have the feeling that something is not working properly. Any ideas? Again, with _heaps_ of thanks, - --Martin Martin Weinberg Phone: (413) 545-3821 Dept. of Physics and Astronomy FAX: (413) 545-2117/0648 530 Graduate Research Tower University of Massachusetts Amherst, MA 01003-4525 ------------------------------ Date: Thu, 8 Jul 1999 16:13:54 -0500 (COT) From: "Moises Rincon D'Hoyos" <moi-rinc@demy.uniandes.edu.co> Subject: [none] subscribe end ------------------------------ End of pgsql-general-digest V1 #381 ***********************************
pgsql-general by date: