[GENERAL] Less than two weeks before PostgreSQL Conference: East

/ Talk: http://www.sun.com/ Talk: http://www.afilias.info Talk: http://www.xtuple.com/ Food: http://www.otg-nc.com/ General: http://www.myemma.com/ Facilities: http://www.umd.edu/ Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL

Re: [GENERAL] rpmbuild: command not found

. up2date install rpm-build I think. rpmbuild --rebuild --define 'buildrhel3 1' postgresql-8.2.6-1PGDG.f8.src.rpm However... you are missing a great deal more than rpmbuild if you think you are going to build 8.2.6 on RHEL3. Joshua D. Drake - -- The PostgreSQL Company since 1997: http

Re: [GENERAL] Which RHEL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 19 Mar 2008 16:40:30 -1000 Tri Quach [EMAIL PROTECTED] wrote: Hi All, I am not sure which RHEL is on my server. [EMAIL PROTECTED] pq8.2.6]# uname -a Linux lyris3.k12.hi.us 2.4.21-20.EL #1 SMP Wed Aug 18 20:34:58 EDT 2004 x86_64

Re: [GENERAL] Postgres development

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 20 Mar 2008 16:51:57 +1300 Brent Wood [EMAIL PROTECTED] wrote: Hi all, I'm interested in finding what would be involved on enhancing Postgres to allow queries run in one database in a cluster to access join with tables in other

Re: [GENERAL] postgre vs MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 17 Mar 2008 09:26:35 -0500 Erik Jones [EMAIL PROTECTED] wrote: While I agree companies are likely to get annoyed - just like fast food companies do when you say how much trans-fats their products contain; I'm rather curious what such a

Re: [GENERAL] PG secure for financial applications ...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 14 Mar 2008 02:00:39 -0600 Micah Yoder [EMAIL PROTECTED] wrote: Maybe it's nuts to consider such a setup (and if you're talking a major bank it probably is) ... and maybe not. At this point it's kind of a mental exercise. :-) If you

Re: [GENERAL] Recomendations on raid controllers raid 1+0

10. Use an actual LSI branded card instead of the Dell improved version. +1 Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http

Re: [GENERAL] postgre vs MySQL

don't see our name attached to large rollouts (even though you can see large rollouts attached to us.) Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL

Re: [GENERAL] postgre vs MySQL

permission. This has actually happened, where someone has asked to be removed from the list of those using PostgreSQL. Yes it has. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org

Re: [GENERAL] postgre vs MySQL

release of MySQL scared me. MySQL has incentives to _not_ make their community release production-quality. This thread is making my talk at MySQLCon very interesting. Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

On Wed, 12 Mar 2008 21:30:57 -0700 Scott Marlowe [EMAIL PROTECTED] wrote: You might want to keep this one on the list. I'm out of my league with this one I think Can you pg_dump the database? What about vacuum? What does: SELECT * FROM pg_database; Return? J On Wed, Mar 12, 2008 at

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

of the community just because it doesn't have PostgreSQL.org address. Tom with the utmost of respect, you are in this instance the most centered of the definition wrong I have seen. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL political pundit | Mocker of Dolphins -BEGIN PGP

What is the community, WAS: Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

to do with, PostgreSQL Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL political

Re: [GENERAL] PHPs PDO, apache and never ending sessions

for :). Glad we could help. Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

that you aren't following headline rules. Look here: http://www.commandprompt.com/blogs/ You will see short headlines of the blog, that is the part that is supposed to show up at planet. Not the whole blog. Sincerely, Joshua D. Drake }}} AND: {{{ On Fri, 7 Mar 2008 12:37:53 -0800 (PST) Lewis

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

there before taking action. I don't know why he didn't this time; I've posted to pgsql-www inquiring. Josh I invite you to see my reply on this. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

has rights as do I but Devrim is by far the BDFL on this. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

Feed Change Allow Blog Feeds to short Problem solved. You owe me a beer. I didn't have a blogger account until this argument. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http

Re: [GENERAL] PHPs PDO, apache and never ending sessions

on how you are connecting. For example if you are doing this: PDO::ATTR_PERSISTENT = true Then... yeah :). You really shouldn't use a language layer for persistent connections though. Use pgbouncer or pgpool. Joshua D. Drake Versions of products in question: apache2 2.2.8 (Unix) PHP 5.2.5

