Search Discussions
-
Hi ! At present, I am using MySQL as backend for my work. Because of the licensing implications, I am considering to shift from MySQL to pgsql. Typically, my apps are multi-user, web based or LAN ...
Vineet Deodhar
Oct 10, 2012 at 8:48 am
Oct 15, 2012 at 8:04 am -
Hi, I have a table 'tmvt' with a field 'created' in the row, and would like to compute the difference between successive rows. The solution I found is: It is complicate and very long to perform. The ...
Ochaussavoine
Oct 20, 2012 at 10:54 am
Nov 23, 2012 at 11:03 pm -
Hi, - PG 9.0.10 - Pgbouncer version 1.4.2 Not long ago, during the last server reboot for us, we had fixed the really painful (and largely mysterious) process of setting up pgbouncer. File ...
Phoenix Kiula
Oct 1, 2012 at 10:26 am
Oct 8, 2012 at 8:06 am -
I have 2 cluster databases, running on the same host, Ubuntu. My fist database port is set to default but my second database port is set to 5433 in the postgresql.conf file. While everything is ok ...
GMAIL
Oct 19, 2012 at 1:03 pm
Oct 19, 2012 at 4:40 pm -
After reading the comments last week about SSDs, I did some testing of the ones we have at work - each of my test-boxes (three with SSDs, one with HDD) subjected to multiple stand-alone plug-pull ...
Chris Angelico
Oct 22, 2012 at 1:17 pm
Nov 8, 2012 at 1:40 am -
we are all aware of the popular trend of MMO games. where players face each other live. My area of concern, is storage of player moves and game results. Using Csharp and PostgreSql The game client is ...
Arvind Singh
Oct 13, 2012 at 11:53 am
Oct 27, 2012 at 8:46 pm -
Hi pgsql-general, I'm looking for advice on good training courses for PostgreSQL (on- or off-site, on- or off-line). I'm hoping to find something that can cover basic administration, performance ...
Matthew Kappel
Oct 16, 2012 at 3:24 pm
Nov 21, 2012 at 10:21 am -
Hi, I currently have a table that is growing very quickly - i.e 7 million records in 5 days. This table acts as a placeholder for statistics, and hence the records are merely inserted and never ...
Chitra Creta
Oct 12, 2012 at 2:44 pm
Nov 15, 2012 at 2:40 pm -
Hi Are there any best practices for avoiding database corruption? I suppose the most obvious one is to have a ups if it's a desktop machine. How do you detect corruption in a Postgresql database and ...
Heine Ferreira
Oct 13, 2012 at 9:53 pm
Oct 23, 2012 at 7:15 pm -
I am working on an audit logging trigger that gets called for every row inserted, updated or deleted on any table. For this, I need to store a couple of temporary session variables such as the ID of ...
Moshe Jacobson
Oct 1, 2012 at 1:36 pm
Oct 5, 2012 at 3:40 pm -
Hi, guys, Could anyone tell me how to specify the application_name as the log_line_prefix? According to the manual at ...
Tianyin Xu
Oct 29, 2012 at 5:18 am
Oct 30, 2012 at 12:34 am -
Hi Friends, We have our production environment database server in Postgres 8.3 version. we have planned to upgrade to lastest version 9.1. Dump from 8.3 and restore in Postgres 9.1 takes more than 5 ...
Vishalakshi Navaneethakrishnan
Oct 12, 2012 at 2:16 am
Oct 16, 2012 at 12:02 am -
I'm trying to build something (pljava, dont laugh) for IBM AIX (don't laugh). I have my own build of postgresql 9.1.6 on AIX, compiled with IBM XLC, it works quite nicely, but this build is ...
John R Pierce
Oct 9, 2012 at 6:59 am
Oct 10, 2012 at 2:03 am -
Hi everyone, We have two postgresql 9.0 databases (32-bits) with more than 10,000 schemas. When we try to run ANALYZE in those databases we get errors like this (after a few hours): 2012-09-14 ...
Hugo <Nabble>
Oct 1, 2012 at 7:52 pm
Oct 4, 2012 at 11:14 pm -
Here's the deal... Instead of architecting and loading a table like... create teble foo (col1 text, col2 text, col3 text, col4 text, col5 text); insert into foo (col1,col2,col3,col4,col5) values ...
Gauthier, Dave
Oct 23, 2012 at 6:53 pm
Oct 24, 2012 at 8:35 pm -
Greetings, I have a binary blog which is passed to a plpython function by a plpgsql function. plpython is used to create 2 different transformations of this binary blob to sets of postgresql type ...
Seref Arikan
Oct 8, 2012 at 8:15 pm
Oct 15, 2012 at 8:28 am -
Hey, So, I've searched around through the archives, and it seems this has come up a couple times in the past. But one scenario that was never explored was when using one .pgpass file in a cluster of ...
Shaun Thomas
Oct 1, 2012 at 3:32 pm
Oct 3, 2012 at 1:38 pm -
Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Mike
Mike Christensen
Oct 27, 2012 at 9:18 pm
Dec 6, 2012 at 7:15 pm -
Hi, I need to store large files (from several MB to 1GB) in Postgres database. The database has multiple schemas. It looks like Postgres has 2 options to store large objects: LOB and BYTEA. However ...
Tigran2-postgres
Oct 10, 2012 at 10:17 am
Oct 15, 2012 at 12:38 pm -
Hi all, I have been testing streaming replication in windows with postgres 9.1.1. For few scenario's I haven't found a solution. Please advice me. 1. Precautions before promoting standby server to ...
Chinnaobi
Oct 17, 2012 at 5:58 am
Oct 23, 2012 at 9:08 pm -
We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We're a team of developers with low expertise on database administration, so we ...
Daniel Serodio (lists)
Oct 8, 2012 at 8:39 pm
Oct 19, 2012 at 1:48 pm -
Hi all In this SO question: http://dba.stackexchange.com/questions/26905/how-do-i-implement-insert-if-not-found-for-transactions-at-serializable-isolatio/26909#26909 the author is running a series of ...
Craig Ringer
Oct 17, 2012 at 5:09 am
Oct 18, 2012 at 2:37 pm -
it's possible to access the same data from two different servers. the two servers have the same IP and not run simultaneously
GMAIL
Oct 17, 2012 at 1:21 pm
Oct 17, 2012 at 10:50 pm -
Hi We have an application which uses postgresql 7.4.5. Now when we moved to Java 1.6, we are seeing lots of jdbc driver related compilation issues like shown at end of this email. Question is can we ...
Swayam Prakash Vemuri
Oct 4, 2012 at 6:53 am
Oct 5, 2012 at 7:07 am -
I was just looking at http://www.postgresql.org/docs/devel/static/release-9-2.html and it mentioned that a dump/reload cycle was required to upgrade from a previous release. I just got done telling ...
Nikolas Everett
Oct 22, 2012 at 9:55 pm
Nov 24, 2012 at 5:49 pm -
Hi Guys, We have about 10 web applications deployed in a Tomcat 7.0 accessing a Postgresql 9.1 database. We do use connection pooling. We have the max_connections parameter set to 200 connections, ...
Rodrigo Pereira da Silva
Oct 29, 2012 at 7:30 pm
Oct 30, 2012 at 12:05 pm -
Dear all, When I try to use the command line tool shp2pgsql in the shell I have this error: Error: pg_wrapper: invalid command name I already read some information in the Debian lists but I don't ...
José Pedro Santos
Oct 26, 2012 at 1:16 pm
Oct 26, 2012 at 2:49 pm -
Our webhoster moved us to a 64Bit CentOS. I installed postgresql-9.1.3 from source. I run into trouble when trying to create the tablefunc extension b2blogin_mailrocket=# create extension tablefunc ...
Jan Mechtel
Oct 20, 2012 at 5:21 pm
Oct 21, 2012 at 5:00 am -
I have a pretty basic query; select distinct on (name) name, length(name) from drugs where customer_id IS NOT NULL order by name; which I'd expect to only return me a single drug name if there are ...
John Beynon
Oct 17, 2012 at 10:48 am
Oct 17, 2012 at 10:13 pm -
We are running Postgres 9.1.3, and after stopping it by physically shutting off the machine, we rebooted and now get this error whenever we try to start it. 2012-10-02 13:54:30 PDT LOG: database ...
Robert Sosinski
Oct 3, 2012 at 2:33 pm
Oct 9, 2012 at 7:38 am -
I've just installed PostgreSQL, using brew, on Mac OS Mountain Lion. The server doesn't start and the log file shows : $ cat /usr/local/var/postgres/server.log FATAL: could not create shared memory ...
Yvon Thoraval
Oct 7, 2012 at 1:30 pm
Oct 8, 2012 at 10:21 pm -
Greetings, I keep seeing statements like "Postgresql optimizer rewrites this query as...." What I'm curious about is, is there a way to obtain SQL form of the re-written queries somewhere in the ...
Seref Arikan
Oct 29, 2012 at 8:07 am
Oct 30, 2012 at 2:10 am -
Hello, I have a problem with query and index scan based on pg_trgm module. Here is few examples: First example is with equal: explain analyze SELECT * FROM table WHERE firstname = 'OLEG' AND ...
Condor
Oct 11, 2012 at 9:23 am
Oct 15, 2012 at 5:17 am -
Hi. I recently ran a query that generate the same error as this: SELECT * FROM generate_series(1,10) ORDER BY 'foo'; ERROR: non-integer constant in ORDER BY LINE 1: SELECT * FROM ...
Ken Tanzer
Oct 11, 2012 at 8:48 pm
Oct 13, 2012 at 9:31 am -
We are seeing a performance regression when moving to 9.2. There is a complex query that is doing a self-join, but long story short, it is choosing to use a multi-column index when it really ought ...
Greg Sabino Mullane
Oct 10, 2012 at 5:07 pm
Oct 11, 2012 at 3:42 am -
Hi, I need a *language unaware* text comparison algorithm, so i found pgtrgm. But i am not so content with it, because the similarities it finds are: - biased to favor text that is the same in the ...
Willy-Bas Loos
Oct 9, 2012 at 12:10 pm
Oct 10, 2012 at 8:15 am -
Hi, I am facing a problem when I try to install PostgresQL (version 9.2.1.). I get the following message: "Unable to write inside TEMP environment variable path" I need some help with this as I've ...
Raul Feliu
Oct 26, 2012 at 8:04 pm
Nov 21, 2012 at 10:01 am -
Hello, I've encountered an unexpected behavior when converting a number to char. I need to match an INTEGER with a VARCHAR(9) that has leading zeros. When I tried to match them using to_char(num, ...
Samuel Gilbert
Oct 26, 2012 at 6:50 pm
Nov 7, 2012 at 7:49 pm -
I'd like to avoid having to specify the unix socket directory when starting local instances of postgres, due to the new restrictions on the characters that can be in its path ...
Murray Cumming
Oct 25, 2012 at 11:40 am
Oct 25, 2012 at 11:26 pm -
Hi All, We have configured Streaming Replication b/w Primary and Standby server and Pgpool-II load balancing module diverting SELECT statements to Standby server. As per our observations, Standby ...
Raghu ram
Oct 19, 2012 at 8:40 am
Oct 23, 2012 at 5:58 am -
Hi pgsql-general, I'm interested in writing a supervisory process that can insure worker processes are running/spawn new ones if not. These workers will mainly be responsible for LISTENing to the db, ...
Rektide
Oct 15, 2012 at 4:11 pm
Oct 16, 2012 at 1:29 pm -
Hi there, here is something I don't quite grasp (PG 9.1.3): This function: CREATE OR REPLACE FUNCTION f_aliastest() RETURNS setof text AS $BODY$ declare sql text; begin sql:='SELECT ...
Maximilian Tyrtania
Oct 16, 2012 at 7:44 am
Oct 16, 2012 at 1:05 pm -
I was reading the documentation for pg_basebackup and it states that resulting backups "can be used both for point-in-time recovery and as the starting point for a log shipping or streaming ...
Daniel Serodio (lists)
Oct 15, 2012 at 8:15 pm
Oct 15, 2012 at 9:38 pm -
Hi there 1) Can a Pg/SQL function "listen" for a notification sent from an external instance? I would like my stored function to pause/wait and continue its execution once an external event (NOTIFY ...
P. Broennimann
Oct 15, 2012 at 12:54 pm
Oct 15, 2012 at 2:41 pm -
Is there any way to disable the guessing of missing columns in a group-by (the feature added in 9.1)? I haven't found any option but I might not be searching for the right thing ...
Evan D. Hoffman
Oct 11, 2012 at 3:03 pm
Oct 11, 2012 at 7:42 pm -
Hi all, first of all thanks for the great new "index only scan" feature in 9.2. We have managed to adapt our app (dhis2.org) to take advantage of it and it really speeds up several queries ...
Lars Helge Øverland
Oct 10, 2012 at 12:03 pm
Oct 11, 2012 at 10:52 am -
I wish to know regarding auto-increment field. I learn that the required table definition would be something like -- CREATE TABLE tablename ( colname SERIAL ); For more granular control over the size ...
Vineet Deodhar
Oct 11, 2012 at 7:04 am
Oct 11, 2012 at 9:35 am -
Master/slave replication, the master and slave both have full_page_writes disabled because the system is running on ZFS. While the master was still being setup and data was being loaded, the system ...
Sean Chittenden
Oct 6, 2012 at 5:32 pm
Oct 11, 2012 at 3:03 am -
Hi, If I run a CTE does that materialize the resulting data in the same (or a similar) way as if I created a temp table and referred to that instead? Or does the CTE keep the set in memory? Regards ...
Liam Caffrey
Oct 6, 2012 at 12:45 am
Oct 9, 2012 at 10:31 am -
Hi all. I'd like to tap into the list's experience regarding the job of a DBA in general and Pg DBA in particular. I see that most of the DBA job posts ask for Sr or Ssr which is understandable given ...
Thalis Kalfigkopoulos
Oct 4, 2012 at 8:45 pm
Oct 5, 2012 at 1:43 pm
Group Overview
group | pgsql-general |
categories | postgresql |
discussions | 167 |
posts | 841 |
users | 245 |
website | postgresql.org |
irc | #postgresql |
245 users for October 2012
Archives
- August 2013 (761)
- July 2013 (663)
- June 2013 (644)
- May 2013 (789)
- April 2013 (795)
- March 2013 (663)
- February 2013 (841)
- January 2013 (904)
- December 2012 (821)
- November 2012 (944)
- October 2012 (841)
- September 2012 (940)
- August 2012 (801)
- July 2012 (661)
- June 2012 (733)
- May 2012 (764)
- April 2012 (704)
- March 2012 (984)
- February 2012 (814)
- January 2012 (863)
- December 2011 (916)
- November 2011 (1,172)
- October 2011 (1,102)
- September 2011 (1,114)
- August 2011 (1,074)
- July 2011 (906)
- June 2011 (951)
- May 2011 (993)
- April 2011 (1,080)
- March 2011 (1,095)
- February 2011 (1,004)
- January 2011 (896)
- December 2010 (1,068)
- November 2010 (1,225)
- October 2010 (1,154)
- September 2010 (1,115)
- August 2010 (880)
- July 2010 (1,038)
- June 2010 (1,349)
- May 2010 (1,161)
- April 2010 (1,172)
- March 2010 (1,209)
- February 2010 (1,214)
- January 2010 (1,351)
- December 2009 (1,202)
- November 2009 (476)
- October 2009 (1,234)
- September 2009 (1,234)
- August 2009 (1,254)
- July 2009 (1,440)
- June 2009 (1,417)
- May 2009 (1,215)
- April 2009 (1,177)
- March 2009 (1,366)
- February 2009 (1,330)
- January 2009 (1,174)
- December 2008 (951)
- November 2008 (1,411)
- October 2008 (1,476)
- September 2008 (1,241)
- August 2008 (1,175)
- July 2008 (1,244)
- June 2008 (1,056)
- May 2008 (1,130)
- April 2008 (1,435)
- March 2008 (1,656)
- February 2008 (1,511)
- January 2008 (1,590)
- December 2007 (1,470)
- November 2007 (1,758)
- October 2007 (1,693)
- September 2007 (1,381)
- August 2007 (2,067)
- July 2007 (1,249)
- June 2007 (1,778)
- May 2007 (1,629)
- April 2007 (1,276)
- March 2007 (1,731)
- February 2007 (1,710)
- January 2007 (1,939)
- December 2006 (1,601)
- November 2006 (1,843)
- October 2006 (1,571)
- September 2006 (1,274)
- August 2006 (1,481)
- July 2006 (1,149)
- June 2006 (1,242)
- May 2006 (1,582)
- April 2006 (1,355)
- March 2006 (1,577)
- February 2006 (1,201)
- January 2006 (1,715)
- December 2005 (1,381)
- November 2005 (1,408)
- October 2005 (1,907)
- September 2005 (1,209)
- August 2005 (1,605)
- July 2005 (1,317)
- June 2005 (1,391)
- May 2005 (1,358)
- April 2005 (1,419)
- March 2005 (1,611)
- February 2005 (1,511)
- January 2005 (1,855)
- December 2004 (1,334)
- November 2004 (1,525)
- October 2004 (1,549)
- September 2004 (1,341)
- August 2004 (1,640)
- July 2004 (963)
- June 2004 (1,219)
- May 2004 (936)
- April 2004 (1,188)
- March 2004 (1,223)
- February 2004 (1,326)
- January 2004 (1,670)
- December 2003 (1,638)
- November 2003 (1,747)
- October 2003 (1,575)
- September 2003 (1,857)
- August 2003 (1,786)
- July 2003 (1,557)
- June 2003 (1,927)
- May 2003 (1,290)
- April 2003 (1,564)
- March 2003 (1,565)
- February 2003 (1,761)
- January 2003 (1,625)
- December 2002 (1,225)
- November 2002 (1,477)
- October 2002 (1,432)
- September 2002 (1,401)
- August 2002 (1,246)
- July 2002 (1,869)
- June 2002 (1,337)
- May 2002 (1,185)
- April 2002 (1,254)
- March 2002 (1,363)
- February 2002 (1,418)
- January 2002 (1,181)
- December 2001 (879)
- November 2001 (1,117)
- October 2001 (1,177)
- September 2001 (1,213)
- August 2001 (1,270)
- July 2001 (1,316)
- June 2001 (1,630)
- May 2001 (1,677)
- April 2001 (16)
- March 2001 (1,633)
- February 2001 (1,597)
- January 2001 (1,668)
- December 2000 (1,001)
- November 2000 (1,067)
- October 2000 (1,304)
- September 2000 (992)
- August 2000 (846)
- July 2000 (1,145)
- June 2000 (797)
- May 2000 (832)
- April 2000 (695)
- March 2000 (220)
- February 2000 (478)
- January 2000 (656)
- December 1999 (643)
- November 1999 (506)
- October 1999 (622)
- September 1999 (384)
- August 1999 (494)
- July 1999 (406)
- June 1999 (462)
- May 1999 (405)
- April 1999 (328)
- March 1999 (382)
- February 1999 (360)
- January 1999 (295)
- December 1998 (239)
- November 1998 (266)
- October 1998 (278)
- September 1998 (185)
- August 1998 (224)
- July 1998 (432)
- June 1998 (352)
- May 1998 (134)