FAQ

Search Discussions

145 discussions - 661 posts

  • Hello! May I to propose a solution and to step up? I've read a discussion of the bug #5800 and here is my 2 cents. To make things clear let me give an example. I am a PostgreSQL hosting provider and ...
    Alexander LawAlexander Law
    Jul 18, 2012 at 3:05 pm
    Jul 19, 2012 at 12:38 pm
  • Hi, I've created two tables labeled "Big" and "Small" that both store the same 10 million rows of data using 493MB and 487MB of disk space respectively. The difference is that the "Big" table uses ...
    McGehee, RobertMcGehee, Robert
    Jul 24, 2012 at 10:22 pm
    Aug 4, 2012 at 9:01 am
  • I am seeking suggestions for business intelligence and data mining tools compatible with postgresql. A new manager at a client's shop is leaning toward the MS offerings. I would like to be able to ...
    Mark PhillipsMark Phillips
    Jul 25, 2012 at 5:42 pm
    Jul 29, 2012 at 12:17 pm
  • I'm speccing up a three-node database for reliability, making use of streaming replication, and it's all working but I have a bit of a performance concern. Suppose a node dies and is removed from the ...
    Chris AngelicoChris Angelico
    Jul 16, 2012 at 8:28 am
    Jul 28, 2012 at 9:54 pm
  • Hi All I found PG limitations (http://www.postgresql.org/about/): - Maximum Rows per Table - Unlimited - Maximum Table Size - 32 TB My question is: how is it possible to *reach* unlimited rows in ...
    Bartosz DmytrakBartosz Dmytrak
    Jul 11, 2012 at 9:01 pm
    Jul 26, 2012 at 9:28 pm
  • I'm trying to set [now(), 2049-12-31 00:00:00) as the default for a tsrange column (Postgres 9.2), but can't figure out how to do it. I'm either getting syntax errors or now() is being evaluated, so ...
    Chris BartlettChris Bartlett
    Jul 15, 2012 at 10:26 am
    Jul 24, 2012 at 9:01 am
  • Hi all, i am trying to install postgres on a new machine with win 7. i tried two different versions (9.0.4 and 9.1.4) and the problem is the same when i run installation it asks me to provide a ...
    KOTaKOTa
    Jul 11, 2012 at 2:48 pm
    Jul 18, 2012 at 2:45 pm
  • Hi I would appreciate some fresh eyes on this expression - update p_id.fluids set fluid_short = (select shape.text from shape, num_search where (select st_within(shape.wkb_geometry, ...
    Bob PawleyBob Pawley
    Jul 18, 2012 at 6:08 pm
    Jul 19, 2012 at 7:13 pm
  • Hi all, I have an anomaly on my hands that I'm at a loss to understand. We recently ran a small survey where participants were required to answer all the questions. After validation for skipped ...
    Jeff RossJeff Ross
    Jul 10, 2012 at 8:06 pm
    Jul 11, 2012 at 11:47 pm
  • Hey all, According to http://www.postgresql.org/docs/9.2/static/sql-alterrole.html A query: ALTER ROLE davide WITH PASSWORD NULL; removes a role's password. But it's impossible to pass empty (NULL) ...
    Dmitriy IgrishinDmitriy Igrishin
    Jul 24, 2012 at 12:41 pm
    Jul 24, 2012 at 4:53 pm
  • Hello, I'm running Postgres 9.0.2 on RHEL 5.6 x86_64 and trying to run the following statement: alter table samples add column in_esp1234 text; When I do this the command just hangs. ps output ...
    Brian McNallyBrian McNally
    Jul 17, 2012 at 7:56 pm
    Aug 10, 2012 at 6:37 pm
  • Hi there, I am using 9.1.3. I inserted the tablefunc extension, into a SCHEMA called tablefunc, in order to separate it from my tables. I had to create it as postgres user, but changed than the Owner ...
    Stefan SchwarzerStefan Schwarzer
    Jul 3, 2012 at 1:49 pm
    Jul 13, 2012 at 5:53 pm
  • Hello. Strange thing happening: We rencently installed plpython in one of our test servers and installed an extension to use the google api (http://pypi.python.org/pypi/googlemaps ) , everything went ...
    Efraín DéctorEfraín Déctor
    Jul 10, 2012 at 10:00 pm
    Jul 12, 2012 at 2:05 am
  • Hi! Can someone please point me to a resource (or suggest a solution) that will improve the performance of this query? I have some thoughts but figure I should avoid reinventing the wheel since this ...
    David JohnstonDavid Johnston
    Jul 20, 2012 at 8:31 pm
    Jul 22, 2012 at 12:49 am
  • I am running REDHAT 5.5 64 bit with PostgreSQL 8.4.7 64 bit. I am trying to load a binary file into a bytea column into a table without any luck from psql. On the linux server a script is looking for ...
    JkellsJkells
    Jul 24, 2012 at 8:57 pm
    Jul 30, 2012 at 11:05 am
  • I've a select with the following expression: select trim(both ' ' from substring(rslinha2 from 5 for position('(-)' in rslinha2)-6)) from ... problem is that the spaces are not being removed from ...
    Edson RichterEdson Richter
    Jul 27, 2012 at 11:59 pm
    Jul 29, 2012 at 1:24 am
  • Hi all I've been following a strange issue on dba.stackexchange.com and I could use opinions from those more clueful than I on the log files posted there ...
    Craig RingerCraig Ringer
    Jul 19, 2012 at 3:35 am
    Jul 25, 2012 at 7:48 am
  • Hi, we are using "pg_dump -s" (schema-only) to copy the structure of a template/prototype database as a set-up for several dozen Fedora boxes. The dump used to work alright until very recently. Now, ...
    Marek KielarMarek Kielar
    Jul 26, 2012 at 11:10 pm
    Aug 7, 2012 at 12:50 pm
  • I know PostgreSQL from time to time runs automatically the vacuum process. My applications grows due lots of data import during the day (about 100Mb/day). Do I need also to schedule a Vacuum Analyze ...
    Edson RichterEdson Richter
    Jul 24, 2012 at 8:36 pm
    Jul 25, 2012 at 12:02 am
  • What I thought would be a simple, single table select keeps eluding me. I've looked in Rick van der Laans' book and the Joe Celko books here and have not learned how to write the query. The table has ...
    Rich ShepardRich Shepard
    Jul 20, 2012 at 3:54 pm
    Jul 21, 2012 at 1:55 am
  • Hi. -- problem 1 -- I have an application, using libpq, connecting to postgres 9.1.3 (Amazon AMI distro). The application writes data at a high rate (at this point it's 500 transaction per second), ...
    Pawel VeselovPawel Veselov
    Jul 3, 2012 at 7:20 am
    Jul 3, 2012 at 1:40 pm
  • We make heavy use of streaming replication on PG 9.1 and it's been great for us. We do have one issue with it, though, and that's when we switch master nodes - currently, the documentation says that ...
    Ben ChobotBen Chobot
    Jul 27, 2012 at 5:04 pm
    Aug 7, 2012 at 7:15 pm
  • Hi, The PostgreSQK documentation refers to diskchecker.pl on the page http://brad.livejournal.com/2116715.html But on this page, the given link for diskchecker.pl does not exist anymore. After some ...
    JgJg
    Jul 18, 2012 at 2:11 pm
    Aug 7, 2012 at 1:00 pm
  • Hello, I have been working with Postgresql for the last 3 years. Before that I worked with Oracle, Mysql and other databases. Now, its time to learn the internals of Postgresql system. I downloaded ...
    AI RummanAI Rumman
    Jul 3, 2012 at 11:50 am
    Aug 1, 2012 at 1:59 pm
  • I recently switched from OSX to Linux and \copy in psql no longer accepts multi-line queries. For instance: \copy ( select * from pg_settings ) to '/tmp/settings.csv' with csv header This works fine ...
    Ryan KellyRyan Kelly
    Jul 27, 2012 at 1:28 pm
    Jul 27, 2012 at 5:57 pm
  • did a centos 5.6 server upgrade to PostgreSQL version 8.4.12. console: [root@main jdbc]# psql -h localhost -U gameserver passwordfromentityengine.xml psql: could not connect to server: Connection ...
    BJ FreemanBJ Freeman
    Jul 25, 2012 at 2:58 pm
    Jul 27, 2012 at 2:33 am
  • I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds Zabbix database. The database on disk takes 10Gb. SQL dump takes only 2Gb. I've gone through ...
    Ilya IvanovIlya Ivanov
    Jul 20, 2012 at 6:06 pm
    Jul 21, 2012 at 1:41 am
  • I'm trying to create a discrete range type and I'm having trouble with the canonical function. --Create shell type CREATE TYPE dt_range; --Create subtype diff CREATE OR REPLACE FUNCTION ...
    Scott BaileyScott Bailey
    Jul 17, 2012 at 11:41 pm
    Jul 18, 2012 at 5:48 pm
  • Hi, I've encountered something that might be a bug in DBD::Pg, or might be a feature of PostgreSQL itself. The issue occurs when you have server-side prepared queries enabled, and then change the ...
    Toby CorkindaleToby Corkindale
    Jul 11, 2012 at 7:43 am
    Jul 13, 2012 at 1:47 am
  • Hey All, We used the linked guide to setup streaming replication. http://wiki.postgresql.org/wiki/Streaming_Replication When testing the failover procedure, we noticed that when the new master comes ...
    Andy ChambersAndy Chambers
    Jul 10, 2012 at 10:17 pm
    Jul 12, 2012 at 12:43 am
  • Hi all, I have a query which is being optimized very differently depending on whether it is written using an OR clause or a UNION clause. I believe that the query results should be the same, and even ...
    Steven SchlanskerSteven Schlansker
    Jul 5, 2012 at 9:58 pm
    Jul 9, 2012 at 5:35 pm
  • I'm using Postgres hash indices on a streaming replica master. As is documented, hash indices are not logged, so the replica does not have access to them. I understand that the current wisdom is ...
    Steven SchlanskerSteven Schlansker
    Jul 10, 2012 at 7:10 am
    Aug 20, 2012 at 5:55 pm
  • Hi, I have two virtual machines with two different versions of Postgresql. One machine contains Postgres 7.4.19 and another has Postgres 8.4.3. I also have other instances of these two virtual ...
    Manoj AgarwalManoj Agarwal
    Jul 26, 2012 at 10:40 am
    Aug 8, 2012 at 4:45 pm
  • hello: i know oracle scatter read blocks,can set db_file_multiblock_read_count every time, i see postgres,it exists scatter read blocks,it is seq_scan,how to know scan many bloks every time? -- View ...
    Leo xuLeo xu
    Jul 25, 2012 at 11:38 am
    Aug 2, 2012 at 3:03 am
  • Assuming a *nix server: if a monitoring program determines that an established connection appears to be trying to so something inappropriate, what's the best way of terminating that session rapidly? ...
    Mark Morgan LloydMark Morgan Lloyd
    Jul 27, 2012 at 8:28 am
    Jul 27, 2012 at 3:18 pm
  • I am beginning to use the full text search facilities in Postgresql (9.0) and find the result of this query a bit strange: query: SELECT ts_headline('simple',title, to_tsquery('kerkreg|(church & ...
    Johann SpiesJohann Spies
    Jul 25, 2012 at 8:26 am
    Jul 26, 2012 at 2:41 pm
  • I am not sure if this is expected behaviour or a bug. Using PG 9.2 beta 2 and PGAdmin3 1.16 beta 2. Connect as bob (superuser) In public schema: create table people (cols...) create view people_view ...
    Chris BartlettChris Bartlett
    Jul 26, 2012 at 2:26 am
    Jul 26, 2012 at 2:16 pm
  • Hello Community, We have a critical situation where-in our production database server got effected by "Root Kit". When tried to build a replication site by copying the data directory to a different ...
    Venkat BalajiVenkat Balaji
    Jul 4, 2012 at 8:30 am
    Jul 4, 2012 at 10:29 am
  • Hi, I just uninstalled version 8.4 and tried installing version 9.1 in my computer (my system is Windows 7). The issue Im facing was that when I clicked run to install the new version one of the ...
    Guillermo Echevarria Quintana-GurtGuillermo Echevarria Quintana-Gurt
    Jul 29, 2012 at 6:30 pm
    Jul 30, 2012 at 10:58 am
  • Hi, I'm using Postgresql 8.4.12-1 on Debian. I've installed 'dblink' from the contrib package (also 8.4.12-1) and am now running into a strange problem when I run "drop owned by". First, as the ...
    James W. WilsonJames W. Wilson
    Jul 18, 2012 at 8:25 pm
    Jul 19, 2012 at 12:54 pm
  • Hi, We are using PostgreSQL 8.3 on Windows Server. The db crashed and now it fails to start up. The error is: FATAL: could not access status of transaction 4020264 DETAIL: Could not read from file ...
    Olga VingurtOlga Vingurt
    Jul 16, 2012 at 12:15 pm
    Jul 17, 2012 at 1:37 pm
  • I hit "bug 5665". I see threads like this: http://archives.postgresql.org/pgsql-bugs/2011-01/msg00241.php Where / how can I find the diff that went in to fix this? Mostly I'm curious. I can work ...
    Perry SmithPerry Smith
    Jul 14, 2012 at 3:57 pm
    Jul 14, 2012 at 10:31 pm
  • Hello, WITH RECURSIVE queries are quite new for me, so I'm not sure if following is possible CREATE TEMP TABLE forest (node int,parent int); INSERT INTO forest VALUES (1, null), (2, 1), (3, 2), (4, ...
    Marc MaminMarc Mamin
    Jul 13, 2012 at 10:28 am
    Jul 13, 2012 at 12:57 pm
  • Hi Guys, This isn't a PostgreSQL specific question but just a SQL question. If this is not an appropriate question for this list, please let me know. It is also, perhaps, a really silly question ...
    Perry SmithPerry Smith
    Jul 6, 2012 at 9:35 pm
    Jul 7, 2012 at 2:39 pm
  • First and foremost, I just want to say Thank You, very much, sincerely, to the entire PostgreSQL community for everything you are, do and have built. Without going into an exorbitant amount of ...
    AchAch
    Jul 6, 2012 at 5:05 pm
    Jul 7, 2012 at 1:15 pm
  • Inside a function, I can execute dynamic query like this dept_id = 1; salary = 50000; RETURN QUERY EXECUTE 'SELECT * FROM employee WHERE dept_id = $1 and salary = $2' using dept_id, salary; When the ...
    ChoonSoo ParkChoonSoo Park
    Jul 6, 2012 at 2:02 pm
    Jul 6, 2012 at 4:42 pm
  • I'm interested in sorting my query by time descending, with the highest percent by latest time shown first, and then every other record associated with column name sorted by time descending, ...
    AjmcelloAjmcello
    Jul 2, 2012 at 11:22 pm
    Jul 3, 2012 at 6:41 am
  • Hi dear friends, This my first post to PostgreSQL mailing list. I'm trying to setup a master-slave replication with PostgreSQL 9.1 / Slony-I, this is first time I'm doing it and I'm kind of lost :( ...
    Iqbal AroussiIqbal Aroussi
    Jul 1, 2012 at 4:48 pm
    Jul 2, 2012 at 9:30 am
  • Hello, We are running PostgreSQL 8.3 on a Debian Lenny system. Since the system is outdated, we want to update to Debian Squeeze. Based on your knowledge and experience are there any special ...
    Patrick ErnstPatrick Ernst
    Jul 30, 2012 at 10:58 am
    Aug 4, 2012 at 5:31 am
  • I have an input source that is in epoch time. Is there a built-in conversion to changing to timestamp Thanks Doug Little Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz ...
    Little, DouglasLittle, Douglas
    Jul 30, 2012 at 2:37 pm
    Jul 30, 2012 at 10:53 pm
Group Navigation
period‹ prev | Jul 2012 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions145
posts661
users195
websitepostgresql.org
irc#postgresql

195 users for July 2012

Tom Lane: 49 posts Craig Ringer: 46 posts Adrian Klaver: 35 posts David Johnston: 18 posts Chris Angelico: 17 posts Edson Richter: 15 posts Alban Hertroys: 14 posts Merlin Moncure: 11 posts Alexander Law: 9 posts KOTa: 9 posts Bartosz Dmytrak: 8 posts John R Pierce: 8 posts Steven Schlansker: 8 posts Jasen Betts: 7 posts Jeff Ross: 7 posts Sergey Konoplev: 7 posts Tatsuo Ishii: 7 posts Vincent Veyron: 7 posts Andy Chambers: 6 posts Chris Bartlett: 6 posts
show more
Archives