Re: [GENERAL] Postgres 9.3 beta log

On 08/10/2013 04:21 PM, Bruce Momjian wrote: > On Sat, Aug 10, 2013 at 06:38:57AM +, Arvind Singh wrote: >> as you can see it is for a single record "login88193" it places >> >> PARSER STATISTICS >> PARSE ANALYSIS STATISTICS >> REWRITER STATISTICS >> >> I know it appers because i have enabled l

Re: [GENERAL] Roadmap for Postgres on AIX

On 04/17/2013 07:45 PM, Thomas Munro wrote: > On 19 March 2013 01:00, Tom Lane > wrote: > > Wasim Arif mailto:wasima...@gmail.com>> writes: > > What is the road map for Postgres on the AIX platform? I > understand that > > the pg build farm contains an A

Re: [GENERAL] What's wrong with postgresql.org domain?

On 04/18/2013 01:08 PM, Eduardo Morras wrote: > On Thu, 18 Apr 2013 20:35:37 +1000 > Chris Angelico wrote: > >> That one's clearly fine. What about www.postgresql.org? It's possible >> you have a poisoned cache for just that one record. >> >> ChrisA > > I have clean all (dns, web cache, etc) and

Re: [GENERAL] "Too far out of the mainstream"

On 09/01/2012 01:24 PM, Peter Bex wrote: > On Sat, Sep 01, 2012 at 12:43:15AM +0200, Geert Mak wrote: >> There is this case studies section as well - >> >> http://www.postgresql.org/about/casestudies/ >> >> Which appear to me a little old and a little too little, one could try to >> add more, perh

Re: [GENERAL] "Need some information about postgresql products and community"

On 08/28/2012 04:47 PM, Merlin Moncure wrote: > On Tue, Aug 28, 2012 at 9:29 AM, mithun > wrote: >> Dear Sir, >> >> We are gathering information regarding PostgreSQL open source product >> quality and its community. Can you kindly help me to find following data. > > Your questions are incredibl

Re: [GENERAL] NASA needs Postgres - Nagios help

On 07/13/2010 10:44 PM, Thom Brown wrote: On 13 July 2010 21:25, Magnus Hagander wrote: On Tue, Jul 13, 2010 at 20:10, Thom Brown wrote: On 13 July 2010 17:14, Duncavage, Daniel P. (JSC-OD211) wrote: We are implementing Nagios on Space Station and want to use PostgreSQL to store the data o

Re: [GENERAL] NASA needs Postgres - Nagios help

Duncavage, Daniel P. (JSC-OD211) wrote: We are implementing Nagios on Space Station and want to use PostgreSQL to store the data on orbit and then replicate that db on the ground. The problem is, most people use MySQL with Nagios. We need an addon to ingest Nagios data into PostgreSQL. It lo

Re: [GENERAL] An issue with max() and order by ... limit 1 in postgresql8.3-beta3

Andreas Kretschmer wrote: zxo102 ouyang wrote: Hi everyone, I am using postgresql 8.3-beta3. I have a table 'test' with three fields: I'm guessing you mean 8.4-beta3, right? either of those are unsuitable for any kind of production use... Stefan -- Sent via pgsql-general mailing lis

Re: [GENERAL] schema proxying virtual database

Rajesh Kumar Mallah wrote: Dear List, There are many opensource applications that support postgresql (eg , gforge , bricolage , dspam ..) but does not use schemas(namespaces) as a result of which you are forced to use/create a new database and loose the advantage of linking the application dat

Re: [GENERAL] FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4

