[GENERAL] 9.6 Release: Call for Quotes

glish, although the quoted party must be willing to have their quote translated. I will need any quotes by September 15th. If you know someone who can give us a quote, or can suggest someone I can ask, let me know. Thanks! -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-ge

Re: [GENERAL] Locking issue

TE with LIMIT/ORDER is always fairly tricky, and tends to block the whole set, not just the LIMITed row. What I suggest is that you walk this through several concurrent sessions yourself. Use explicit transactions so that each concurrent session will hold onto its locks. -- -- Josh Berkus Red Hat

[GENERAL] Meetup in Boston city?

Boston folks: I'll be in Boston on the 24th/25th for ContinerDays. It would be nice ot meet up with other Postgres folks there ... except that it looks like the Boston PUG is located in Bedford? Is there a meetup in Boston or Cambridge? -- -- Josh Berkus Red Hat OSAS (any opinions are m

Re: [GENERAL] PostgreSQL flavors

PowerGres 7.3 CDs when I moved? They were in the back of a closet. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL flavors

ver this because it broke their tools with no warning. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL flavors

lable only on AWS as a service. Vertica: Another PostgreSQL-based column store. Unclear on how much PostgreSQL code it uses, but uses a version of the PostgreSQL protocol and psql client. FAST: Fujitsu's spin of PostgreSQL, optimized for high performance on high-end hardware. -- -- Josh

Re: [GENERAL] Replacement for Oracle Text

d then you can FTS it. I know there's a module for OpenOffice docs somewhere as well, but heck if I can remember where. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: htt

Re: [GENERAL] PostgreSQL vs Firebird SQL

marily a desktop database. I suggest looking into pgAdmin4 to help with that. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] no pg_hba.conf entry for replication connection

from host "192.168.50.36", user "postgres", SSL off Did you reload the master? -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] SSD gives disappointing speed up on OSX

es will be slow no matter how good your hardware is. Supposedly you can still run ZFS on OSX, which might help you. I haven't done it, though. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] handling time series data

you. -- -- Josh Berkus Red Hat OSAS (any opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Code of Conduct plan

members are unhappy with the amount of list traffic devoted to the subject of CoCs. As such, if you have comments on the plan above, please email the core team instead of replying on-list, or wait for the committee and address comments to them. --Josh Berkus PostgreSQL Core Team -- Sent via p

Re: [GENERAL] Can PostgreSQL use multi-column index for FK constraint validation?

) of col3 items for each col1/col2 combo, then I'd *probably* add a specific FK index. Given the "I don't know" you have above, I generally wouldn't add one, and then look at response times on updates/deletes to the orders table to see if there's a performance issue.

Re: [GENERAL] Can PostgreSQL use multi-column index for FK constraint validation?

elective (col1, col2) is without col3, and how large the table is. -- Josh Berkus Red Hat OSAS (opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] request for comment re "contributor-covenant.org"

quot;community covenant"; just my opinion of course. Personally, I doubt the entire FLOSS universe would *ever* come to an agreement on anything, except maybe that code ought to be OSS-licensed. -- Josh Berkus Red Hat OSAS (opinions are my own) -- Sent via pgsql-general mailing lis

Re: [GENERAL] request for comment re "contributor-covenant.org"

anned"; only our Infra Team can do that. Please do not presume to do so for them. -- Josh Berkus Red Hat OSAS (opinions are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Indianapolis PostgreSQL Meetup

IN Folks: I will be visiting Indianapolis in early December, so we will have our first-ever PostgreSQL meetup in that city on December 2. It's being hosted by the Big Data Meetup at ElevenFifty academy. RSVP here: http://www.meetup.com/IndyBigData/events/224656314/ -- Josh Berkus Postg

[GENERAL] Anyone in Indianapolis? Meetup on Dec. 3?

bably), including someone who can host the event (probably at your office). -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] A Core Team statement on recent conference events

experience. The Russian conference organizers are expected to comment on this unforseen incident once the conference is concluded. The international community will be working with them to make sure that this mistake is not repeated. -- Josh Berkus On behalf of the PostgreSQL Core Team -- Sent

[GENERAL] Meetups in New Zealand Jan 12 to 20

Folks: Since NZPUG hasn't had any meetups in a while, I've organized some around my upcoming visits to Auckland and Wellington. If you live in either of those cities, please RSVP to the appropriate event. https://wiki.postgresql.org/wiki/Nzpug -- Josh Berkus PostgreSQL Experts