[GENERAL] PostgreSQL Conference East, only 3 weeks left

Emma http://www.myemma.com/ Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison

Re: [GENERAL] 8.2.6 8.3 blows up

this problem. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director

Re: [GENERAL] PostgreSQL Docs - Community Documentation

/servers Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL

Re: [GENERAL] Upgrade to 8.3.0?

On Sat, 1 Mar 2008 03:27:50 - Shane Wright [EMAIL PROTECTED] wrote: The RPMs installed from are these: postgresql-8.3.0-1PGDG.rhel4 postgresql-libs-8.3.0-1PGDG.rhel4 postgresql-server-8.3.0-1PGDG.rhel4 You need postgresql-debug (I think), Devrim? Joshua D. Drake Thanks

Re: [GENERAL] reindexing

the community are for. If companies want the community and not the companies surrounding the community to provide that kind of support, those companies need to start paying for it. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community

Re: [GENERAL] PostgreSQL's hashing function?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 22 Feb 2008 16:49:10 -0500 Kynn Jones [EMAIL PROTECTED] wrote: Hi! Does PostgreSQL expose its hash function? I need a fast way to hash a string to a short code using characters in the set [A-Za-z0-9_]. (I'm not sure yet how long this

Re: [GENERAL] Postgres 8.3 broke everything

forget the rest of your message? :) Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI

Re: [GENERAL] Postgres 8.3 broke everything

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 21 Feb 2008 19:49:29 -0500 Alex Turner [EMAIL PROTECTED] wrote: Yeah - I pressed tab to indent my code, and of course it tabbed to the next element on the page, which was the send button, then I hit a key, and it sent the message before I

[GENERAL] PostgreSQL Conference East: Talks announced

://www.continuent.org/ OTG: http://www.otg-nc.com/ Sun: http://www.sun.com/ Xtuple: http://www.xtuple.com/ Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

On Fri, 15 Feb 2008 11:59:19 +0800 hewei [EMAIL PROTECTED] wrote: Can send email from stored procedure in Postgres? Sure, see plperl. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org

Re: [GENERAL] postgresql book - practical or something newer?

this needs to go on and I will get back with you. Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI

Re: [GENERAL] POLL: Women-sized t-shirts for PostgreSQL

On Fri, 8 Feb 2008 21:48:39 -0300 Alvaro Herrera [EMAIL PROTECTED] wrote: Hmm, did this go anywhere? I still look for the shiny new Pg polos on the mail every day, only to be disappointed. Yes, they will be part of the larger run of shirts we do after SCALE. Joshua D. Drake

Re: [GENERAL] Is PG a moving target?

. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

Re: [GENERAL] postgresql book - practical or something newer?

be inappropriate to host a PostgreSQL documentation wiki on a shared host where the underlying database was *censored*. CMD will host anything you need. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http

Re: [GENERAL] postgresql book - practical or something newer?

year old book is more than relevant. Where Practical falls down is talking about things like background writer or vacuum. Those particular topics are covered ad-naseum in the docs. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference

Re: [GENERAL] PostgreSQL 8.3.0 RPMs are available for download

are welcome to switch to Fedora/RHEL/CentOS btw ;) Or a real linux like Ubuntu/Debian. Joshua D. Drake Regards, -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http

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

. Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit

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

already seen the solutions to issues well before I've encountered them. Right, I believe that is a valid argument. I think the real problem is that as a community we are not diligent in pushing people to the contextually specific lists we already have. Sincerely, Joshua D. Drake

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

On Mon, 04 Feb 2008 12:18:55 + Gregory Stark [EMAIL PROTECTED] wrote: Joshua D. Drake [EMAIL PROTECTED] writes: Guys, with respect this thread does nothing for us unless it is on the certification list. Do we really need a separate mailing list for every thread? It's already kind

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

on another topic and it seems to be what's happening now with this certification stuff. Sincerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http

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

in their Database Management competency https://partner.microsoft.com/global/40012911 Guys, with respect this thread does nothing for us unless it is on the certification list. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 9

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

they are provided. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Log file permissions?

to /var/log (on linux) but do have access to postgresql logs. Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL

Re: [GENERAL] Is PostGreSql's Data storage mechanism inferior?