Tom Lane wrote: "Todd A. Cook" writes: First, the numbers: PG VersionLoad time pg_database_size autovac -- 8.2.13179 min 92,807,992,820on 8.3.7 180 min 84,048,744,044on (de

Re: [GENERAL] Switching databases over JDBC/ODBC

Scott Bailey wrote: John R Pierce wrote: Scott Bailey wrote: Well at work we've got Oracle, MySQL, MS SQL and Postgres. So I generally use Aqua Data Studio because it works with all of them. For MySQL and MS SQL you register a single connection to the server and can switch to any database. Bu

Re: [GENERAL] Server Performance

chris.el...@shropshire.gov.uk wrote: Stefan Kaltenbrunner wrote on 01/04/2009 06:53:07: > chris.el...@shropshire.gov.uk wrote: > > > > Scott Marlowe wrote on 31/03/2009 15:53:34: > > > > > On Tue, Mar 31, 2009 at 8:21 AM, wrote: > > > &g

Re: [GENERAL] Server Performance

chris.el...@shropshire.gov.uk wrote: Scott Marlowe wrote on 31/03/2009 15:53:34: > On Tue, Mar 31, 2009 at 8:21 AM, wrote: > > > > Scott Marlowe wrote on 31/03/2009 15:16:01: > > > >> I'd call IBM and ask them to come pick up their boat anchors. > > > > My sentiments exactly, unfortu

Re: [GENERAL] problem with locale :

Eugenio Modesti wrote: Hello, i received a copy of a postgresql data directory and i need to read it (and do a regular dump). the datadir version is 8.1 so i installed that version of the server. When trying to start the server i got this: Error: The server must be started under the locale : wh

Re: [GENERAL] Maximum transaction rate

Scott Marlowe wrote: On Mon, Mar 16, 2009 at 2:03 PM, Stefan Kaltenbrunner wrote: So in my understanding LVM is safe on disks that have write cache disabled or "behave" as one (like a controller with a battery backed cache). For storage with write caches it seems to be unsafe, e

Re: [GENERAL] deployment query

Nagalingam, Karthikeyan wrote: Hi, we are in the process of finding the best solution for Postgresql deployment with storage controller. I have some query, Please give some suggestion for the below 1) Can we get customer deployment scenarios for postgresql with storage controller. Any fl

Re: [GENERAL] Maximum transaction rate

Tom Lane wrote: Jack Orenstein writes: The transaction rates I'm getting seem way too high: 2800-2900 with one thread, 5000-7000 with ten threads. I'm guessing that writes aren't really reaching the disk. Can someone suggest how to figure out where, below postgres, someone is lying about writes

Re: [GENERAL] Postgres Cookbook

Raymond O'Donnell wrote: On 07/03/2009 05:50, Artacus wrote: Stefan Kaltenbrunner wrote: Tino Wildenhain wrote: what about a cookbook section on the main wiki? That would be great. Who do we need to talk to for that? AFAIK that once you register a community account you can just go ahea

Re: [GENERAL] Postgres Cookbook

Tino Wildenhain wrote: Greg Smith wrote: On Wed, 4 Mar 2009, Artacus wrote: So it looks like at one time we had a cookbook. But the links are dead now. I'm not sure why Roberto Mello stopped hosting that, but you can see the last content posted there at http://web.archive.org/web/200312070

Re: [GENERAL] RCA for MemoryContextAlloc: invalid request size(Known Issue)

Yogvinder Singh wrote: What I am looking for is the version in which this problem has been resolved. I can't find it anywhere in the documentation. well there was by far not enough information in your original mail(not even the exact version you are on) to even verify that this is a data cor

Re: [GENERAL] Postgres mail list traffic over time

Alvaro Herrera wrote: Sam Mason wrote: the following has links to more: http://markmail.org/search/?q=list:org.postgresql Wow, the spanish list is the 3rd in traffic after hackers and general! yeah and that tom lane guy sent over 77000(!!!) mails to the lists up to now ... Stefan --

Re: [GENERAL] DUPS in tables columns ERROR: column ". . . " does not exist

Albretch Mueller wrote: Hi, ~ I am trying to get dups from some data from files which md5sums I previously calculated ~ Here is my mere mortal SQL ~ SELECT md5, COUNT(md5) AS md5cnt FROM jdk1_6_0_07_txtfls_md5 WHERE (md5cnt > 1) GROUP BY md5 ORDER BY md5cnt DESC; I think you are looking for

Re: [GENERAL] [Q] DNS(bind) ER model

Andrew Sullivan wrote: On Fri, Aug 15, 2008 at 09:54:26PM +0200, Tino Wildenhain wrote: looks like you want to write your own "powerdns" ? :-) http://www.powerdns.com/ Oh, right, I forgot they use a SQL back end. They do EDNS0, too :) (Note, however, that if you plan to deploy DNSSEC you're

Re: [GENERAL] Initdb problem on debian mips cobalt: Bus error

Glyn Astill wrote: http://privatepaste.com/cbY2S4JhtA Very little difference with the -O0 FWIW: there also seems to be a fairly indepth discussion on the cobalt related netbsd list from last year about a problem that looks very similiar (at least to you issue with etch): http://www.nabble

Re: [GENERAL] Initdb problem on debian mips cobalt: Bus error

Tom Lane wrote: Glyn Astill <[EMAIL PROTECTED]> writes: No. Will recompile with debug info and post back when done. FWIW, the most likely issue here is the MIPS-specific assembly code in src/include/storage/s_lock.h --- I'm not sure how many MIPS platforms that's really been exercised on, but

Re: [GENERAL] Mediawiki 1.10 and PG 8.3 upgrade

Jon Lapham wrote: Hello all, I'm sure I did something wrong during my upgrade of mediawiki from Postgresql 8.2 to 8.3. Any help on how to recover would be appreciated. [...] I would like to say thanks to the people that put in so much time and effort in developing tsearch2 (and postgresql

Re: [GENERAL] page is uninitialized --- fixing

Tom Lane wrote: This is not entirely out of the question, because of the designed-in property that a freshly initialized page is only inserted into by the backend that got it --- no one else will know there is any free space in it until VACUUM first passes over it. So if there are a lot of diff

Re: [GENERAL] Getting all tables into memory

Robert Fitzpatrick wrote: I have a couple of servers running Postfix with amavisd-maia+SA+clamav on FreeBSD 6.2 which use a central db server running PgSQL 8.2.4. My issue is the bayes database causing SA TIMED OUT in the logs and want to make sure I am getting everything into memory. The disk ac

Re: [GENERAL] Error while compiling PostgreSQL with Java

Никоноров Григорий wrote: > Hi Kris > > Thanks for your answer.When i download this "JDBC4 Postgresql Driver, > Version 8.2-506" driver what should i do next to configure PostgreSQL > with it ? there is nothing you need on the backend side (except for maybe setting up authentication as with every

Re: [GENERAL] Read-only availability of a standby server?

Garber, Mikhail wrote: > In the high-availabilty situation with a warm standby, is it possible (or > planned) to be able to make standby readable? > This is a new feature in Oracle 11 and it is very important for a project I > am working on. yeah there are plans to support this in 8.4 (and some

Re: [GENERAL] Postgresql performance in production environment

Phoenix Kiula wrote: > On 19/08/07, Phoenix Kiula <[EMAIL PROTECTED]> wrote: [... ] > Well based on some past posts, I looked into my pg_log stuff and found > a number of these lines: > > > [ > LOG: could not fork new process for connection: Resource temporarily > unavailable >

Re: [GENERAL] [pgsql-advocacy] European users mailing list

Robert Treat wrote: > On Monday 30 July 2007 03:47, Dave Page wrote: >> Joshua D. Drake wrote: >>> Peter Eisentraut wrote: Dave Page wrote: > As discussed at the first meeting of what will become the European > PostgreSQL Users Group after pgDay in Prato, we now have a mailing > li

Re: [GENERAL] createing indexes on large tables and int8

Tom Lane wrote: > Janning Vygen <[EMAIL PROTECTED]> writes: >> After this i create the index and it took 10 hours just for one index >> (primary >> key). I have 100.000.000 rows with one PK (int8), two integer data values, >> and two FK (int8) > > What PG version is this? We did a fair amount

Re: [GENERAL] Limit number connections by IP

tabai wrote: > Hi > > I know that i can limited the total number of connections in > postgresql.conf with max_connections, but... can i limite the max > number of connections from an specific IP? > > For example y like have total max connections of 40 buy the same ip > can't have more than 5 con

Re: [GENERAL] Limit connections per username

Nik wrote: > PostgreSQL 8.2 on Windows 2003 Server. > > Is it possible to limit number of connections per username? yes - look for CONNECTION LIMIT on: http://www.postgresql.org/docs/8.2/static/sql-createrole.html and http://www.postgresql.org/docs/8.2/static/sql-alterrole.html Stefan ---

Re: [GENERAL] pointer to feature comparisons, please

Kevin Hunter wrote: > At 3:26p -0400 on 13 Jun 2007, Stefan Kaltenbrunner wrote: >>> The way that I currently know how to do this in Postgres is with >>> PLpgSQL functions. Then I add something like >>> >>> CONSTRAINT away_team_is_playing CHECK ( NO

Re: [GENERAL] pointer to feature comparisons, please

Kevin Hunter wrote: [...] > I originally had him code his project for Postgres, but for reasons > beyond our control we've had to move to Oracle. In designing the schema > we have need of a constraint that checks values in other tables. The > way that I currently know how to do this in Postgres

Re: [GENERAL] why postgresql over other RDBMS

Tom Lane wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes: >> Tom Lane wrote: >>> A more interesting question is what sort of hardware you need for that >>> actually to be a win, though. Loading a few tables in parallel sounds >>> like an

Re: [GENERAL] why postgresql over other RDBMS

Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: >> Erik Jones wrote: >>> And, to finish up, is there any reason that pg_restore couldn't >>> already work with separate processes working in parallel? > >> The problem is that the ordering of objects in the dump is the only >> thing th

Re: [GENERAL] Technical Documentation and Community Login

Magnus Hagander wrote: > Guy Rouillier wrote: >> George Weaver wrote: >>> Original Message From Guy Rouillier >>> http://www.postgresql.org/docs/techdocs.71. Color me dumb, but I can't figure a way to download the document "Apache 2.0, Tomcat 5.5, WARs & PostgreSQL 8.1 JDBC DataSour

Re: [GENERAL] unexpected data beyond EOF and character encoding

Jaime Silvela wrote: > I completed another migration from 8.1.3 to 8.2.3, and again the problem > with "unexpected data beyond EOF", exactly twice like before, but in two > tables different from the last time. > The kernel bug hypothesis seems a strong one. I told Unix Ops about the > possible bug,

Re: [GENERAL] real multi-master replication?

Bill Moran wrote: > Stefan Kaltenbrunner <[EMAIL PROTECTED]> wrote: >> Bill Moran wrote: >>> "hubert depesz lubaczewski" <[EMAIL PROTECTED]> wrote: >>>> hi, >>>> i read about some replication system for postgresql, but - as far as i

Re: [GENERAL] real multi-master replication?

Bill Moran wrote: > "hubert depesz lubaczewski" <[EMAIL PROTECTED]> wrote: >> hi, >> i read about some replication system for postgresql, but - as far as i >> know there is none real multi-master replication system for >> postgresql. >> all i have seen are based on "query replication" with various

Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5

Jim Rosenberg wrote: > --On Saturday, March 3, 2007 11:24 PM -0500 Tom Lane <[EMAIL PROTECTED]> > wrote: > >>> I am trying to build PostgreSQL 8.2.3 on OpenBSD 4.0. When I give the >>> command >> >>> ./configure -v --with-openssl --with-krb5 >>> --with-includes=/usr/include/kerberosV >> >>> I get:

Re: [GENERAL] Out of memory on vacuum analyze

Jim Nasby wrote: > On Feb 19, 2007, at 1:19 PM, Jeff Davis wrote: >> You told PostgreSQL that you have 900MB available for >> maintenance_work_mem, but your OS is denying the request. Try *lowering* >> that setting to something that your OS will allow. That seems like an >> awfully high setting to

Re: [GENERAL] Warning "TupleDesc reference leak"

Marek Lewczuk wrote: > Hello, > after upgrade to 8.2 version, PostgreSQL throws following warnings: > WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1) > still referenced > WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1) > still referenced > WARNING: TupleDesc

Re: [GENERAL] [HACKERS] getting status transaction error

Merlin Moncure wrote: > On 2/6/07, Merlin Moncure <[EMAIL PROTECTED]> wrote: >> around 6:30 this morning, I started getting the following messages in >> my log: >> >> Feb 6 06:33:34 mojo postgres[1117]: [2-1] :: ERROR: could not access >> status of transaction 51911 >> Feb 6 06:34:35 mojo po

Re: [GENERAL] Index bloat of 4x

Tom Lane wrote: > Bill Moran <[EMAIL PROTECTED]> writes: >> The entire database was around 28M prior to the upgrades, etc. Immediately >> after the upgrades, it was ~270M. Following a vacuum full, it dropped to >> 165M. Following a database-wide reindex, it dropped to 30M. > > As Alvaro said, v

Re: [GENERAL] Reducing pg_dump & pg_restore times

Ron Johnson wrote: > On 10/26/06 01:20, Chris wrote: >>> Coder At Heart wrote: Hi! Restore & backup take time in the tune of 6 hrs on a Linux, 4 proc, 32 G RAM machine for a 60GB database. >>> Please always cc the mailing list. >>> >>> I've never played with databases that lar

Re: [GENERAL] Majordomo drops multi-line Subject:

Michelle Konzack wrote: > Hello Marc, > > Am 2006-09-09 12:50:36, schrieb Marc G. Fournier: > >> And I missed this one from Joshua ... but, we aren't running Majordomo >> from GreatCircle, we are running Majordomo2 (http://www.mj2.org) which is >> very much being actively support ... > > I hav

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

Martijn van Oosterhout wrote: > On Fri, Sep 01, 2006 at 12:40:53PM +0200, Stefan Kaltenbrunner wrote: >> heh if this is a request for a wishlist then I would suggest that we >> should finally tackle one of the things most databases are doing better >> then we (including My

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

Alvaro Herrera wrote: Bruce Momjian wrote: Tom Lane wrote: It's pointless to suppose that individual developers would really be answerable to any project-wide management, since that's not who they're paid by. So I tend to think that a project roadmap would be more of an exercise in wishful t

Re: [GENERAL] Cutting the Gborg throat

Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Wieck Sent: 31 August 2006 13:59 To: Joshua D. Drake Cc: Dave Cramer; Greg Sabino Mullane; pgsql-general@postgresql.org Subject: Re: [GENERAL] Cutting the Gborg throat On 8/28/2006

Re: [GENERAL] undefined reference to `PQprepare' with postgresql-dev

Alexander Farber wrote: > Hello, > > I'm trying to compile a libpq program under Debian 3.1r2 with these > packages installed: > > $ dpkg -l | grep postgres > ii postgresql 7.4.7-6sarge2 object-relational SQL database > management sy > ii postgresql-cli 7.4.7-6sarge2 front-end programs fo

Re: [GENERAL] Postgres on 64bit Windows Server with WOW64

Joshua D. Drake wrote: > Mont Rothstein wrote: >> I wouldn't know that one way or the other :-) >> >> I was referring to Windows on Windows >> 64 >> . >> >> Enables 32bit apps to run on 64bit Windows OSs, in case anyone wasn't >> familiar with it (I wasn't until

Re: [GENERAL] Backslash as ordinary char vs. not; set via a connection/session

Ken Johanson wrote: > Stefan Kaltenbrunner wrote: > >> >> postgresql can do that in an even more powerful way - but people tend to >> not notice much of it in your case that would be: >> >> ALTER ROLE foo SET standard_conforming_strings='off

Re: [GENERAL] Backslash as ordinary char vs. not; set via a connection/session

Ken Johanson wrote: > Tom and folks, > > Will it be possible to set this more standard backslash handling > behavior -- and possibly similar conformance modes... in a way similar > to how mysql allows? They allow one to issue commands on the connection > like: > > SET SESSION sql_mode = 'NO_BACKS

Re: [GENERAL] pgsql vs mysql

Jan Wieck wrote: > On 7/11/2006 1:08 PM, Scott Marlowe wrote: > >> On Tue, 2006-07-11 at 11:04, Jan Wieck wrote: >>> On 6/30/2006 1:07 PM, Merlin Moncure wrote: >>> >>> > * mysql has a few features here and there which are nice...just to >>> > name a few, flush tables with lock, multiple insert, e