[GENERAL] Call for Speakers and Sponsors for pgDaySF 2015

-call-for-speakers-and-sponsors/ -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

ot;Have You Seen Me?" ;-) -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [sfpug] Linuxfest 2015 Call for Papers

ruary, SF in March*, Seattle in April. It's West-Coast Postgres festival! (* http://www.sfpostgres.org/pgday-sf-2015 ) -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs

[GENERAL] PostgreSQL at LISA in Boston: Dec. 7-8

.html#postgres -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PostgreSQL to Ingres migration

it, please email me privately so that I can forward your contact information to them. Thanks! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pg

[GENERAL] Looking for an intro-to-SQL book which is PostgreSQL-friendly

d habits around keys. Does anyone have other suggestions? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Two PHP projects looking for PostgreSQL help

ng to help out. Either contact me (off-list), or if you're already on a Mediawiki or Joomla project mailing list, speak up there. Thanks! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] You could be a PostgreSQL Patch Reviewer!

Radoslaw, > https://commitfest.postgresql.org/action/patch_view?id=565 > https://commitfest.postgresql.org/action/patch_view?id=579 Actually, I assigned you to 580 instead of 579, because supposedly Noah is reviewing 579. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com --

[GENERAL] You could be a PostgreSQL Patch Reviewer!

PostgreSQL ... review a patch! http://wiki.postgresql.org/wiki/Reviewing_a_Patch -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] We need you to beta-test PostgreSQL 9.1

s your turn. Both the quality and the speed of release for 9.1 depend on you. -- Josh Berkus PostgreSQL Core Team -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

lled) include two modes in the spec; one which checkpoints (and thus can survive a planned restart) and one which doesn't (and will truncate on every restart, but doesn't cause physical I/O). We may or may not have both modes for 9.1. -- -- Josh Berk

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

pg_dump by default. But it's also possible that we'll only have one type of unlogged table in 9.1., with other options waiting for 9.2. -- -- Josh Berkus PostgreSQL Experts Inc.

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

eps required to make it work. Note that you would have the option of periodically synching an unlogged table to pgdump or to a logged table, via script, if you cared about retaining the data. That would probably give you the behavior you want, above. -- --

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

> I'd vote for backing up the schema of an unlogged table so it's there > on a restore. The schema is always there. What may or may not be there is the data. -- -- Josh Berkus Postgr

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

rather than yours. I don't quite follow you. The purpose of unlogged tables is for data which is disposable in the event of downtime; the classic example is the a user_session_status table. In the event of a restart, all user sessions are going to be invalid anyway. --

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

> With the current patches, the data survives a restart just fine. Per -hackers, that's not guarenteed. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com --

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

> This is a link to a read-only spreadsheet for me. You're correct. Darn those Google unreadable links! https://spreadsheets.google.com/viewform?formkey=dDFnT2VKNC1FQ0pQNmJGS2dWMTNYMEE6MQ That should work. -- -- Jos

[GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

le.com/ccc?key=0AoeuP3g2YZsFdDFnT2VKNC1FQ0pQNmJGS2dWMTNYMEE&hl=en&authkey=CISbwuYD -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgsql-general m

[GENERAL] Anyone in Madison?

Folks, I'll be unexpectedly in Madison next week for an onsite contract. Is there a user group in Madison I could meet up with? Maybe do a quick session on 9.0? -- -- Josh Berkus PostgreSQL Expert

Re: [sfpug] [GENERAL] Tuesday (PST8PDT) Jeff Davis Presents: Operator Exclusion Constraints

> I suppose the video will be available later online? Yes. --Josh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Getting rid of VACUUM FULL: please comment

l-feedback-needed-33959 -- Josh Berkus PostgreSQL Experts Inc. www.pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Anyone in New Zealand?

Kiwis, I'd like to have a PostgreSQL miniconf at LinuxConf.AU in 2010. Deadline to apply is July 17. I know we have an NZ community ... can you get in touch so we could put together a proposal? -- Josh Berkus PostgreSQL Experts Inc. www.pgexperts.com -- Sent via pgsql-general mailing

[GENERAL] Schedule up for pgDay San Jose

Folks, For any PostgresQL users who live in San Jose, or are planning to attend OSCON, we have a full day of PostgreSQL talks on Sunday July 19th. Full details, including free registration information are here: http://wiki.postgresql.org/wiki/PgDaySanJose2009 --Josh Berkus -- Sent via

Re: [sfpug] [GENERAL] "Rails and PostgreSQL" now up on media.postgresql.org

Josh, Dave, Can you embed the files on the PUGs page like JD suggests? What I want to avoid is an ad-hoc website springing up on media.postgresql.org that ends up in Google and being linked from who-knows-where. Hmmm ... not sure my Drupal-foo is good enough. Will seek help -- Josh

Re: [sfpug] [GENERAL] "Rails and PostgreSQL" now up on media.postgresql.org

e we have raw HTML because of the widget embedding. Should that be somewhere else? -- Josh Berkus PostgreSQL Experts Inc. www.pgexperts.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [sfpug] [GENERAL] "Rails and PostgreSQL" now up on media.postgresql.org

On 6/10/09 7:20 PM, Christophe wrote: On Jun 10, 2009, at 6:27 PM, Chris wrote: Can you list the filesizes on http://media.postgresql.org/sfpug/ please? Oh, good idea. Didn't think of it. --Josh -- Josh Berkus PostgreSQL Experts Inc. www.pgexperts.com -- Sent via pgsql-general ma

[GENERAL] Streaming SFPUG: PostgreSQL & Rails June 9 (tommorrow)

! Log in here: http://media.postgresql.org/sfpug/streaming -- Josh Berkus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Streaming PUG meeting: PostgreSQL Genetics!

c...@zip.com.au wrote: On Wed, Mar 11, 2009 at 05:41:55PM -0700, Josh Berkus wrote: All, There *may* be a streaming presentation of PostgreSQL, Unison-DB and Genetech in 1/2 hour: http://cubic.org/sfpug.html 6:15 or 6:30pm PST/PDT, March 11th Join us and see if it works! Will there be a

[GENERAL] Streaming PUG meeting: PostgreSQL Genetics!

All, There *may* be a streaming presentation of PostgreSQL, Unison-DB and Genetech in 1/2 hour: http://cubic.org/sfpug.html 6:15 or 6:30pm PST/PDT, March 11th Join us and see if it works! --Josh Berkus -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [pgsql-advocacy] [GENERAL] pgsql announce now on twitter

Christophe wrote: On Mar 4, 2009, at 9:54 AM, Joshua D. Drake wrote: Not sure what the complainer is talking about here. pgsql-announce is moderated so spam should be almost nil. I'm not 100% sure what "Twitter spam" *is*, for that matter. Redundant. ;-) --Josh -- Sent via pgsql-general

Re: [GENERAL] [pgsql-advocacy] [pdxpug] Pg booth staffing at OSCON

Daniel, > And now I see that commandprompt has posted a postgres job this > afternoon. D'oh! Heh, should have asked. There's generally lots of PostgreSQL work available, although some of it does require relocation ... -- Josh Berkus PostgreSQL San Francisco -- Sent v

Re: [GENERAL] [pgsql-advocacy] [pdxpug] Pg booth staffing at OSCON

Daniel, > We help make the conference happen so please treat us with respect even if we can't afford to pay are way in. Huh? How was I disrespectful? Because I suggested discounts? As a committee members you are technically a volunteer with a free pass yourself! Well, I actually have a f

Re: [GENERAL] [pgsql-advocacy] [pdxpug] Pg booth staffing at OSCON

gh you already missed the early bird discount. -- Josh Berkus PostgreSQL @ Sun San Francisco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Reminder: Google Summer of Code deadline 72 hours away!

If you are a student, or know a student, or are a professor ... www.postgresql.org/developer/summerofcode Please submit an application as soon as you can! --Josh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

l.org since we've had this discussion; not having in on the web was an oversight. -- Josh Berkus PostgreSQL Project Core Team Member (any opinions expressed are my own) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

f a blog > software does not have that feature, we have some alternatives like > feedburner. If asked politely, I'm happy to help anyone. Lewis is on the same SW I am: ittoolbox.com. It works pretty normally where excerpts are concerned. -- --Josh Berkus Josh Berkus PostgreSQL Projec

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

posts. Is that correct, Devrim? -- --Josh Berkus Josh Berkus PostgreSQL Project Core Team www.postgresql.org (all opinions expressed are my own; I do not speak for the Project unless specifically noted.) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

iring. He's also not the sole admin of planetpostgresql.org. -- --Josh Berkus Josh Berkus PostgreSQL Project Core Team www.postgresql.org (all opinions expressed are my own; I do not speak for the Project unless specifically noted.) -- Sent via pgsql-general mailing list (pgsql-general@post

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification -- wind it up, please.

please do your part to keep the lists accessable to everyone. Thanks! -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

e together with all the other postgresql.org list archives, an important point. So, I'm in favor of a separate list, but think that having a separate domain is a mistake. The separate domain says "this is a Drake and Selena effort and not a community effort" to those not involved. -

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

JPA, Id really prefer my company be certified by the community rather than by a company, despite the full respect I have in SRA's engagement in PostgreSQL and that we all know their contributions. What would it mean for a company to be certified? --Josh ---(end of br

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

Josh, I have not spoken with SRA or the Venezualan folks but am more than happy to have them involved. OK, I'll get you some contact info. --Josh ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

Josh, Myself and a small team of PostgreSQL contributors have started a new community project for PostgreSQL Certification. It is just launching but we wanted to get it out there so that people can join in on the discussion now :). Who else is in this? Have you talked to the Venezualan folks?

