FAQ

PostgreSQL > pgsql-general > July 2011

Search Discussions

168 discussions - 906 posts

  • I've been following a few blogs (http://database-programmer.blogspot.com/, http://thehelsinkideclaration.blogspot.com/) that make a very compelling argument, in my opinion, to move as much ...
    Karl NackKarl Nack
    Jul 22, 2011 at 7:21 pm
    Jul 28, 2011 at 4:54 am
  • I was doing postgresql streaming replication, which was fine when two machine in the same datecenter. but recently I was planning to deploy new slave at a different datecent, the latency between the ...
    Yan ChunluYan Chunlu
    Jul 23, 2011 at 12:50 pm
    Jul 25, 2011 at 6:08 pm
  • Hi, The configuration information is listed at the end. I met this problem last weekend. The presentation was that, the db locks became enormous, up to 8.3k, and the db hanged there. About half an ...
    Tony WangTony Wang
    Jul 12, 2011 at 4:53 pm
    Jul 15, 2011 at 1:38 pm
  • I have a function that creates a temp table, populate it with results during intermediate processing, and reads from it at the end. When the transaction is marked as read only, it does not allow ...
    Mike beeperMike beeper
    Jul 7, 2011 at 4:01 pm
    Jul 12, 2011 at 10:12 am
  • I am having problems importing a CSV file of sample data for testing in a web app. Columns & Types ------------------- zip_code - text lattitude - float8 longitude - float8 city - text state - text ...
    Bryan NelsonBryan Nelson
    Jul 15, 2011 at 4:11 pm
    Jul 15, 2011 at 7:37 pm
  • I need an eval function that will evaluate a valid SQL expression and return the value. I've seen variations of this asked before with no real answer. I wrote a function to handle it, but it looks ...
    Sim ZacksSim Zacks
    Jul 28, 2011 at 11:18 am
    Aug 1, 2011 at 1:20 am
  • I'm having difficulty finding the correct syntax to modify an existing table. The modification is to add two columns, each a foreign reference to the two key columns of another table. The other ...
    Rich ShepardRich Shepard
    Jul 7, 2011 at 5:40 pm
    Jul 8, 2011 at 12:39 am
  • Hi everybody: I searched the web trying to find an answer to this, but found none. I have a postgresql server and a database, and I granted access to some users. However I want them to access the ...
    Mario PuntinMario Puntin
    Jul 24, 2011 at 9:36 pm
    Jul 25, 2011 at 3:43 pm
  • We have a process that we successfully ran on virtually identical databases. The process completed fine on a machine with 8 gig of memory. The process fails when run on another machine that has 16 ...
    Geoffrey MyersGeoffrey Myers
    Jul 3, 2011 at 10:00 am
    Jul 6, 2011 at 1:32 am
  • I'm about to buy a new desktop home computer and my main concern is best Poker Tracker performance. Poker Tracker uses PostgreSQL so I thought this will be the best place to ask. My DB is big, around ...
    MdxxdMdxxd
    Jul 18, 2011 at 1:38 am
    Oct 5, 2012 at 3:45 am
  • setup: ==== drop table if exists t1; create table t1 (f1 int); create unique index uix_t1 on t1(f1) ; insert into t1(f1) values (1), (2), (3); select * from t1; f1 --- 1 2 3 test statement: ...
    ShianmiinShianmiin
    Jul 18, 2011 at 10:18 pm
    Jul 20, 2011 at 5:06 pm
  • Hi, I have a delete query taking 7.2G of ram (and counting) but I do not understant why so much memory is necessary. The server has 12G, and I'm afraid it'll go into swap. Using postgres 8.3.14. I'm ...
    Vincent dephilyVincent dephily
    Jul 7, 2011 at 2:00 pm
    Jul 8, 2011 at 1:37 pm
  • Hi all, I am experimenting with (synchronous) streaming replication on postgresql 9.1 beta 2 and am having performance problems. I have initially set up an (asynchronous) streaming replication master ...
    David HartveldDavid Hartveld
    Jul 6, 2011 at 3:54 pm
    Jul 8, 2011 at 10:26 am
  • Hi, I am using postgresql on Glassfish server and I have EJB 3.0 for ORM. I am trying to run a query in PSQL but receiving following error: Local Exception Stack: Exception [EclipseLink-4002] ...
    Deniz AtakDeniz Atak
    Jul 30, 2011 at 9:01 am
    Aug 1, 2011 at 2:30 pm
  • Why does this query succeed: select count(*) from tablename where xmin = 2 while this query fails: select count(*) from tablename where xmin != 2 The latter will generate an error message (using ...
    Michael NolanMichael Nolan
    Jul 28, 2011 at 4:40 pm
    Jul 28, 2011 at 11:53 pm
  • Hello, suppose the following scenario the car speed is 240 the car has an airbag Here the first value is integer and the second value is boolean. Consider that I have this table structure feature ...
    Salah jubehSalah jubeh
    Jul 26, 2011 at 5:02 pm
    Jul 27, 2011 at 9:49 am
  • 10

    Book

    Can anyone recommend "PostgreSQL 9.0 High Performance" by G. Smith? Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. ...
    AndrejAndrej
    Jul 20, 2011 at 10:11 pm
    Jul 21, 2011 at 3:30 am
  • Hi Everybody, We want to monitor the performance of PostGRE database. Could anyone please suggest any tools tried/working successfully... 1. We want AWR kind of report in Postgres 2. We would like to ...
    BangarRaju VadapalliBangarRaju Vadapalli
    Jul 6, 2011 at 8:58 am
    Jul 11, 2011 at 6:09 pm
  • Hi I'm doing a restore into Postgresql 8.4, postgis 1.5.1 and I'm getting the following error when it creates the below function: pg_restore: creating FUNCTION _get_buffer(geometry, double precision, ...
    Rebecca ClarkeRebecca Clarke
    Jul 20, 2011 at 10:41 am
    Jul 21, 2011 at 1:54 pm
  • This is basically exactly the same as http://archives.postgresql.org/pgsql-sql/2008-10/msg00009.php; I'm just asking again, to see if thinking on the problem has changed: The basic problem, restated, ...
    Daniel FarinaDaniel Farina
    Jul 5, 2011 at 12:40 am
    Jul 6, 2011 at 1:23 am
  • Hi all - Are there any open source tools available for migrating from oracle to postgres. We have 20 tables in oracles that we needed to get to postgres. Appreciate your help Regards
    Akp geekAkp geek
    Jul 7, 2011 at 1:55 pm
    Jul 7, 2011 at 4:29 pm
  • Greetings I'd like to INSERT data into my Postgresql 8.4.8 table directly from an ODBC-linked MS-SQL table or view. I'm looking at using the Cybertec tool "ODBC-LINK" ...
    Jonathan BrinkmanJonathan Brinkman
    Jul 4, 2011 at 9:16 pm
    Jul 6, 2011 at 12:53 am
  • I've examined the 9.0 manual page on alter table without seeing how to add a foreign key constraint to a column. I needed to make changes on a couple of existing tables which could be accomplished ...
    Rich ShepardRich Shepard
    Jul 1, 2011 at 9:00 pm
    Jul 2, 2011 at 10:32 am
  • Hello, I'm testing PostgreSQL full-text search on a table containing 1.000.000 documents. Document average length is 5.700 chars. Performance is good and very similar to what I can get with Xapian if ...
    Nicolas GrillyNicolas Grilly
    Jul 12, 2011 at 6:47 pm
    Mar 7, 2012 at 6:52 pm
  • Hi, I have repmgr working to some degree on a couple of servers, but am having trouble with the "register" part on the slave. On the master, I run: # repmgr -f /etc/repmgr/validator/repmgr.conf \ ...
    Toby CorkindaleToby Corkindale
    Jul 27, 2011 at 9:36 am
    Aug 2, 2011 at 2:16 am
  • A coworker of mine* was looking for a way to quickly and easily be able to tell which tables were referencing particular table(s) she wanted to load (for unit testing). Using the examples from David ...
    BricklenBricklen
    Jul 29, 2011 at 10:46 pm
    Jul 31, 2011 at 10:53 am
  • Hello All, I've faced with the following problem: I'm trying to implement the auto start of postgres. My way is to use inittab: pg:2345:respawn:/bin/su - postgres -c "/usr/local/pgsql/bin/postmaster ...
    Gavrina, IrinaGavrina, Irina
    Jul 20, 2011 at 11:21 am
    Jul 29, 2011 at 2:01 pm
  • Hello all, I'm new to pgsql and I'm taking over for a project manager that left the company. I'm receiving the following error... CONTEXT: writing block 614 of relation 394198/412175 WARNING: could ...
    Mcleod, JohnMcleod, John
    Jul 25, 2011 at 8:08 pm
    Jul 26, 2011 at 2:05 pm
  • hello to all i would like your help in the following matter - we have 2 identical databases. the 1st was built from scratch while the 2nd was 'restored' from a dump of another database (without the ...
    MirrorXMirrorX
    Jul 23, 2011 at 6:29 pm
    Jul 25, 2011 at 10:02 am
  • Sometimes per week server stops randomly responding for approx 5 minutes. User should wait for 5 minutes before server responds. Other users can work normally at same time. Monday this happens at ...
    AndrusAndrus
    Jul 13, 2011 at 10:59 am
    Jul 13, 2011 at 5:02 pm
  • http://gigaom.com/cloud/facebook-trapped-in-mysql-fate-worse-than-death/ How would PG stack up in a usage situation like this?
    Gauthier, DaveGauthier, Dave
    Jul 11, 2011 at 7:51 pm
    Mar 14, 2012 at 7:39 am
  • Hello all, I am trying out PostgreSQL 9.1 Beta 3. In particular, I am very interested in WITH x AS (...) construction. drop table if exists t; create table t ( identifier serial, title text ); with c ...
    Peter VPeter V
    Jul 27, 2011 at 8:18 pm
    Jul 28, 2011 at 3:47 am
  • Here's what I want to do: I have a master table that has 2 columns: idcol1 and idcol2, where idcol2 is equivalent to idcol1 Table: color_eq idcol1 idcol2 1 1 2 2 2 3 Table: warehouse idcol qty 1 10 2 ...
    Pablo Romero AbitiPablo Romero Abiti
    Jul 22, 2011 at 8:02 pm
    Jul 24, 2011 at 1:55 pm
  • I'm not sure to whom this specifically should be addressed, but something that's been bugging me for a while: announcements like this morning's "AnySQL Maestro 11.7 released", where the announcement ...
    Scott RibeScott Ribe
    Jul 19, 2011 at 4:44 pm
    Jul 20, 2011 at 9:57 pm
  • Hi, I am currently testing pg_upgrade (in copy mode) to migrate a 8.4.4 old cluster to a new 9.0.3 one. It runs fine except when databases contain tablespaces $pg_upgrade -d /pgqdata/pgserver01/data ...
    Olivier LEVESQUEOlivier LEVESQUE
    Jul 1, 2011 at 2:25 pm
    Jul 18, 2011 at 9:43 pm
  • The following query seems to take ages despite the EXPLAIN stating that an index is used.Also, the condition (WHERE t.mid = q.mid) should be a one-to-one mapping, should it not? In this case the ...
    - -- -
    Jul 16, 2011 at 10:32 am
    Jul 16, 2011 at 11:40 pm
  • I am getting the following error message in my Drupal install. PDOException: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for sequence currenttest_id_seq: INSERT INTO ...
    Dave CoventryDave Coventry
    Jul 7, 2011 at 5:03 pm
    Jul 8, 2011 at 7:14 am
  • Hi,I statically compiled my postgres and I got the following message when I ran initdb: creating conversions ... FATAL: could not load library "/usr/local/pgsql/lib/ascii_and_mic.so": ...
    Mona attariyanMona attariyan
    Jul 1, 2011 at 7:28 am
    Jul 3, 2011 at 9:57 pm
  • Hi list After installing PostgreSQL (8.4.8-1) from: http://www.enterprisedb.com/products-services-training/pgdownload#osx on OSX Lion, when running psql I get the following error: dyld: Library not ...
    Sean Moss-PultzSean Moss-Pultz
    Jul 24, 2011 at 5:42 am
    Jun 14, 2012 at 8:44 am
  • Hi, In the repmgr README, it suggests configuration should include: archive_mode = on archive_command = 'cd .' Could someone explain why we need archive_mode enabled? In my own testing of Pg's ...
    Toby CorkindaleToby Corkindale
    Jul 29, 2011 at 8:12 am
    Aug 1, 2011 at 9:20 am
  • I ran the same tests in SQL Server 2008R2, Oracle10 and PostgreSQL 9.0.4 and found something interesting... set up ===== drop table t1 create table t1 (f1 varchar(100)) insert into t1 (f1) values ...
    Samuel HwangSamuel Hwang
    Jul 22, 2011 at 5:13 pm
    Jul 25, 2011 at 8:43 pm
  • Hi All, please let me know what is the maximum number of concurrent client connection supported by Postgres 8.4.6 max_connections = ???? For my database, If I am running the test for more then 1000 ...
    Jenish VyasJenish Vyas
    Jul 21, 2011 at 10:01 am
    Jul 22, 2011 at 9:59 am
  • Hi, Is it possible to set an alarm within a PL/pgSQL function? By "alarm" I mean a function which is invoked some defined time in the future, even after the original function has terminated and ...
    Jon SmarkJon Smark
    Jul 18, 2011 at 9:39 pm
    Jul 21, 2011 at 9:37 am
  • Programmer ( Postgres), Milwaukee - offsite-Remote - onsite We are looking for Postgres skilled programmer with the following skills: Skills: Strong in Postgres SQl , Set up of database, Linux RDBMS ...
    MS RaoMS Rao
    Jul 18, 2011 at 10:01 pm
    Jul 20, 2011 at 9:03 am
  • Hello all, I developed a C function which returns a record. The record contains 3 scalar values and 2 arrays. Randomly some record elements are null and I wonder why. I could trace down the problem ...
    Gregor TrefsGregor Trefs
    Jul 15, 2011 at 8:55 am
    Jul 19, 2011 at 3:18 pm
  • Hello, In http://www.postgresql.org/docs/8.4/static/xfunc-c.html, there is a missing include to the utils/geo_decls.h which leads to compilation errors. i.e #include "utils/geo_decls.h" needs to be ...
    Salah jubehSalah jubeh
    Jul 7, 2011 at 1:56 pm
    Jul 18, 2011 at 9:25 pm
  • Hi all, I moved a few clusters from 8.4 to 9.0 since I required the new way of authenticating against LDAP (or, in my case, AD). Now, I found the new database version introduced permissions on large ...
    Giuseppe SaccoGiuseppe Sacco
    Jul 13, 2011 at 8:30 am
    Jul 15, 2011 at 9:39 am
  • I have three tables. traffic, sales and dates. Both the traffic table and the sales table has multiple entries per date with each row representing the date, some subdivision, and the total. For ...
    Tim UckunTim Uckun
    Jul 12, 2011 at 2:53 am
    Jul 12, 2011 at 10:47 pm
  • Hi all; I started trying to use table partitioning to handle a rather odd case in the software I am working on. I ran into an issue (one I can correct in my code) that strikes me as extremely ...
    Chris TraversChris Travers
    Jul 9, 2011 at 12:59 pm
    Jul 9, 2011 at 3:27 pm
  • I'm trying to setup wal archiving to a secondary computer on OSX 10.6.5 using postgres 9.0.3. Here are my settings in postgresql.conf on the primary box: wal_level = archive archive_mode = on ...
    Joe LesterJoe Lester
    Jul 7, 2011 at 4:29 am
    Jul 8, 2011 at 3:16 am
Jul 2011
1234
Group Navigation
period‹ prev | Jul 2011 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions168
posts906
users247
websitepostgresql.org
irc#postgresql

247 users for July 2011

Craig Ringer: 48 posts Chris Travers: 47 posts Tom Lane: 39 posts David Johnston: 30 posts John R Pierce: 24 posts Adrian Klaver: 20 posts Merlin Moncure: 18 posts Tony Wang: 18 posts Yan Chunlu: 18 posts Alban Hertroys: 17 posts Sim Zacks: 17 posts Darren Duncan: 13 posts Scott Marlowe: 13 posts Gavin Flower: 12 posts Simon Riggs: 12 posts Tomáš Vondra: 12 posts Michael Nolan: 11 posts Salah jubeh: 11 posts Jeff Davis: 10 posts Vincent de Phily: 10 posts
show more
Archives