Search Discussions

265 discussions - 1,417 posts

  • I noticed that the user survey on the community page does not list replication among the choices for development priority. For me, replication is the most important thing that is critically missing ...
    Gerry RenoGerry Reno
    Jun 22, 2009 at 9:53 pm
    Jul 8, 2009 at 2:29 am
  • Hi, I have finally found out why I have had images that lag on the website. It seems to be that postgre is doing allot of I/O activity and the images is somehow suffering because of this. The strange ...
    Jennifer TreyJennifer Trey
    Jun 3, 2009 at 1:54 pm
    Jun 4, 2009 at 4:01 pm
  • If I were to upgrade the database version, would I need to dump and restore all the data?
    Carlos OlivaCarlos Oliva
    Jun 3, 2009 at 3:41 pm
    Jun 8, 2009 at 11:31 am
  • Is there a way when creating a table to limit it to one row? That is, without using a stored procedure? I searched the documentation, but didn't find anything. -- Brandon
    Brandon MetcalfBrandon Metcalf
    Jun 4, 2009 at 8:13 pm
    Jun 10, 2009 at 12:22 pm
  • I'm trying to set up a warm standby via WAL shipping. I'm digging through the source of pg_standby.c to determine the proper method. Since we are using scp to access the archive files, pg_standby ...
    Jun 2, 2009 at 7:27 pm
    Jun 4, 2009 at 2:25 pm
  • Hello, I am very new to postgresql database. I`ve used a little of MySql previously. My task is to store a lot (10^5) of small ( <10 MB) text files in the database with the ability to restore them ...
    Jun 6, 2009 at 10:37 am
    Jun 13, 2009 at 11:09 am
  • Hey guys what is a good way to horizontal shard in postgresql 1. pgpool 2 2. gridsql which is a better way to use sharding also is it possible to paritition without changing client code thanks -- ...
    Jun 15, 2009 at 7:32 am
    Jun 28, 2009 at 4:51 pm
  • I posted this a while back but got no useful responses. I have the following error message: "Error connecting to the server: server closed the connection unexpectedly. This probably means that the ...
    Andrew MacleanAndrew Maclean
    Jun 18, 2009 at 11:12 pm
    Jun 23, 2009 at 4:24 am
  • Hi everybody, is there a (stand-alone, command line) tool that converts the output of EXPLAIN ANALYZE into a tree-like representation of the plan? Cheers, Viktor
    Viktor RosenfeldViktor Rosenfeld
    Jun 22, 2009 at 11:55 am
    Sep 23, 2009 at 1:35 pm
  • Hi! We are thinking to create some stocks related search engine. It is experimental project just for fun. The problem is that we expect to have more than 250 GB of data every month. This data would ...
    Jun 15, 2009 at 12:23 pm
    Jun 16, 2009 at 8:06 pm
  • I've wrote a PLPGSQL stored procedure for a DB I've to delivery to my customer. The problem is that I want to hide the code of the stored procedure. I don't want that my customer is able to read the ...
    Luca CicirielloLuca Ciciriello
    Jun 26, 2009 at 8:56 am
    Jun 30, 2009 at 7:35 am
  • I've noticed over a wide variety of operating systems that when you paste from an application into psql through a terminal (currently using the default gnome terminal in ubuntu), large pastes tend to ...
    Merlin MoncureMerlin Moncure
    Jun 27, 2009 at 5:19 pm
    Jun 29, 2009 at 4:59 pm
  • Hi, I'm a noob who failed to properly sanitize incoming data from the front end. As a result, a poor hapless user managed to smuggle in a malicious UPDATE statement that corrupted every single record ...
    Gus GutoskiGus Gutoski
    Jun 10, 2009 at 4:49 pm
    Jun 23, 2009 at 7:22 pm
  • Hi, Is there some way to find out meta-information about the columns generated by any SELECT query? If the SELECT returns values from a regular table or a view, I can use pg_class and pg_attribute to ...
    Dario TeixeiraDario Teixeira
    Jun 22, 2009 at 12:33 pm
    Jun 23, 2009 at 2:36 pm
  • I've a record set on which I have to loop several times. The function should return the same record set + one more computed field. Something that in could look like: foreach(row) { // compute stuff ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Jun 19, 2009 at 6:23 pm
    Jun 22, 2009 at 10:02 am
  • Greetings, The video from the June 9, 2009 SFPUG meeting, "PostgreSQL as a secret weapon for high-performance Ruby on Rails applications," is now available for viewing or download from the ...
    Jun 11, 2009 at 1:21 am
    Jun 14, 2009 at 1:12 pm
  • I want to develop an app which uses libpq, built with mingw. Is there a download package which contains just the include files/dlls? If not, what package do I download? I don't need the server, just ...
    Phil LongstaffPhil Longstaff
    Jun 11, 2009 at 12:50 am
    Jun 12, 2009 at 1:01 pm
  • the openstreetmap project (http://osm.org/) recently moved from using mysql to postgres and we're trying to improve some of our tools using the new functionality that postgres provides. in ...
    Matt AmosMatt Amos
    Jun 11, 2009 at 10:25 am
    Jun 11, 2009 at 6:43 pm
  • I have a linux postgres server in the field. Its version is: PostgreSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-51) (aka postgresql-8.2.4-1PGDG) A few ...
    Ben ChobotBen Chobot
    Jun 2, 2009 at 6:10 pm
    Jun 2, 2009 at 10:13 pm
  • Dear all, Our software use postgres as backend database. It works fine, strange thing is that, it creates so many temporary schemas under schema tab, names like pg_toast, pg_toast_temp_1 like this ...
    Anirban PalAnirban Pal
    Jun 8, 2009 at 5:57 am
    Feb 4, 2010 at 2:36 am
  • Hi We're trying PG on a new machine, so we copied our current (live) database to that server. Tested the code and it's all working. Now, to make that second server the main live server, we will need ...
    Phoenix KiulaPhoenix Kiula
    Jun 29, 2009 at 4:10 am
    Jul 27, 2009 at 3:35 am
  • Hey list, I'm migrating my site away from MySQL to PostgreSQL. So far, it's been going great. However, there's one problem I've been having trouble solving. I have a query which allows users to ...
    Jun 28, 2009 at 12:23 am
    Jul 1, 2009 at 11:32 am
  • No more than Oracle does. We get it right in the first place. The existence of "integrity checking" tools means the DBMS is done with high incompetence. See above. Cheers, David. -- David Fetter ...
    David FetterDavid Fetter
    Jun 23, 2009 at 12:38 pm
    Jun 25, 2009 at 1:02 pm
  • Hi. I have a little problem (and a suggestion for a solution) that I wondered if anyone would care to comment on. I have a standard table filled with customers (with a unique customer id, names etc.) ...
    A BA B
    Jun 16, 2009 at 7:11 am
    Jun 20, 2009 at 1:41 pm
  • This may not be the right place for this question but I am going to start here anyway. I have installed postgresql in cygwin on a MS-WinXPpro system. I wish to initialise a database instance. ...
    James B. ByrneJames B. Byrne
    Jun 14, 2009 at 5:30 pm
    Jun 15, 2009 at 7:16 pm
  • Is there a way to create a database or a table of a database in its own folder? We are looking for ways to backup the sytem files of the database to tape and one to exclude some tables from this ...
    Carlos OlivaCarlos Oliva
    Jun 2, 2009 at 2:10 pm
    Jun 5, 2009 at 3:07 pm
  • Hello every one, I am new to databases. I am using Postgres 8.2 (Migrating to 8.3.7 in few days) on windows platform. I had tried using Slony-I for replication and was not able to create a cluster. ...
    Jun 15, 2009 at 8:29 am
    Jun 26, 2009 at 11:36 am
  • Good morning. On occasion I'll perform a full vacuum on a database but will still receive a suggestion to vacuum an individual table immediately after. Does the full database vacuum not handle each ...
    Hartman, MatthewHartman, Matthew
    Jun 25, 2009 at 3:22 pm
    Jun 25, 2009 at 5:31 pm
  • Hi guys, im tryin to optimize a simple table, suited for contain users. So, my table at the moment is: ----- CREATE TABLE contacts( id BIGSERIAL PRIMARY KEY NOT NULL UNIQUE, company_id BIGINT, code ...
    Jun 23, 2009 at 8:10 am
    Jun 23, 2009 at 4:40 pm
  • Hi, First, the numbers: PG Version Load time pg_database_size autovac ---------------------------------------------------------- 8.2.13 179 min 92,807,992,820 on 8.3.7 180 min 84,048,744,044 on ...
    Todd A. CookTodd A. Cook
    Jun 17, 2009 at 2:55 pm
    Jun 22, 2009 at 4:52 pm
  • Hi there. When is a good time to use cascading deletes? Usually, for safety reasons, I prefer to not ever use cascading deletes. But that can lead to some complex code that uses topological sorts etc ...
    Jun 11, 2009 at 8:59 am
    Jun 11, 2009 at 10:31 pm
  • We want to implement a mechanism by which if any database function is created or modified in one database, then the same should automatically get done in another (1 or more) database(s). It seems ...
    Atul ChojarAtul Chojar
    Jun 5, 2009 at 5:13 pm
    Jun 11, 2009 at 12:17 pm
  • is there any way currently to convert xml file in format like below, to a table ? <foo <section <ssc id="foo1" <foo_data a="1" b="2"/ <foo_more_data c="a" d="b"/ </ssc </section <section <ssc ...
    Grzegorz JaśkiewiczGrzegorz Jaśkiewicz
    Jun 1, 2009 at 9:53 am
    Jun 7, 2009 at 3:34 pm
  • Hello, We have a system that allows users to create views containing calculations but divisions by zero are commonly a problem. An simple example calculation in SQL would be SELECT cost / pack_size ...
    Oliver KohllOliver Kohll
    Jun 3, 2009 at 5:55 pm
    Jun 4, 2009 at 9:12 pm
  • I need to create a table with two columns of type timestamp but I don't want to store any fractional part of the seconds field. So, I created a table with: CREATE TABLE timeclock ( timeclock_id ...
    Brandon MetcalfBrandon Metcalf
    Jun 2, 2009 at 4:26 pm
    Jun 3, 2009 at 5:51 am
  • Hello! I've the following data: datetime | val1 | val2 time1 | 4 | 40% time2 | 7 | 30% time3 | 12 | 20% ... I'd like to sum up the following: (7-4)*30% + (12-7)*20% + ... datetime is ordered (and ...
    Gerhard WiesingerGerhard Wiesinger
    Jun 8, 2009 at 6:36 am
    Sep 27, 2009 at 6:31 am
  • I have encountered an error that, on the face of it, seems to me to be inexplicable. I hope that someone here can illuminate the matter for me. PGError: ERROR: timestamp out of range: "20080809-01-01 ...
    James B. ByrneJames B. Byrne
    Jun 30, 2009 at 5:17 pm
    Jun 30, 2009 at 11:22 pm
  • PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat tcp 0 0* LISTEN 5091/postmaster I do a psql -h ...
    BJ FreemanBJ Freeman
    Jun 29, 2009 at 2:25 am
    Jun 30, 2009 at 7:48 pm
  • Hi, I'm having difficulty constructing a query that will find breaks where data change in a time-series. I've done some searching for this too, but I haven't found anything. Here is my example ...
    Mike ToewsMike Toews
    Jun 15, 2009 at 7:39 pm
    Jun 23, 2009 at 2:18 am
  • I just tracked down a bug in my software due to an "unexpected" behavior in Postgres.. Can someone clarify why this doesn't work (I haven't tried it on MSSQL or anything else, so I'm not sure if this ...
    Mike ChristensenMike Christensen
    Jun 21, 2009 at 10:17 pm
    Jun 22, 2009 at 8:08 am
  • Hi, the worst have ocurred, my server died (cpu), so i reinstalled another server with the same postgres version. I have the old data directory from the old server, how can i restore my databases ...
    Miguel MirandaMiguel Miranda
    Jun 19, 2009 at 8:32 pm
    Jun 20, 2009 at 11:48 am
  • Hi, I'm designing a database schema in which I should allow user to create custom fields at the application level. My application is a web-based system and it has multiple companies in a single ...
    Jun 15, 2009 at 1:04 pm
    Jun 17, 2009 at 2:58 pm
  • Hello All, I am investigating the possibility of hosting pgsql 8.3 on Amazon EC2 & implementing a simple HA solution. My search of postgresql & amazon cloud has produced little result. Just wondering ...
    Jun 15, 2009 at 6:13 pm
    Jun 16, 2009 at 6:30 pm
  • Given a datetime column, not null, is there a single syntax that permits searching for all dates in a given year, year+month, and year+month+day such that a single parameterised query can handle all ...
    James B. ByrneJames B. Byrne
    Jun 11, 2009 at 8:23 pm
    Jun 12, 2009 at 8:25 pm
  • Good day, I'm having one heck of a time here. I'm looking for a clean solution to issue a COPY statement from a remote system. (because I really don't want to play the ssh, sudo spiel). It's evident ...
    Tory M BlueTory M Blue
    Jun 9, 2009 at 6:21 pm
    Jun 11, 2009 at 1:04 pm
  • Hi Everyone, I have a hard to reproduce scenario for a production site....I tried to simplify the code and at the end I could get a similar problem with the following table and java code. The problem ...
    Ioana DanesIoana Danes
    Jun 8, 2009 at 3:41 pm
    Jun 9, 2009 at 8:27 pm
  • Hi, In PostgreSQL, there are some grant privileges like grant on SEQUENCE, DATABASE, LANGUAGE, SCHEMA and DATABASE. I grant and revoke these privleges on my PostgreSQL on Windows and Linux OS. But ...
    Louis LamLouis Lam
    Jun 2, 2009 at 7:25 pm
    Jun 5, 2009 at 5:31 pm
  • Hello: I'm currently building a Pg multiserver and have a question about the possibility of working with WAL in a multislave environment. I have few master servers (write only) and multiple slave ...
    Eduardo MorrasEduardo Morras
    Jun 24, 2009 at 4:57 pm
    Jul 1, 2009 at 1:52 pm
  • 7


    I guess, you don't get it. Probably so select * from a left outer join b on (a.b_id=b.id) .... But I don't see any clear way to specify that table C should be outer joined only if we got a row from ...
    Waldemar BergstreiserWaldemar Bergstreiser
    Jun 30, 2009 at 8:58 am
    Jun 30, 2009 at 8:37 pm
  • Hi, I'm looking for free software that provide OLAP functionality (or more general BI) for data that are stored in Postgres database. I've found Pentaho and Jasper but both sollution are configured ...
    Michal SzymanskiMichal Szymanski
    Jun 27, 2009 at 8:11 pm
    Jun 29, 2009 at 2:22 pm
Group Navigation
period‹ prev | Jun 2009 | next ›
Group Overview
grouppgsql-general @

320 users for June 2009

Tom Lane: 110 posts Scott Marlowe: 53 posts Grzegorz Jaśkiewicz: 46 posts Merlin Moncure: 33 posts Craig Ringer: 30 posts Bill Moran: 28 posts Jasen Betts: 24 posts David Fetter: 22 posts Albe Laurenz: 20 posts Pavel Stehule: 17 posts Sam Mason: 17 posts Brandon Metcalf: 16 posts Greg Smith: 16 posts Jennifer Trey: 16 posts Carlos Oliva: 15 posts Greg Stark: 15 posts Sim Zacks: 15 posts Dave Page: 14 posts Ivan Sergio Borgonovo: 14 posts Joshua D. Drake: 14 posts
show more