Jade's weblog Archive

Analyzing queries in Postgres [www.databasejournal.com]

Good article on logging and analyzing queries in Postgres, thanks to Jeff.

12:15 PM, 30 Jun 2004 by Jade Rubick Permalink | Comments (0)

The link doesn't actually go to the after-mount callback, but it shows how it's added into the .info file.

11:54 AM, 28 Jun 2004 by Jade Rubick Permalink | Comments (0)

.

01:51 PM, 23 Jun 2004 by Jade Rubick Permalink | Comments (0)

Perl script to rename Postgres user in dump file

perl -pi -e "s/^\\connect olduser$/\\connect newuser/" filename

Thanks, Dave, Dossy, and Til.

To load in the database dump:

psql -f filename dbusername

12:44 PM, 22 Jun 2004 by Jade Rubick Permalink | Comments (0)

Making an SMTP conversation [www.cs.cf.ac.uk]

Helpful reference.

02:43 PM, 20 Jun 2004 by Jade Rubick Permalink | Comments (0)

I updated my easy virtual hosting document. I finally fixed the most major problem I was having with it.

12:39 PM, 20 Jun 2004 by Jade Rubick Permalink | Comments (0)

Setting up a mailserver on Qwest

My ISP (Qwest) recently implemented a brain-dead measure to prevent spam. They require you to check your email before you can send out email.

Of course, this doesn't prevent spam at all -- it only makes it harder if you have a low-volume mail server. Here's what I did to get around this:

$ crontab -e

Add this line:

*/10 * * * * /usr/bin/telnet pop.ptld.qwest.net 110 < /home/mename/bin/script.txt >& /dev/null

Every ten minutes, it connects to port 110, and runs the contents of bin/script.txt

$ cat bin/script.txt
user username@qwest.net
pass mypassword
list
quit

10:36 AM, 20 Jun 2004 by Jade Rubick Permalink | Comments (0)

Interesting..

What I actually ended up doing, however, is setting Spamassassin up with Exim

10:02 PM, 19 Jun 2004 by Jade Rubick Permalink | Comments (0)

Set up courier-imap on Debian [talk.trekweb.com]

I used this link to set up courier-imap. I also looked at http://www.crazysquirrel.com/debian/mail.php

08:49 PM, 19 Jun 2004 by Jade Rubick Permalink | Comments (0)

This changes every day, I believe. Thanks to Joel.

12:21 PM, 19 Jun 2004 by Jade Rubick Permalink | Comments (0)

I appeared in another article featuring my work with Stop Abuse For Everyone. It was a very positive article, I think.

01:00 AM, 06 Jun 2004 by Jade Rubick Permalink | Comments (0)

XML

Notifications

You may request notification for Jade's weblog.

Syndication Feed

XML

Recent Comments

  1. Jade Rubick: And... yes and no
  2. Jade Rubick: Using hoptoad
  3. Jade Rubick: Much better
  4. Bodo Tasche: Link changed :)
  5. Bodo Tasche: Better commt emails. Now with color :)
  6. Jade Rubick: Filed a ticket
  7. Vinod Kurup: Wow
  8. Jade Rubick: Then what
  9. Paul Post: Percentages
  10. Paul Post: I might be an ENFJ?