[GENERAL] Desparately seeking new India Regional Contact for postgresql.org

lease. E-mail me ASAP. Thanks! -- --Josh Josh Berkus PostgreSQL Core Team San Francisco ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [pgsql-advocacy] [GENERAL] Looking for Graphical people for PostgreSQL tradeshow signage

Alexander, I tried to find the original vector graphics for the PostgreSQL elephant logo, but couldn't find it anywhere. I think that's a prerequisite. I would not mind having a stab at it. www.pgfoundry.org/projects/graphics look under "docs", there are AI files. --Josh

[GENERAL] Reminder: only 5 days left to submit SoC applications

oint them to our SoC page and encourage them to apply right away! If you are a student, and you've been trying to perfect your application, please go ahead and submit it ... we can't help you if you miss the deadline, but we can help you fix an incomplete applicati

[GENERAL] Attention Skandanavians: Josh in Oslo

o meet you. -- Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to t

Re: [GENERAL]

The authors of pg_bulkload have not proposed it for core inclusion. -- --Josh Berkus Josh Berkus PostgreSQL Project Core Team www.postgresql.org (all opinions expressed are my own; I do not speak for the Project unless specifically noted.) ---(end

Re: [HACKERS] Re: [GENERAL] 5 Weeks till feature freeze or (do you know where your patch is?)

Jeff, > I am still on target. I'm scheduling some benchmarks on real hardware > and real queries in the next week or two. If those show the results I > expect, I'll be ready before feature freeze. Send me a patch against 8.2.3 and I'll pass it to the Sun benchmarking

Re: [pgsql-advocacy] [GENERAL] PostgreSQL 9.0

o make sure that as many companies as possible have invested in making PostgreSQL an integral part of their infrastructure and/or product line. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 1: if posting/readin

[GENERAL] Calling all SoCal PostgreSQL Users!

would be great if other members of our Southern California community helped us staff the booth and the show, or at least dropped by to say hi and hang out.  Also, it would be cool to have dinner or a party after the show ... who knows, this could even be the start of an LAPUG. -- --Josh Josh

Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.2 Now Available

Ragnar, Now that this has been announced, should not http://www.postgresql.org/docs/current/ and co be redirected to http://www.postgresql.org/docs/8.1/ instead of http://www.postgresql.org/docs/8.2/ in particular, the press release's link to the Release Notes brought me to http://www.postgr

Re: [GENERAL] [pgsql-advocacy] Call for Donations

Community, Please note that we are also planning on having a donor listing somewhere on the postgresql.org web site Real Soon Now. We're just being held up at this point by the necessity of developing the technology and donor accounting. -- --Josh Josh Berkus PostgreSQL @ Sun San Fran

Re: [GENERAL] [pgsql-advocacy] Thought provoking piece on NetBSD

acy and are looking for excuses why company X needs to "take over the project for its own good." -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an approp

Re: [GENERAL] [pgsql-advocacy] Thought provoking piece on NetBSD

pment goals. And we've already discussed this ad nauseum on the Hackers list and AFAIK have an initial plan (the enhanced TODO), lacking only the resources to implement it this month. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(

Re: [GENERAL] [pgsql-advocacy] LW Boston

Josh, > Thanks everyone for helping us make the PostgreSQL booth the best OSS > booth in the pavilion. Thank you for organizing it! -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: Have you check

Re: [GENERAL] FW: Surrogate keys (Was: enums)

Thomas, Many times you will have references to a specific row from somewhere outside of your database. Perhaps you have a federation of web services that collaborate or other arbitrary URL's that contain the key. It might be harder to create remote row sets, middle tier caches, and other sim

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

ibed to 8 PostgreSQL mailing lists since 1999, and this is the first time I can recall someone complaining about this comparison behavior. So it's obviously not a widespread issue. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)-

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

Ned, > and it looks like postgres.net got picked up by some > guy who's sitting on it. yeah, I'm not sure what he wants. Postgres.net currently directs people to PostgreSQL.org, and I've offered the contact of record money to buy it off him, with no response. -- --Jo

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

ibuting indirectly for a while, and are working on getting Solaris binary packaging organized. They're just not big on joining mailing lists, something we need to educate them on. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)---

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

I are working on making sure these things are legally protected. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] [PERFORM] Text/Varchar performance...

