FAQ

Search Discussions

167 discussions - 841 posts

  • 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 DeodharVineet 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 ...
    OchaussavoineOchaussavoine
    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 KiulaPhoenix 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 ...
    GMAILGMAIL
    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 AngelicoChris 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 SinghArvind 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 KappelMatthew 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 CretaChitra 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 FerreiraHeine 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 JacobsonMoshe 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 XuTianyin 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 NavaneethakrishnanVishalakshi 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 PierceJohn 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>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, DaveGauthier, 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 ArikanSeref 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 ThomasShaun 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 ChristensenMike 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-postgresTigran2-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 ...
    ChinnaobiChinnaobi
    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)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 RingerCraig 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
    GMAILGMAIL
    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 VemuriSwayam 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 EverettNikolas 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 SilvaRodrigo 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 SantosJosé 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 MechtelJan 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 BeynonJohn 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 SosinskiRobert 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 ThoravalYvon 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 ArikanSeref 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 ...
    CondorCondor
    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 TanzerKen 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 MullaneGreg 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 LoosWilly-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 FeliuRaul 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 GilbertSamuel 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 CummingMurray 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 ramRaghu 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, ...
    RektideRektide
    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 TyrtaniaMaximilian 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)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. BroennimannP. 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. HoffmanEvan 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 ØverlandLars 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 DeodharVineet 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 ChittendenSean 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 CaffreyLiam 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 KalfigkopoulosThalis Kalfigkopoulos
    Oct 4, 2012 at 8:45 pm
    Oct 5, 2012 at 1:43 pm
Group Navigation
period‹ prev | Oct 2012 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions167
posts841
users245
websitepostgresql.org
irc#postgresql

245 users for October 2012

Tom Lane: 59 posts Craig Ringer: 42 posts John R Pierce: 28 posts Albe Laurenz: 23 posts Chris Angelico: 21 posts David Johnston: 19 posts Merlin Moncure: 18 posts Shaun Thomas: 18 posts Jeff Janes: 14 posts GMAIL: 13 posts Jasen Betts: 13 posts Scott Marlowe: 13 posts Chris Travers: 12 posts Moshe Jacobson: 10 posts Adrian Klaver: 9 posts Bruce Momjian: 9 posts Gavin Flower: 9 posts Phoenix Kiula: 9 posts Raymond O'Donnell: 9 posts Thalis Kalfigkopoulos: 9 posts
show more
Archives