Re: [GENERAL] [OT] Tom's/Marc's spam filters?
Nigel J. Andrews [EMAIL PROTECTED] writes: Doesn't that just force the delivering system to send the spam through your secondary server? A 500-series error isn't supposed to be retried is it? But in any case, I run the same filters on my secondary server. Both the IP and the HELO checks would be quite useless if I used an MX that wouldn't support 'em. regards, tom lane ---(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
Re: [GENERAL] [OT] Tom's/Marc's spam filters?
On Mon, 19 Apr 2004, Joe Conway wrote: Marc G. Fournier wrote: Huh? I just use Spamassassin myself, with Razor/Pyzor/DCC and Bayes all enabled ... I use exactly the same setup. But recently I've noticed that the spammers are getting smarter -- I think 20% of it is slipping by the filters. I'm going to need something better. do you force learn those spam that get through the cracks? I get about 20 or 30 messages that slip through the cracks, which I process through with sa-learn nightly ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] cursor questions
Hi, Im not sure if this is right place to ask this question, but here goes. I have have declared a cursor with an query within a transaction. I need to get the current position of the cursor and also the number of rows it represents. Is there any way to do this? I was thinking i could do SELECT count(cursor_column) FROM cursor_name, but i get a relation does not exist error. thanks. -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Filesystem vs. Postgres for images
On Tue, 13 Apr 2004 12:56:09 +0200, Holger Klawitter wrote: Oh please. Reiser is as unstable as postgres is slow - in other words, both have to suffer prejudice which used to be true lng ago. ;-) True. In cases of large directories ext2/3 perform extremely bad (as in the original post) So this guy will be better off with anything but ext2/3. Oh please. - umount /dev/xxx - tune2fs -O dir_index dev/xxx - fsck -f -D /dev/hdxx - mount /dev/xxx That's why I switched from ext2 to reiser ~2 years ago (without any problems since). Time marches on. :-) Holger ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] plpgsql: cannot connect to SPI manager
Title: Message I'm getting this when i do an insert. I have a 'c' trigger doing an SPI_connect. If i remove this it goes away, but i don't think it's my trigger generating it. The table has a lot of foreign key constraints. Could be postgres is generating code to do this. Is there a way around this or a way track this down. Alan
Re: [GENERAL] [OT] Tom's/Marc's spam filters?
Karel Zak wrote: It must be pretty difficult maintain these header and body patterns and the others lists. I had same problem and I resolve if by spamassassin, it knows learn and it's more simple than procmailrc coding. Now I have cca 5% of all spams in my INBOX. It's not that difficult here but I'm using Postfix, which has built in pattern checking. Because my mail server also hosts a bunch of topical internet mailing lists (mainly motorcycle and bass player stuff) and all of their admin addresses were harvested by spammers long ago, I don't just get one copy of spam. I usually get several because each of those admin addresses eventually alias back to me. I don't use SpamAssassin or Razor but I manage to kill 95% of spam at the SMTP stage, before the message is accepted for delivery. This works better than a delivery stage mail processor like procmail because it bounces the spam back to the server actually sending it. It's easy to see from the maillogs what IPs are regularly sending me this crap so they can be blackholed permanently. I think I've got most of CHINANET in the bit bucket now g. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] Vb databound
I am experiencing a problem when I run my visual basic database program on windows 2000. The error message states activex components can not create an object, I have installed mdac_typ 2.8 and reinstalled visual studio 2000 on my computer, but I still get he smae error message when I run the project. has anyone experienced a similar problem and have found a solution? Will appreciate if I can hear from you. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] convert result to uppercase
Hi! How do i convert a result to upper/lowercase? I'ld like to do the following: SELECT UPPER(lang) from languages; and get for example uk as UK, dk AS DK and so on Sincerely Victor ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] Postgresql system requirements to support large databases.
We are looking at implementing a large Postgresql database (50GB - 100GB) and are wondering if there are any limitations or problems for a database of this size running on 32-bit architecture. I have seen some older posts where it appears that Postgresql seemed to have performance problems when the database reached 5GB, and it was recommended that 64-bit architecture be used. Is this still true with Postgresql version 7.4? This will be out first experience with Postgresql and we are needing to get some ideas of what system requirements a database of this size will require. Since the machines that we have are all 32-bit, we would like to know if we will need to go to 64-bit. Any comments or suggestions?? Thanks in advance for any help. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] Basix for Data General / Basix for Sco Unix
I have a Data General server with Basix Program and i would like change for the Sco Unix server. I would like use my Basix Program on Sco Unix, but i can't find the program for run Basix on Sco Unix (or Linux, or any Unix). Thank you for help!. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] [OT] Tom's/Marc's spam filters?
On Tue, Apr 20, 2004 at 05:35:51AM - I heard the voice of Jim Wilson, and lo! it spake thus: Tom Lane said: 3. I have noticed that bouncing any machine that sends HELO sss.pgh.pa.us gets rid of a ton of spam and viruses. I don't know of any real clean way to do this, but I have a sendmail.cf hack for it. #3 looks interesting though... I've been blocking HELO as anything under my domain, as well as my IP address (as well as any bare IP addresses) for a while, and it certainly drops a fair bit. And I maintain a long list of HELO names, AND IP ranges, AND sending hostnames, AND senders domains, plus all the filtering I do after accepting the mail... Wacky. If we just renamed 'spam' to 'justifiable homicide'... -- Matthew Fuller (MF4839) | [EMAIL PROTECTED] Systems/Network Administrator | http://www.over-yonder.net/~fullermd/ The only reason I'm burning my candle at both ends, is because I haven't figured out how to light the middle yet ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] Problems with a Trigger Statement
I want the following trigger to update a related table when ever a record is inserted/updated. I have the following trigger: CREATE TRIGGER update_status AFTER INSERT OR UPDATE ON public.Bug Status FOR EACH ROW EXECUTE PROCEDURE public.update_status(); Which Calls this function: CREATE OR REPLACE FUNCTION public.update_status() RETURNS trigger AS ' BEGIN UPDATE public.BugTracking SET status = NEW.status WHERE BugTracking.Tracking Number = NEW.Tracking Number END; ' LANGUAGE 'plpgsql' VOLATILE; When I go to insert a record I receive the following error: ERROR: syntax error at or near CONTEXT: compile of PL/pgSQL function update_status near line 4 Any one know where I am going wrong?? Thanks! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] PostgreSQL Invalid Page Header in Block XXXXX
Chris Browne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... [EMAIL PROTECTED] (Anthony) writes: Our Database is having errors. We are currently using PostgreSQL to store 2.5 Million records per day. The average addition to our primary table is 4.5 Gigs of data. We are doing this on a dual Opteron 244 system with 1 TeraByte of HDD space. The drives are 250 Gig Western Digital. The Raid Controller is LSI Logic MegaRaid 150-6. We are getting an error after about 4-5 days worth of data being put into the system. *** ERROR: invalid page header in block 59305 of relation item_info_2004_04_leaf_category_1 *** Our Base Server Configuration is as follows. PostgreSQL Version= 7.4.2 x86_64-PC-Linux-GNU Compiled with GCC 3.3.3 XFS File System Running on Gentoo Linux 3.3.3 Propolice-3.3-7 Any help on how to solve this probelm would be extremely appreciated. Even the potential that Tom Lane might respond to this is worth it. May I point you to the pg_filedump utility? http://sources.redhat.com/rhdb/utilities.html It can give you a fair idea of just where the system is blowing up. I experienced what sounds like the same problem with a system that was fairly similarly appointed with hardware, albeit with a few conspicuous differences... 1. PostgreSQL 7.4.1 2. FreeBSD 4.9 3. Berkeley FFS with soft updates 4. Quad-Xeon, 8GB RAM (only using 4GB of it :-() 5. AMI MegaRaid controller... 6. Slightly less disk; 12x74GB SCSI drives [EMAIL PROTECTED] scsi]# cat /proc/scsi/megaraid/1 LSI Logic MegaRAID 1.74 254 commands 16 targs 7 chans 7 luns What I found in looking at the page with the invalid page header was that it was full of ASCII NUL values. We had previously had quite a bit of trouble with a different box with the same hardware configuration running RHAT 7.3, although when I replaced a 2.4.18 Linux kernel with 2.6.2, those problems evaporated. The only thing that we have been able to point to on the box in question is a hardware problem. In view of the disk being RAIDed, the causes seem to fall to three things being most likely sorts of culprits: 1. Perhaps the controller is glitched; 2. Perhaps the controller driver is glitched; 3. Perhaps there is a RAM problem. Notice that the list of suspects doesn't include any that actually relate to database software. Your best bet is to look for hardware problems. We ran a full RAM test for 15 hours... it came up with NO problems. We are running a more current version of the Kernel than you list above so shouldn't the driver and or controller issues that you think were fixed in the 2.6.2 Kernal be rolled up in the 2.6.3. 1) We are going to setup multiple partitions for differnt file systems... and try the PostgreSQL database on each of those systems and see if the errors persist. Thank you for your response or thoughts on this plan of attacking the problem. Sincerely, Anthony ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [GENERAL] plpgsql: cannot connect to SPI manager
Title: Message I was missing SPI_finish() here. Sorry. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan TreeceSent: Friday, April 16, 2004 3:29 PMTo: [EMAIL PROTECTED]Subject: [GENERAL] plpgsql: cannot connect to SPI manager I'm getting this when i do an insert. I have a 'c' trigger doing an SPI_connect. If i remove this it goes away, but i don't think it's my trigger generating it. The table has a lot of foreign key constraints. Could be postgres is generating code to do this. Is there a way around this or a way track this down. Alan
[GENERAL] Can I reset the lower bound of an array.
Hi, I've been playing about with array's, and found the concat operator '||' quite useful, apart from the fact that prepending an element places it in a lower subscript. Is there a way of either: a) prepending an element, but shifting existing elements up a subscript, so that the lower bound remains the same? eg: 1 || ARRAY[2,3,4] -- new operator || shift array and prepend or b) resetting the lower bound of the array (without affecting elements)? eg: set_array_lower(1 || ARRAY[2,3,4], 1) -- 2nd arg is the new lower bound Also, while on the topic of array's: Is there any way to specify array slices from a subscript to the beginning or end of an array? eg: element to end: array[5:*] beginning to element: array[*:5] At present it is possible by using an extreme +ve or -ve subscript value, but this isn't nice. Cheers -- Mark Gibson gibsonm |AT| cromwell |DOT| co |DOT| uk Web Developer Database Admin Cromwell Tools Ltd. Leicester, England. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] Anyone using pgreplicator?
Replying to my own post, tch, tch... :-) Thanks to those of you who have contacted me off list. It seems that there's a fair bit of interest in replication in general at the moment. I fixed my problem with pgReplicator, so the test system is merrily replicating between Perth and Brisbane as I type. Bandwidth usage is low at the moment. The problem was embarrassingly simple once I checked the actual SQL being received on the remote server. (Thanks Stef of .za for the suggestion). When pgReplicator creates its replication changes to a data base it adds its own unique ID. I did this independently when I initially set this up. This meant that the id for records that I considered to be identical were actually different according to pgreplicator and therefore updates couldn't find the corresponding record to update in the remote system. As I said, embarrassingly simple! The trick when setting up a replicated multi master db is to first of all create the combined db, create the pgr replication schema on this combined db, and then distribute this db around to all sites. Only then do you make the site specific changes (eg, to pgr_lsite, and any locally independent tables). Note that this is the opposite approach to that on the website. Alternatively, (I haven't tried this) one could distribute a schema only db, put the site specific data into it and let replication handle the filling of the common data, by dumping the data as user replicator, then loading it again as a real user. Hope this helps someone else avoid my mistake. Alan Graham On Thu, 2004-04-15 at 22:11, Alan Graham wrote: Apologies if this is off topic, but I've tried the pgreplicator forums, and they appear to be dormant. I'm trying to get a multi master replication app running, I thought I was doing well, I've got past all of the problems mentioned on the pgreplicator forums and (checking the archives) on this list, ie, tcl installed ok, script changes for postgresql 7.3.4 in, communications using scp as user replicator working... Everything in fact works. Except that it doesn't actually replicate. When I synchronise. I can see the traffic going between the sites. I can see the record being replicated appearing on the flow table, I can see it on the history file on both the source and the destination, so it's reaching the destination. There is no sign of any error in any of the pgreplicator logs or the system logs. I've even started postgresql in debug log mode and tailed the log while started the replicator on the remote site. I see the communications come in, and see the commands being entered. But the data isn't being changed on the destination. Any pgreplicator users out there seen this sort of thing before? I thought it might be a permissions issue, but all users have full access. The replicator user can make the changes by submitting an SQL update. pgreplicator has a 'rejected sql' log file, but that's empty. I'm at my wits end... Regards -- Alan Graham [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part
[GENERAL] composite types
I'd like to compute some row like results and return them from a function (and pass the result to PHP[*]). Well I've read about composite type but all the references I've seen are about coding in C. That's not the way I'd like to follow by now. I was expecting to declare composite types in plpsql or plain sql in a similar way I'd do in C/C++ with struct/class. I've found this http://archives.postgresql.org/pgsql-general/2001-03/msg01459.php but I'd like to avoid to declare a table just for a temp. pseudocode follow declare struct pippo( integer a; varchar(8) b; ) create or replace function functiontest( ) returns pippo as ' declare integer tempa; varchar(8) tempb; begin /* do stuff to fill tempa and tempb */ return (tempa,tempb) end ' language plpgsql; [*] I guess that to access the result of such a function ... $SQLResult = pg_exec( $SQLConn, SELECT functiontest( ); ); $SQLData = pg_fetch_row( $SQLResult, 0 ); should be enough... thx ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] [OT] Tom's/Marc's spam filters?
Marc G. Fournier wrote: do you force learn those spam that get through the cracks? I get about 20 or 30 messages that slip through the cracks, which I process through with sa-learn nightly ... No, I haven't been doing that, but I guess I ought to start. Thanks for the suggestion! Joe ---(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
Re: [GENERAL] plan-reading extensive tutorial?
On Mon, 19 Apr 2004, Gregory S. Williamson wrote: FWIW, this site gives: 404 - File Not Found These aren't the droids files you're looking for. Sorry, but that file could not be found. And believe you me, we looked! We checked all the likely directories, then all the unlikely directories, and even grepped through the RAM. We broke into all the computers on our nearby subnet and checked their directories, but still could not find anything. We checked underneath the cushions, but all we turned up was that remote we've been looking for since last year. We searched through the laundry bin, rummaged through the junk drawer, and even asked the neighbor if they had a copy (like they would tell us anyway - they still haven't returned that index.html we loaned them 3 weeks ago!) Are you really, really sure that's the correct file? [which is a lot better than the usual 404 message, you have to admit!] My favorite is: http://www.shartwell.freeserve.co.uk/humor-site/404server.htm ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[GENERAL] I cannot view the website of postreSQL correctly
Hi all, I try to visit the web site of PostgreSQL but my browser doesn't show the intro page correctly. I also tried to visit the site with mozilla. The result was the same. Spesifially, I can only view the background color and a white horizontal line. Do you know what is wrong. Thank you advance Kostas ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] upgrade postgres 7.1 to 7.4.2
Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that the databases are incompatible. Can i convert the databases ? Thank´s for the help Jorge ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] PostgreSQL on SMB/CIFS Shares on FreeBSD 5
I have an embedded system running FreeBSD (5.1) that does not have any local (rotating) storage (i.e disk drives). PostgreSQL also runs on this box and (at this point) has two tables. It is an extremely simple PostgreSQL configuration with the tables having less than 20 fields each, and no relations between the tables. However, because there isn't any (substantial) local storage available on the Compact Flash, and the tables have the potential to grow fairly large, Windows-based shares are being used (via PostgreSQL's 'initlocation') as the backing store for the tables. Moreover, setting the system up consisted of: 1. Setting and exporting PGDATA2=/var/nsg/dbNSG in ~/.profile 2. mount_smbfs [EMAIL PROTECTED]/share /var/nsg/dbNSG 3. initdb (default location (/usr/local/pgsql/data) (on the flash)) 4. start PostgreSQL 5. createuser -A -D nsg 6. initlocation -D PGDATA2 7. createdb -D PGDATA2 -O nsg nsg 8. (create tables) This all completes successfully, the problems begin while attempting to populate the tables. It seems that attempts to add specific records causes my C/libpq application to forever block on 'postgres'. My app is blocked on select(2) (via pg_exec('INSERT...')) and PostgreSQL is blocked on a semaphore. And for the record, the application and PostgreSQL perform flawlessly if step 2 (above) is skipped. In other words, there seems to be problem when SMB/CIFS is layered in. Does anyone have any information that might shed a little light? Anyone use SMB/CIFS as the backing store for PostgreSQL? Thanks in advance! robo ---(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
[GENERAL] Downgrading from Postgresql 7.4 to 7.1
Hello: I have an awkward situation where I must downgrade from 7.4 to 7.1. I have two databases already in 7.4. I'm largely ignorant concerning postgresql: am I going to have any severe problems downgrading? Thanks Matt -- Matt Adams [EMAIL PROTECTED] voice +1 (903) 939-7641 Systems Engineer, Mercy Ships IOC http://www.mercyships.org/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[GENERAL] Solution to Error 429
Over the weekend, I reviewed several of my database programs written in visual Basic 6.0. Discovered that all had DAO 3.51 reference in common. Aparantly this corrupted file was causing the error 429. To solve the problem, copy the DAO 3.5 or DAO 3.6.dll Located on C:\Program Files\Commons Files\Microsoft Shared\DAO35.dll or DAO36.dll to window system32 subdirectory and register either file. You will have full access to DAO references. If you need any help, post it on the site. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] upgrade postgres 7.1 to 7.4.2
Quoting csysi [EMAIL PROTECTED]: Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that the databases are incompatible. Can i convert the databases ? Thank´s for the help Jorge ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] If you could post the exact error that you are getting and how you are proceeding that would be helpful. However, I've upgraded 7.1.3 to 7.4 and I had lots of problems until I used the pg_dumpall from 7.4. In my case, it had two boxes so I ran the pg_dump from the 7.4 box to the 7.1.3. Basically, you are dumping over the network. Its very straight forward. All you have to do is set up the appropriate parameters in the pg_hba.conf file of your 7.1 box and follow the directions in the man page of pg_dumpall (see the -h parameter). If you are not on a network, you could install 7.4 version in a different directory and configure to run on a different port. You still dump via IP this way. You can run both systems head to head that way and see how things went. Good luck- -- Keith C. Perry, MS E.E. Director of Networks Applications VCSN, Inc. http://vcsn.com This email account is being host by: VCSN, Inc : http://vcsn.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Postgresql system requirements to support large
I just want a general idea of what Postgresql can handle. I know the guru's will say it depends on many different things, but in general what can this bad boy handle? 50gb to 100gb is by no means small. But how does Postgresql 7.4 handle database of 900G, or 1 Terabyte or greater? How does Postgresql handle a table with100 columns of integers and varchar2(400) data types with 1 million rows,10 million, 100 million 500 million,greater then 1 billion joined to a small lookup table of 5 rows with both tables indexed properely? Can this database handle enterprise quanities of data or is it geared towards the small to medium data? |-+-- | | [EMAIL PROTECTED] | | | (wilbur douma) | | | Sent by: | | | [EMAIL PROTECTED]| | | tgresql.org| | | | | | | | | 04/15/2004 03:14 PM| | | | |-+-- | | | | To: [EMAIL PROTECTED] | | cc: | | Subject: [GENERAL] Postgresql system requirements to support large databases. | | We are looking at implementing a large Postgresql database (50GB - 100GB) and are wondering if there are any limitations or problems for a database of this size running on 32-bit architecture. I have seen some older posts where it appears that Postgresql seemed to have performance problems when the database reached 5GB, and it was recommended that 64-bit architecture be used. Is this still true with Postgresql version 7.4? This will be out first experience with Postgresql and we are needing to get some ideas of what system requirements a database of this size will require. Since the machines that we have are all 32-bit, we would like to know if we will need to go to 64-bit. Any comments or suggestions?? Thanks in advance for any help. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org * PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. * ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] convert result to uppercase
Am Dienstag, 13. April 2004 14:17 schrieb Victor Spng Arthursson: Hi! How do i convert a result to upper/lowercase? This is a question SELECT UPPER(lang) from languages; and this is the answer. It works exactly like this: SELECT UPPER('dk'); results in 'DK' kind regards, Janning ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] upgrade postgres 7.1 to 7.4.2
On Tue, Apr 20, 2004 at 14:36:57 +0100, csysi [EMAIL PROTECTED] wrote: Hello, i upgrade postgres version 7.1 to version 7.4.2 and it tell me that the databases are incompatible. Can i convert the databases ? You need to do a dump and reload to go between major releases (e.g. from 7.1.x to 7.2.x). If you overlaid your 7.1 binaries you are going to have to uninstall 7.4 and reinstall 7.1 and dump the database. If you have the 7.1 binaries and the 7.4 binaries available, you should use the 7.4 pg_dump(all) to do the dump as it is better about handling dependencies and some other things. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] Downgrading from Postgresql 7.4 to 7.1
-Original Message- From: Matt Adams [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 2:25 PM To: [EMAIL PROTECTED] Subject: [GENERAL] Downgrading from Postgresql 7.4 to 7.1 Hello: I have an awkward situation where I must downgrade from 7.4 to 7.1. I have two databases already in 7.4. I'm largely ignorant concerning postgresql: am I going to have any severe problems downgrading? Just dump and load. It is a very simple procedure. One possibility would be as follows -- From 7.4: pg_dump -c -C -D -f output.sql -h localhost your_database_name_goes_here Into 7.1: psql -h localhost -f output.sql template1 If you are using features that are available in 7.4 and not available in 7.1 then you may have problems. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] [OT] Tom's/Marc's spam filters?
On Tue, 20 Apr 2004, Joe Conway wrote: Marc G. Fournier wrote: do you force learn those spam that get through the cracks? I get about 20 or 30 messages that slip through the cracks, which I process through with sa-learn nightly ... No, I haven't been doing that, but I guess I ought to start. Thanks for the suggestion! Also check to make sure that you don't have autolearn disabled ... you would have had to do it manually, as it is enabled by default, but, for instance, if you are a user on a system, the site-wide may be set to disable autolearn, so you'd have to enable it yourself ... I'm looking forward to 3.x coming out, as the Bayes stuff will be able to run out of an SQL database instead of flat files ... so servers running Cyrus IMAPd, where there are no physical user accounts, will be able to start makng use of Bayes as well ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(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
[GENERAL] PL/SQL question
Hello everyone, I try to see if i can make a recursive function with a trigger set on INSERT and doing an insert under my trigger function. So i wrote a test function : CREATE OR REPLACE FUNCTION testfunc() RETURNS SETOF RECORD AS ' DECLARE use_t RECORD; BEGIN SELECT INTO use_t id_categorie FROM categorie ORDER BY id_categorie DESC; IF use_t.id_categorie50 THEN INSERT INTO categorie (nom) VALUES (''test''); END IF; RETURN NULL; END; 'LANGUAGE plpgsql; The problem is that i can't exec this function to test it, psql return the following error : ERROR: set-valued function called in context that cannot accept a set But my INSERT INTO works if i write it directly. Someone get an idea ? Thx in advance, regards, ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] convert result to uppercase
How do i convert a result to upper/lowercase? I'ld like to do the following: SELECT UPPER(lang) from languages; and get for example uk as UK, dk AS DK and so on? That looks right to me. Are you getting an error? lee=# select version(); version - PostgreSQL 7.4.2 on i386-portbld-freebsd4.9, compiled by GCC 2.95.4 (1 row) lee=# select UPPER('MixED CaSes'); upper - MIXED CASES (1 row) lee=# select lower('MixED CaSes'); lower - mixed cases (1 row) _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] [OT] Tom's/Marc's spam filters?
[EMAIL PROTECTED] (Jim Seymour) writes: Tom Lane [EMAIL PROTECTED] wrote: But in any case, I run the same filters on my secondary server. Both the IP and the HELO checks would be quite useless if I used an MX that wouldn't support 'em. Yup. If you can't employ the same anti-UCE checks on a secondary as you can on a primary, dump the secondary. Secondary MX' are of no value if they just queue things up for the primary, anyway. Nowadays, yeah :-(. Still another part of the internet that spammers have managed to render nonfunctional --- backup MX service used to be essential, but now it's better to risk losing incoming mail than to accept a ton of spam that didn't get filtered properly. Just a couple weeks ago I was complaining to my new ISP because he'd set up a backup MX for sss.pgh.pa.us without asking me whether I wanted it. It's *way* past time to declare open season... regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend
[GENERAL] staggered query?
hi! im new to SQL, and i need to find a solution to this problem: i have a table with two columns, the first column is of type timestamp. the table contains hundreds of thousands of records. i need to get all the entries/records at every 10 seconds interval. example, given a table: hh/mm/ss | data --- 00:00:00 1 00:00:01 2 00:00:02 3 00:00:03 4 00:00:04 5 00:00:05 6 00:00:06 7 00:00:07 8 .. .. my query should return: 00:00:10 00:00:20 00:00:30 (etc) is this possible? if yes, how do i do it? thanks! --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 5/27/2003 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[GENERAL] Slony-I heading for release
The Slony-I project is currently heading for release. The plan is to start BETA around May 12 with a target release date end of June. Nightly CVS exports can be downloaded from here: http://gborg.postgresql.org/project/slony1/projdisplay.php I would like to encourage everyone who intends to use Slony-i for and has not done so yet, to start testing the software immediately. As the PostgreSQL main project, Slony will follow the strict no new features in past releases rule to the letter. There is also a step-by-step example how to install and setup replication. For instant help, I am usually available on the IRC channel #slony on freenode.net. The largest problem left is that the project misses an autoconf and build environment expert. As a result of that, building and installing Slony-I currently requires the original build tree of the PostgreSQL installation to include the original Makefile.global and use other parts of the make process. If anyone out there feels fit to untangle this, you are highly welcome! Jan -- #==# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #== [EMAIL PROTECTED] # ---(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
[GENERAL] TPC H data
Hello, We are trying to import the TPC-H data into postgresql using the COPY command and for the larger files we get an error due to insufficient memory space. We are using a linux system with Postgresql-7.3.4 Is it that Postgresql cannot handle such large files or is there some other possible reason. Thanks Shalu Gupta NC State University. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html