of it ... the locking down of benefits reaped from OpenSource not getting back into the stream. RMS wouldn't make any such argument at all. His argument would be centered around FREE not OpenSource software. Joshua D. Drake Cheers, Andrej - -- The PostgreSQL Company since 1997: http

Re: [GENERAL] postgresql book - practical or something newer?

not a manual. In proper open source fashion perhaps you could start documenting the things you learn and post them to Techdocs :) Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate

Re: [GENERAL] postgresql book - practical or something newer?

to me said Bob. Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL

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

with SRA or the Venezualan folks but am more than happy to have them involved. Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http

[GENERAL] PostgreSQL Certification

information please visit: http://www.postgresqlcertification.org/ Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

Re: [GENERAL] Is PostGreSql's Data storage mechanism inferior?

provided via mailing lists. However there is no guarantee that the issue faced during PostgreSql hosting would be resolved. Say what? http://www.postgresql.org/support/professional_support Sincerely, Joshua D. Drake Thanks! - -- The PostgreSQL Company since 1997: http

Re: [GENERAL] MySQL [WAS: postgresql book...]

think he was apologizing to himself. After that much self inflicted pain, the inner psyche has to start to revolt. :P Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate

Re: [GENERAL] postgresql book - practical or something newer?

the terminology down you aren't going to find a more comprehensive text. Plus, when you find things that don't quite make sense you can submit a doc patch to make the docs that much better. Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com

Re: [GENERAL] postgresql book - practical or something newer?

. Something more along the lines of Lulu where the book can give the most use to the community. Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http

Re: [GENERAL] PGCon vs Postgresql Conference

talks we have. Anyway my suggestion to Sim is to read about each conference on the respective conference websites: http://www.postgresqlconference.org/why/ http://www.pgcon.org/2008/ Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support

Re: [GENERAL] OT - pg perl DBI question

thought last year was the year David started maintaining himself? Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL

Re: [GENERAL] PGCon vs Postgresql Conference

have to wait until the schedule and costs are posted before I'll know for sure). There is always PGday in July and August, plus West in October. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

[GENERAL] PostgreSQL 8.3 RC2 is now available!

PostgreSQL 8.3 RC2 is now available The community testing of RC1 has yielded positive results. We avoided several nasty bugs and are now releasing 8.3 RC2. We need the entire community to continue testing to help us get to the final release. Please report your bugs before the end of the month! .

[GENERAL] Only a week left for PostgreSQL Conference talk submissions

: http://www.sun.com Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM

Re: [GENERAL] postgres.org src build vs. enterprisedb installer

7.04). Then I suggest you use what the debian packager provides you. Check backports. Sincerely, Joshua D. Drake signature.asc Description: PGP signature

Re: [GENERAL] Sun acquires MySQL

(plpgsql vs plsql). Sincerely, Joshua D. Drake signature.asc Description: PGP signature

Re: [GENERAL] Sun acquires MySQL

On Sun, 20 Jan 2008 17:54:01 - Greg Sabino Mullane [EMAIL PROTECTED] wrote: Not sure how it could be any simpler... Simpler, no, but it could be a lot more intuitive. I think having psql recognize /^help/i would be a nice first step. Hmm, off to write a quick patch... +1 Joshua D

Re: [GENERAL] Sun acquires MySQL

a solution for that one. I think adding help to the psql prompt is a very sane way to help people. It is human. Sincerely, Joshua D. Drake Have a nice day, - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240

Re: [GENERAL] [OT] RAID controllers blocking one another?

, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD

Re: [GENERAL] Default_with_oids

suggest looking for a newer version of PgAccess... IIRC PgAccess is long dead. They really need to move to PgAdmin or OOBase or something like that. Joshua D. Drake regards, tom lane ---(end of broadcast)--- TIP 4: Have

Re: [GENERAL] Sun acquires MySQL

Russ Brown wrote: http://blogs.mysql.com/kaj/sun-acquires-mysql.html/ What does this mean for Sun's support of Postgres? Does it matter? :) I am sure OmniTI and Command Prompt will be happy to help any disgruntled customer :) Sincerely, Joshua D. Drake ---(end

Re: [GENERAL] Sun acquires MySQL

