Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

2008-01-08 Thread Andrew Kelly
On Mon, 2008-01-07 at 12:32 -0800, Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 07 Jan 2008 20:25:45 + Richard Huxton [EMAIL PROTECTED] wrote: Scott Marlowe wrote: On Jan 7, 2008 12:57 PM, Devrim GÜNDÜZ [EMAIL PROTECTED] wrote: I want to

Re: [GENERAL] DB upgrade

2007-10-10 Thread Andrew Kelly
On Tue, 2007-10-09 at 11:46 +0200, Andrew Kelly wrote: Hi folks, please forgive what feels like a no-brainer even as I ask it, but... snip Just wanted to thank everybody who's provided feedback. I'm squared away now, and very appreciative of all the help. Andy

[GENERAL] DB upgrade

2007-10-09 Thread Andrew Kelly
Hi folks, please forgive what feels like a no-brainer even as I ask it, but... I've read dozens of times in these lists that when one is upgrading from an older to newer version of PG, the DB being dumped (older version) should be done so using pg_dump from the newer version. I think I've

Re: [GENERAL] DB upgrade

2007-10-09 Thread Andrew Kelly
On Tue, 2007-10-09 at 13:58 +0200, Peter Eisentraut wrote: Am Dienstag, 9. Oktober 2007 schrieb Andrew Kelly: Unless my installation is unique in some way of which I'm yet unaware, Yes, it's a Debian package. Indeed, yes. Where can I read what that means in the great scheme of things

Re: [GENERAL] reporting tools

2007-08-23 Thread Andrew Kelly
On Thu, 2007-08-23 at 06:20 -0400, Geoffrey wrote: Joshua D. Drake wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John DeSoi wrote: On Aug 22, 2007, at 7:21 PM, Geoffrey wrote: We are looking for an open source reporting tool that will enable users to generate their own

Re: [GENERAL] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-19 Thread Andrew Kelly
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote: On 6/18/07, Andreas Kostyrka [EMAIL PROTECTED] wrote: As a cynic, I might ask, what Oracle is fearing? As a realist, I might ask, how many times do we have to answer this type of anti-commercial-database flamewar-starting question?

Re: [GENERAL] open source - content management system - that uses PostGreSQL

2007-02-19 Thread Andrew Kelly
On Sun, 2007-02-18 at 09:59 -0500, John DeSoi wrote: On Feb 16, 2007, at 4:13 PM, Andrew Kirkness wrote: I am currently setting up a website and have PostGreSQL database I'm using for the backend. I'm researching an open source Content Management System that uses PostGreSQL. Do you

[GENERAL] access and security

2006-10-30 Thread Andrew Kelly
Hi all, please forgive a (likely) less than clever question. Are the barriers provided by pg_hba.conf enough from a security standpoint, or is it best to put up some iptable rules duplicating the restrictions? Andy ---(end of broadcast)--- TIP

Re: [GENERAL] access and security

2006-10-30 Thread Andrew Kelly
On Mon, 2006-10-30 at 15:36 +0100, Martijn van Oosterhout wrote: On Mon, Oct 30, 2006 at 01:34:34PM +0100, Andrew Kelly wrote: Hi all, please forgive a (likely) less than clever question. Are the barriers provided by pg_hba.conf enough from a security standpoint, or is it best

Re: [GENERAL] more anti-postgresql FUD

2006-10-11 Thread Andrew Kelly
On Tue, 2006-10-10 at 14:50 -0400, Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: * MySQL is used as a primary development platform. Another good reason. Actually that's *the* reason --- it's always going to be hard for Postgres to look good for an application that's been

Re: [GENERAL] postgresql rising

2006-09-22 Thread Andrew Kelly
On Wed, 2006-09-20 at 10:10 -0500, Tony Caduto wrote: Merlin Moncure wrote: I have seen a steady progressive rise in the number of postgresql related jobs and the quality of those jobs. Major companies are apparently rolling out critical infrastructure on postgresql...Vonage is one

Re: [GENERAL] vista

2006-09-20 Thread Andrew Kelly
On Tue, 2006-09-19 at 10:26 -0400, Tom Lane wrote: Naz Gassiep [EMAIL PROTECTED] writes: For something like Vista compatibility, if you want to be taken seriously by anyone who uses Windows (hands up anyone who knows a Windows user), scratch your own itch is not really going to cut it,

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-15 Thread Andrew Kelly
On Fri, 2006-09-15 at 00:21 -0500, Ron Johnson wrote: On 09/14/06 21:32, AgentM wrote: On Sep 14, 2006, at 21:25 , Bruce Momjian wrote: I am not going to ask how you got to 135MPH. Obviously he was running MySQL under the hood. No wonder he spun out and crashed into a

Re: [GENERAL] PostgreSQL on system with root as only user

2006-08-30 Thread Andrew Kelly
On Wed, 2006-08-30 at 09:17 -0400, Tom Lane wrote: Fredrik Israelsson [EMAIL PROTECTED] writes: I am about to install PostgreSQL on a minimal Linux system, where root is the only user that is allowed to exist. You've *got* to be kidding. That's possibly the stupidest system design

Re: [GENERAL] CMS - portal server Question

2006-08-25 Thread Andrew Kelly
On Fri, 2006-08-25 at 12:07 +0300, Achilleas Mantzios wrote: snip In the same sense java is prefered over PHP, since we dont intent to interfere with CMS code, but if some killer PHP app does the job, then it will be the one selected. Take a look at eZpublish (http://ez.no). Killer PHP app,

Re: [GENERAL] [HACKERS] 'a' == 'a '

2005-10-20 Thread Andrew Kelly
On Thu, 2005-10-20 at 08:14 -0400, Jan Wieck wrote: On 10/20/2005 2:17 AM, Greg Stark wrote: (I can't believe anyone really wants varchar to be space padded. Space padding always seemed like a legacy feature for databases with fixed record length data types. Why would anyone want a

Re: [GENERAL] Limitations of PostgreSQL

2005-10-13 Thread Andrew Kelly
On Wed, 2005-10-12 at 16:49 -0500, Scott Marlowe wrote: On Wed, 2005-10-12 at 16:16, Chris Travers wrote: Denis G Dudhia wrote: Hello There... I am new to PostgreSQL. I usually check out negative sides of any software or system, before implementing it or using it. snip

Re: [GENERAL] I have had enough

2004-11-10 Thread Andrew Kelly
On Wed, 2004-11-10 at 14:56, Mike Cox wrote (or didn't write): snip the scat I guess that pretty much firmly identifies this list as an unmoderated list, non? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

[GENERAL] OT: Dup mails

2004-05-12 Thread Andrew Kelly
Sorry if this has already been covered... Suddenly I'm receiving every post to the pgsql-general list twice; been happening for a couple days now. I even unsubscribed for a bit and then resubscribed, but it continues. Is this just me, or is this a global thing? FWIW, I'm only getting single

Re: [GENERAL] OT: Dup mails

2004-05-12 Thread Andrew Kelly
Whoops, disregard please. I shoulda noticed that the headers were identical before I went whining to the list. Sorry everybody. Turns out to have been a hammered chain of filters. Thanks for the nudge, Tom. Andy On Wed, 2004-05-12 at 13:03, Andrew Kelly wrote: Sorry if this has already been

Re: [GENERAL] convert result to uppercase

2004-04-21 Thread Andrew Kelly
On Tue, 2004-04-20 at 23:39, Janning Vygen wrote: Am Dienstag, 13. April 2004 14:17 schrieb Victor Spång 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: