Re: [GENERAL] Scripts to build the various debian packages from postgresql source

2013-12-16 Thread imagene...@gmail.com
http://www.debian.org/doc/manuals/maint-guide/build.en.html Resolved. On Mon, Dec 16, 2013 at 3:53 PM, imagene...@gmail.com wrote: > Typo of course: > > $ver=9.3 > $type=main > ./configure --prefix=/usr/lib/postgresql/$ver/ > --datarootdir=/usr/share/postgresql/$ver > --sysconfdir=/etc/postgresq

Re: [GENERAL] Scripts to build the various debian packages from postgresql source

2013-12-16 Thread imagene...@gmail.com
Typo of course: $ver=9.3 $type=main ./configure --prefix=/usr/lib/postgresql/$ver/ --datarootdir=/usr/share/postgresql/$ver --sysconfdir=/etc/postgresql/$ver/$type On Mon, Dec 16, 2013 at 3:47 PM, imagene...@gmail.com wrote: > I would like to build from source, however I would like to integrate

[GENERAL] Scripts to build the various debian packages from postgresql source

2013-12-16 Thread imagene...@gmail.com
I would like to build from source, however I would like to integrate with the scripts included in the ubuntu packages from https://wiki.postgresql.org/wiki/Apt. Where are the scripts that are used to build the various relevant packages from presumably these postgresql sources: http://www.postgresq

Re: [GENERAL] pg_stat_tmp

2013-12-16 Thread Jeff Janes
On Mon, Dec 16, 2013 at 5:57 AM, Tim Kane wrote: > Hi all, > > The past few days I’ve been encountering the following error, followed by > a full db restart and recovery > > > 2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file > "pg_stat_tmp/pgstat.tmp": No space left on devi

Re: [GENERAL] Grouping, Aggregate, Min, Max

2013-12-16 Thread Misa Simic
2013/12/13 Kevin Grittner > Misa Simic wrote: > > > So I wonder - is there some kind of aggregate window function > > what does desired results? > > Not built in, but PostgreSQL makes it pretty easy to do so. With a > little effort to define your own aggregate function, your query can > look li

Re: [GENERAL] replacing expresion in plpgsql

2013-12-16 Thread Merlin Moncure
On Mon, Dec 16, 2013 at 2:08 AM, John R Pierce wrote: > On 12/15/2013 10:54 PM, Thomas Kellerer wrote: >> >> Both are valid. interval '2' day is the ANSI SQL format though. > > > oh, really! ah, I stand corrected, didn't realize the units were valid > keywords like that. Me neither. Stuff lik

Re: [GENERAL] pg_stat_tmp

2013-12-16 Thread Magnus Hagander
On Mon, Dec 16, 2013 at 2:57 PM, Tim Kane wrote: > Hi all, > > The past few days I’ve been encountering the following error, followed by > a full db restart and recovery > > > 2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file > "pg_stat_tmp/pgstat.tmp": No space left on devi

[GENERAL] pg_stat_tmp

2013-12-16 Thread Tim Kane
Hi all, The past few days I’ve been encountering the following error, followed by a full db restart and recovery 2013-12-16 07:12:53 GMT LOG: could not write temporary statistics file "pg_stat_tmp/pgstat.tmp": No space left on device This occurs at a time of moderate load, during the same set

Re: [GENERAL] Constantly increasing per connection memory usage on pg 9.2

2013-12-16 Thread Tom Lane
Eliott writes: > So, can anybody confirm that is is normal for a 9.2 based server > connection to take up 10 times the connection specific memory that 8.3 > used to need? I'm sure there's been some bloat over time, but I can't offhand think of a reason for it to be 10X more than 8.3 was. You m

Re: [GENERAL] Constantly increasing per connection memory usage on pg 9.2

2013-12-16 Thread Eliott
Hi! I'd like to revisit this issue. What we have noticed that the amount of memory increase does not really depend on the number of large queries, but the number of queries in general. So, can anybody confirm that is is normal for a 9.2 based server connection to take up 10 times the connect

Re: [GENERAL] pg_dump behaves differently for different archive formats

2013-12-16 Thread Tom Lane
Albe Laurenz writes: > Restoring a "plain format" dump and a "custom format" dump of > the same database can lead to different results: > pg_dump organizes the SQL statements it creates in "TOC entries". > If a custom format dump is restored with pg_restore, all > SQL statements in a TOC entry wi

[GENERAL] pg_dump behaves differently for different archive formats

2013-12-16 Thread Albe Laurenz
Restoring a "plain format" dump and a "custom format" dump of the same database can lead to different results: pg_dump organizes the SQL statements it creates in "TOC entries". If a custom format dump is restored with pg_restore, all SQL statements in a TOC entry will be executed as a single comma

Re: [GENERAL] Some good news ([i...@arin.net: [arin-announce] ARIN Database Migration Completed])

2013-12-16 Thread Vincent Veyron
Le dimanche 15 décembre 2013 à 10:57 -0500, Andrew Sullivan a écrit : > I thought people'd like to know about this. Potential submission material for HackerNews maybe? I'm not seeing it there https://news.ycombinator.com/news -- Regards, Vincent Veyro

Re: [GENERAL] replacing expresion in plpgsql

2013-12-16 Thread John R Pierce
On 12/15/2013 10:54 PM, Thomas Kellerer wrote: Both are valid. interval '2' day is the ANSI SQL format though. oh, really! ah, I stand corrected, didn't realize the units were valid keywords like that. -- john r pierce 37N 122W somewhere on the middle