, Joshua D. Drake ---(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 the mailing list cleanly

Re: [GENERAL] Sun's PostgreSQL contribution?

dvanatta wrote: How much does Sun currently contribute to the project? Do they have designated coders? They employ a core member who is not a hacker. They provide some machines etc.. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 1

Re: [GENERAL] Sun's PostgreSQL contribution?

Alvaro Herrera wrote: Joshua D. Drake wrote: dvanatta wrote: How much does Sun currently contribute to the project? Do they have designated coders? They employ a core member who is not a hacker. They provide some machines etc.. They contributed a DTrace patch and the Sun hackers can

Re: [GENERAL] Sun acquires MySQL

employ more contributors than that (oh and just because they are core doesn't mean they have commit rights). They employ Dave Page and Bruce Momjian who are core members. They also employ Greg Stark and Heikki are very fairly visible contributors. Sincerely, Joshua D. Drake - -- The PostgreSQL

Re: [GENERAL] Sun acquires MySQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 16 Jan 2008 13:23:35 -0800 (PST) dvanatta [EMAIL PROTECTED] wrote: What's up with 3 of the 7 being from Pennsylvania? What's the connection? Its the closest the cult of the elephant will get to jersey. Joshua D. Drake

Re: [GENERAL] Sun acquires MySQL

for brilliant people. In fact, simply living in Pennsylvania makes you smarter. Then why did Ben Frankly attach a key to a kite in the middle of a thunderstorm? Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7

Re: [GENERAL] advocacy: drupal and PostgreSQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 16 Jan 2008 01:12:07 +0100 Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote: Hi, Among Drupal developer there is such kind of discussion over and over recently: http://drupal4hu.com/node/64 I commented here. I'd ask to all the people

Re: [GENERAL] advocacy: drupal and PostgreSQL

as well. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

that this issue is apparent actual row insertion it should be easy to duplicate. I will do some testing on my box which is similar. I have 2gig of ram, dual core and a raid 1 with SATA drives. Sincerely, Joshua D. Drake regards, tom lane

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 16 Jan 2008 00:29:16 -0500 Tom Lane [EMAIL PROTECTED] wrote: Joshua D. Drake [EMAIL PROTECTED] writes: If we are sure that this issue is apparent actual row insertion it should be easy to duplicate. I think you missed my point

[GENERAL] Registration for PostgreSQL Conference East now open

: http://www.otg-inc.com Sun: http://www.sun.com/ Remember all registrations are direct donations to the PostgreSQL Community! Sincerely, Joshua D. Drake PostgreSQL Conference Organizer PostgreSQL SPI Liaison - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support

Re: [GENERAL] Search connections created per day

a 1000 open at any given time though. Also take a look at connection pooling. Are there some table where i can search it? pg_stat_activity All users is connected in the database with postgres user. Sincerely, Joshua D. Drake Thanks. João Paulo Zavanela

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

and send the answer to b. There is a PostgreSQL project explicitly for this type of thing... dbi-link: http://pgfoundry.org/projects/dbi-link/ Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [GENERAL] 8.3 Beta Incompatible Data Disaster

beta1 Sincerely, Joshua D. Drake -- Mark Walker ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] How to query for a user-table column name?

| information_schema.sql_identifier | table_schema | information_schema.sql_identifier | table_name | information_schema.sql_identifier | column_name | information_schema.sql_identifier Sincerely, Joshua D. Drake Thanks in advance.. /Kevin

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

Ow Mun Heng wrote: On Tue, 2008-01-08 at 23:16 -0800, Joshua D. Drake wrote: Ow Mun Heng wrote: On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote: Another way of doing this, without dblink, is using an unsecured language (plpython, for example) is to connect to the sql server using odbc

Re: [GENERAL] Experiences with extensibility

are doing those items, you normally have a weird design anyway. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] count(*) and bad design was: Experiences with extensibility

can use pg_class. It isn't exact but is usually close enough (especially if you are just using it for something like pagination). Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate

Re: [GENERAL] Kernel kills postgres process - help need

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 09 Jan 2008 14:17:14 -0800 Jeff Davis [EMAIL PROTECTED] wrote: I posted to LKML here: http://kerneltrap.org/mailarchive/linux-kernel/2007/2/12/54202 because linux has a behavior -- which in my opinion is a bug -- that causes the OOM

Re: [GENERAL] vacuum, dead rows, usual solutions didn't help

