Re: [GENERAL] Uninstall postgres 7.4

2003-12-12 Thread scott.marlowe
On Fri, 12 Dec 2003, Josué Maldonado wrote: > Hello list, > > What's the "right" way to uninstall postgres 7.4 in Linux (RH 8)?. That really depends on how it was installed. If installed via RPM, then you do 'rpm -e postgrespackagenameshere'. If it was installed from source, 'make uninstall'

Re: [GENERAL] Uninstall postgres 7.4

2003-12-12 Thread Josué Maldonado
Hello Scott, I forgot to mention that, it was installed from source. Thanks for anwsering. scott.marlowe wrote: On Fri, 12 Dec 2003, Josué Maldonado wrote: Hello list, What's the "right" way to uninstall postgres 7.4 in Linux (RH 8)?. That really depends on how it was installed. If instal

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread John Sidney-Woollett
If you considering a skills outline, also consider dividing it two areas; developer and dba. My experience is mostly with Oracle (more years than I care to remember), and with this product in many organizations, there are usually two camps; the dba (God) and the developers (devils - always trying

[GENERAL] Moving the database from a filesystem to another

2003-12-12 Thread Együd Csaba
Hi All, one of my customers has a Postgres 7.2.3 DB on an RH7.1 box. Running df it seems that the DB is not on the appropriate filesystem. /dev/md1 5040352 2562316 2221992 54% / /dev/md0100020 8989 85867 10% /boot /dev/md2 28831612 980

[GENERAL] experiences with postgres in ia64 and linux

2003-12-12 Thread Manuel Duran Aguete
Hi all, I'm interesting to know about experiences of usign postgresql in ia64 under linux. * What about performance ? * What about stability ? * Which linux version ? At now, I usign debian in x86. * Any suggestion or recomendation ? * Better than alpha o

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Bret Busby
On Fri, 12 Dec 2003, Bruce Momjian wrote: > Date: Fri, 12 Dec 2003 08:41:39 -0500 (EST) > From: Bruce Momjian <[EMAIL PROTECTED]> > To: Chris Travers <[EMAIL PROTECTED]> > Cc: Stephan Szabo <[EMAIL PROTECTED]>, Bret Busby <[EMAIL PROTECTED]>, > [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject:

Re: [GENERAL] add column sillyness

2003-12-12 Thread Tom Lane
"Rick Gigger" <[EMAIL PROTECTED]> writes: > Does anyone have a link to such a comparison? Also can anyone elaborate on > the features that postgres has that firebird lacks? AFAICT, the main thing that Firebird lacks is a viable open-source development community :-(. It's a nice bit of software,

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Bruce Momjian
Chris Travers wrote: > I am wondering if you are interested in helping with some sort of skills > outline project-- what skills we as a community think are important for > someone to claim basic mastery over the database manager. Not as if you > don't have enough to do already ;-) Maybe at least

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Bruce Momjian
Keith C. Perry wrote: > > Also, though lots of people want training, seems that want _free_ > > training. They aren't flooding my Atlanta classes, that's for sure. I > > give classes at many conferences around the world too, and I get usually > > 20-40 people --- not exactly a flood either. Mayb

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Keith C. Perry
Quoting "Marc G. Fournier" <[EMAIL PROTECTED]>: > On Thu, 11 Dec 2003, Peter Eisentraut wrote: > > > Keith C. Perry wrote: > > > That situtation is a little different though since Linux comes is > > > various distributions. Eventually people with get that Linux = Red > > > Hat is NOT true. Heck,

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Keith C. Perry
Quoting Peter Eisentraut <[EMAIL PROTECTED]>: > Keith C. Perry wrote: > > That situtation is a little different though since Linux comes is > > various distributions. Eventually people with get that Linux = Red > > Hat is NOT true. Heck, IBM is probably the best at promoting Linux > > these days

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Jeff Eckermann
Chris, Your persistence and your ideas suggest that you have something to contribute in this area. Why not sign up on the pgsql-advocacy list, and carry your ideas forward there? That would be an appropriate forum for this kind of discussion. The arguments on both sides (if there are only two s

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Keith C. Perry
Quoting Bruce Momjian <[EMAIL PROTECTED]>: > John Gibson wrote: > > > > > > > > >> "Linux" training is not standardized by any measure either. Lots of > > >> companies and "institutions" offer their own training courses. Some > > >> of these grow to be fairly well recognized and are offered in

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Keith C. Perry
Quoting Rick Gigger <[EMAIL PROTECTED]>: > > Ok, I see what you're trying to do. In looking at this it occurs to me > that one > > of the way to aid in this effort is through more tech documents. For > instance, > > I have asked before what is the recommended procedure or stategy for > recoveri

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Chris Travers
On Fri, 2003-12-12 at 21:40, Bruce Momjian wrote: > Imagine if Linus or the Linux kernel guys tried to standardize Linux > training --- it would be a mess. > Exactly, but that is what community is for :-) > Also, though lots of people want training, seems that want _free_ > training. They aren'

Re: [GENERAL] ERROR: JOIN/USING types 'integer' and 'character

2003-12-12 Thread Tom Lane
Oliver Elphick <[EMAIL PROTECTED]> writes: > I think the error means that you are joining on columns of differing > types. (E.g.: SELECT * FROM a JOIN b ON a.id = b.id, where a.id and > b.id are of different types.) More specifically, SELECT ... FROM a JOIN b USING (foo), where a.foo and b.foo ar

[GENERAL] Uninstall postgres 7.4

2003-12-12 Thread Josué Maldonado
Hello list, What's the "right" way to uninstall postgres 7.4 in Linux (RH 8)?. Thanks in advance -- Josué Maldonado ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatype

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Chris Travers
On Fri, 2003-12-12 at 02:04, Keith C. Perry wrote: > > > > Agreed. However-- there is a push in the IT world (much resisted here) > > to try to make sysadmin/DBA positions more of a technician-oriented > > rather than academic oriented. The idea here is that it reduces IT > > costs (perhaps, th

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Bruce Momjian
Chris Travers wrote: > I think though that there is an opportunity, though, for us to perhaps > work together in developing a Postgresql training base curriculum. We > can pool some resources and perhaps develop at least a list of the > things which ought to be covered. Perhaps this can lead to bo

Re: [GENERAL] [NOVICE] PostgreSQL Training

2003-12-12 Thread Bruce Momjian
John Gibson wrote: > > > > > >> "Linux" training is not standardized by any measure either. Lots of > >> companies and "institutions" offer their own training courses. Some > >> of these grow to be fairly well recognized and are offered in similar > >> form repeatedly in different locations, b