greSQL VARCHAR is not limited to 255; I think we support up to 1GB of text or something preposterous. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore y

[GENERAL] Anyone use Eclipse?

People: The Eclipse project is interested in having PostgreSQL people contribute to their Data Services plug in. Do we have any java hackers in the community using Eclipse? Anyone interested? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of

Re: [GENERAL] [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type

D- > Anybody interested in contributing to this? Interested, yes. Free time's a little harder to come by, as you know ... -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: Have you che

Re: [GENERAL] [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type

KL- > What I think we need is a C program that dumps directly from MySQL into > PostgreSQL sql. Why C? PerlDBI or JDBC should be able to do this readily enough. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)-

[GENERAL] Going to OSCON? We need your help!

e-mail address, name, what shifts you are available for (and how many you'll do), and your cell phone number for the show.** -- --Josh Berkus Josh Berkus PostgreSQL Project ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will i

Re: [GENERAL] [pgsql-advocacy] MySQL worm attacks Windows servers

PROTECTED]" mail alias? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] [pgsql-advocacy] MySQL worm attacks Windows servers

Core only, please). -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] [sfpug] Basic problem installing TSearch2 (full text

Jon, > SHOW server_encoding; > /* above command displays: SQL_ASCII */ > update pg_ts_cfg set locale = 'SQL_ASCII' where ts_name = 'default' Are you sure your locale is SQL_ASCII and not en_US? --Josh ---(end of broadcast)--- TIP 8: explain a

Re: [GENERAL] [PERFORM] pg_restore taking 4 hours!

and more on disks would be wise. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Fwd: Favorite DB poll on ORA

Folks, We've been issued a challenge ... so Vote! Vote! Vote! - Hey Gents, You might want to rally the troops -> http://www.oreilly.com/ ----- -- Josh Berkus Aglio Database Solutions San Francisco ---(end of b

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

ersion of mysqldump, which is what I'm struggling with. To quote one of the developers on #mysql: "Oh, that's not really a bug, it only affects ANSI mode". However, Perl is superb at pattern-matching, so I've patched for it ... -- -Josh Berkus Aglio

Re: [GENERAL] sybase->postgresql

for older SyBase servers, though. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Anyone used GForge?

Folks, Since GForge runs on PostgreSQL, I wanted to see if anyone in our community could give testimony on running it or using it, professionally, or on another open source project. Please e-mail me off list. Thanks! -- Josh Berkus Aglio Database Solutions San Francisco

Re: [GENERAL] sybase->postgresql

something. Easiest way? Use perl to pull from Sybase and build a COPY-formatted file. Then have perl log into postgres and load the file. Seems awkward, but it's actually *much* faster than other methods. We do this for a 1GB Sybase database for one client on a nightly basis; takes

Re: [GENERAL] [pgsql-advocacy] Fwd: Favorite DB poll on ORA

ll. Either that, or they're cheating and using a 'bot. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] [pgsql-advocacy] New PostgreSQL search resource

lect distinct" but not for "distinct". Try searching on SELECT & DISTINCT -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[GENERAL] Potential Problem with PostgeSQL performance on SuSE Linux 9.0

. In my experience, this can be very bad news for databases under heavy multi-user load. I would suggest that anyone installing a SuSE 9.0 PostgreSQL server remove the Desktop pararmeter in the bootloader configuration. -- Josh Berkus Aglio Database Solutions San

[GENERAL] Need Italian Help!

basis, this week, it would be appreciated. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Commercial support?

Folks, > Josh Berkus <[EMAIL PROTECTED]> does PostgreSQL support, and he is in > SF. I am CC'ing him. What kind of support is requested? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7

  1   2   >