in transaction, your vacuums are useless. You need to fix your app. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Query to get column-names in table via PG tables?

table_catalog=? AND table_schema=? AND table_name=? ORDER BY ordinal_position I need this to lookup the column names and their ordinal position for a given table (implementing a driver call). Just curious... but why is ordinal position important here? Joshua D. Drake Thanks in advance, Ken

Re: [GENERAL] Experiences with extensibility

extensibility features? There is no other open source database that can compare with PostgreSQL's extensibility, reliability and scalability. Joshua D. Drake ** Eric Davies, M.Sc. Barrodale Computing Services Ltd. Tel: (250) 472-4372 Fax: (250) 472-4373

Re: [GENERAL] Experiences with extensibility

Guido Neitzer wrote: On 08.01.2008, at 17:36, Joshua D. Drake wrote: 2. What types of extensibility (possibly already available in other DBMSs) are currently missing in PostgreSQL? None that I am aware of. Easy multi-master clustering with just two machines. That isn't really

Re: [GENERAL] Experiences with extensibility

Guido Neitzer wrote: On 08.01.2008, at 23:20, Joshua D. Drake wrote: That isn't really an extensibility argument. I was thinking about that too - for me, it still is just an outstanding issue with PostgreSQL. It is incredibly scalable on one machine but it totally sucks when you want more

Re: [GENERAL] Experiences with extensibility

Sim Zacks wrote: That isn't really an extensibility argument. At least not in my mind. Further I don't know of anyone that can easily do it. You either suffer the possibility of catastrophic data loss (dolphins) or you suffer guaranteed bank account drainage (Oracle), or you suffer the

Re: [GENERAL] Experiences with extensibility

Guido Neitzer wrote: On 08.01.2008, at 23:40, Joshua D. Drake wrote: There are OS level things you can do here. They are normally not really easier and, more important, I don't have them on my deployment environment. http://www.continuent.org/HomePage When I'm talking about two cheap

Re: [GENERAL] Connect to SQL Server via ODBC from Postgresql

to both PG and MSSQL. Perl or Python both would service this just fine or PHP (egads). Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings ---(end of broadcast

Re: [GENERAL] Experiences with extensibility

Ow Mun Heng wrote: On Tue, 2008-01-08 at 23:05 -0800, Joshua D. Drake wrote: Sim Zacks wrote: The reason companies go with the closed source, expensive solutions is because they are better products. Sometimes, sometimes not. It depends on your needs. This is total FUD. Everything has

Re: [GENERAL] Announcing PostgreSQL RPM Buildfarm

-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 announce PostgreSQL RPM Buildfarm today. This is very very very

Re: [GENERAL] Memory on 32bit machine

a dedicated firewall. Why not? Security in layers and all that. :) Certainly and iptables gives you some flexibility in connection availability before it hits the actual database but without having to jimmy the production firewall. Joshua D. Drake ---(end of broadcast

Re: [GENERAL] Memory on 32bit machine

Greg Smith wrote: On Mon, 7 Jan 2008, Joshua D. Drake wrote: Certainly and iptables gives you some flexibility in connection availability before it hits the actual database but without having to jimmy the production firewall. 4) Funky tricks with things like port forwarding and filtering

Re: [GENERAL] TCL

Glyn Astill wrote: Where can I ask about pg/tcl? What about it? ___ Support the World Aids Awareness campaign this month with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/ ---(end of

Re: [GENERAL] Getting process id of a connection?

, and kill it to test reconnection code. postgres=# select procpid from pg_stat_activity; procpid - - 30851 17510 4496 20237 1305 (5 rows) Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564

Re: [GENERAL] large table vacuum issues

curious... Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Need efficient way to do comparison with NULL as an option

but I think you get the idea) And then build out your where clause. That seems to do what I want. Is it bad design? Something I'm missing about indexing a NULL or something like that? Sincerely, Joshua D. Drake -- Dante ---(end of broadcast

Re: [GENERAL] basic questions: Postgres with yum on CentOS 5.1

. This might be more of a yum package question. LANG=en_US.UTF-8 initdb -D foo Should do it. Joshua D. Drake Thanks for your help, Chuck ---(end of broadcast)--- TIP 6: explain analyze is your friend - -- The PostgreSQL Company: Since

<    4   5   6   7   8   9   10   11   12   13   >