Re: [ADMIN] Recursive use

2006-10-10 Thread Jay A. Kreibich
On Tue, Oct 10, 2006 at 10:15:42AM -0500, Jim C. Nasby scratched on the wall: > On Fri, Oct 06, 2006 at 10:37:26AM -0500, Jay A. Kreibich wrote: > > These are generally referred to as "Hierarchical Queries" and center > > around the idea of a self-referencing t

Re: [ADMIN] Recursive use

2006-10-06 Thread Jay A. Kreibich
r any more than three levels deep) you can also join the table to itself multiple times. This can get really confusing very quickly, and is not an overly general solution, but it can be done in "pure" SQL in a fairly straight forward (if not a bit complex) kind of way. -j --

Re: [ADMIN] [GENERAL] Storing database in WORM devices

2005-05-11 Thread Jay A. Kreibich
ot support this very well, if at all. -j -- Jay A. Kreibich | CommTech, Emrg Net Tech Svcs [EMAIL PROTECTED] | Campus IT & Edu Svcs <http://www.uiuc.edu/~jak> | University of Illinois at U/C ---

Re: [ADMIN] Backup

2005-03-23 Thread Jay A. Kreibich
want to have a look at this: http://www.postgresql.org/docs/8.0/static/backup-online.html -j -- Jay A. Kreibich | CommTech, Emrg Net Tech Svcs [EMAIL PROTECTED] | Campus IT & Edu Svcs <http://www.uiuc.edu/~ja

Re: [ADMIN] NIC to NIC connection

2004-10-21 Thread Jay A. Kreibich
'm not a switch specialist but given the ability > to do routing I was imagine the arpping trich... Yes, but such systems are generally routers first and switches second. -j -- Jay A. Kreibich | Comm. Technologies, R&D [EMAIL PRO

Re: [ADMIN] NIC to NIC connection

2004-10-21 Thread Jay A. Kreibich
the same company. IGMP snooping is also really tricky to do right, and there are still some situations where you are forced to flood traffic. -j -- Jay A. Kreibich | Comm. Technologies, R&D [EMAIL PROTECTED] | Campus IT &am

Re: [ADMIN] NIC to NIC connection

2004-10-19 Thread Jay A. Kreibich
quot;cross-over" cable, not a "roll" cable. There is a difference. With many newer, high quality NICs, you don't even need that. Many modern NICs do auto MDI/MDI-X detection, so any standard cable will do. -j -- Jay A. Kreibich | Comm. Technolog

Re: [ADMIN] Multiple WALs for PITR ?

2004-10-07 Thread Jay A. Kreibich
aches (our application writes data at a very very slow rate; the main reason we have RAIDs is protection, size, and *read* speed). -j -- Jay A. Kreibich | Comm. Technologies, R&D [EMAIL PROTECTED] | Campus IT & Edu. Svcs.

Re: [ADMIN] Time is off in PG server

2004-08-26 Thread Jay A. Kreibich
? Work in the same timezone. EST and EDT are not the same. -j -- Jay A. Kreibich | Integration & Software Eng. [EMAIL PROTECTED] | Campus IT & Edu. Svcs. <http://www.uiuc.edu/~jak> | University of Illinois at U/C --