Search Discussions

139 discussions - 761 posts

  • Hi All, We have one production database server , having 6 DBs, Postgres 9.2.1 version. This is my vacuum settings in Production database #autovacuum = on # Enable autovacuum subprocess? 'on' # ...
    Vishalakshi NavaneethakrishnanVishalakshi Navaneethakrishnan
    Aug 7, 2013 at 9:47 am
    Aug 13, 2013 at 11:37 am
  • Hi to all .... On my Postgresql 9.1 instance I had a problem with an index. Using index I get less tuples than expected. I try to remove index and the query works fine but obviosly the query is slow ...
    Torello QuerciTorello Querci
    Aug 26, 2013 at 2:27 pm
    Aug 28, 2013 at 11:23 am
  • Hi guys, I am looking for a way to get list of supported types in Postgres together with information whether type can have optional size (like varchar for example), whether it can have precision ...
    Ivan RadovanovicIvan Radovanovic
    Aug 14, 2013 at 12:17 pm
    Aug 15, 2013 at 3:49 pm
  • Hello, I am looking the effect of having large number of relation files under $PGDATA/base/ (for example, in cases where I choose lower segment size using --with-segsize). Consider a case where I am ...
    Amit LangoteAmit Langote
    Aug 5, 2013 at 6:23 am
    Aug 6, 2013 at 11:38 am
  • Hello, I'm having an issue where streaming replication just randomly stops working. I haven't been able to find anything in the logs which point to an issue, but the Postgres process shows a ...
    Andrew BermanAndrew Berman
    Aug 15, 2013 at 6:08 pm
    Aug 16, 2013 at 5:24 pm
  • Hi all, I have a database that uses the ltree extension. I typically create a new database like so (as a normal user), using my script file: CREATE DATABASE mydb WITH TEMPLATE template0 ENCODING ...
    Don ParrisDon Parris
    Aug 8, 2013 at 9:13 pm
    Aug 10, 2013 at 2:05 pm
  • Hello and namaste, I have installed the latest version an running tests on it. Since i analyze logs , i have found three new entries in log for each insert statement which isn't present in postgres ...
    Arvind SinghArvind Singh
    Aug 10, 2013 at 6:39 am
    Aug 12, 2013 at 11:18 am
  • I needed a GROUP_CONCAT to port some queries to postgres. In discussions online, I found repeated advice for rewriting the queries, but no solid way to formulate the GROUP_CONCAT as a postgres ...
    Immersive ExcelImmersive Excel
    Aug 3, 2013 at 9:52 pm
    Aug 6, 2013 at 4:09 pm
  • I develope a project openbarter that needs to match objects based on a maximum distance between their positions on earth. I saw that the documentation of the extension earthdistance was interesting, ...
    Olivier ChaussavoineOlivier Chaussavoine
    Aug 9, 2013 at 7:29 pm
    Aug 24, 2013 at 7:37 pm
  • Hi, I want to store copies of our data on a remote machine as a security measure. My first attempt was a full dump (which takes too long to upload) followed by diffs between the pgdump files. This ...
    Hamann WHamann W
    Aug 1, 2013 at 9:00 am
    Aug 11, 2013 at 3:30 pm
  • Hello, I wanted to create a composite datatype to represent a Node. So it would have a few attributes and an array of type Node which is the children of this node. create type Node as (r integer, s ...
    Sameer ThakurSameer Thakur
    Aug 7, 2013 at 11:57 am
    Aug 8, 2013 at 6:46 am
  • When I want to add a new column with a NOT NULL constraint, I need to specify a DEFAULT to avoid violations. However, I don't always want to keep that DEFAULT; going forward after the initial add, I ...
    Aug 1, 2013 at 10:50 pm
    Aug 3, 2013 at 5:35 am
  • Hi, Thats my code snipped: SELECT v_rec1.user, sum(CASE WHEN v_rec_fts.lev BETWEEN 0 AND 25 THEN 1 ELSE 0 END) as "0 to 25", sum(CASE WHEN v_rec_fts.lev BETWEEN 25 AND 50 THEN 1 ELSE 0 END) as "25 to ...
    Janek SendrowskiJanek Sendrowski
    Aug 25, 2013 at 9:59 pm
    Aug 27, 2013 at 6:27 pm
  • Consider the following SQL: --------------------------------------------------- CREATE TABLE t1(m VARCHAR(4)); INSERT INTO t1 VALUES('az'); INSERT INTO t1 VALUES('by'); INSERT INTO t1 VALUES('cx') ...
    Richard HippRichard Hipp
    Aug 14, 2013 at 6:02 pm
    Aug 17, 2013 at 3:07 am
  • Hello, When the client library (version 9.2.x) is compiled with a MinGW-w64 environment the resulting libpq.dll will not function. This has been reported previously with two bug reports, which have ...
    Michael CronenworthMichael Cronenworth
    Aug 13, 2013 at 5:35 pm
    Aug 17, 2013 at 12:01 am
  • Linux Mint (from Ubuntu) version 9.1. Postgres will no longer start, but I cannot find out why. Command line: $ /usr/lib/postgresql/9.1/bin/pg_ctl start -D /home/postgresql/9.1/main -l ...
    Oliver ElphickOliver Elphick
    Aug 8, 2013 at 10:02 pm
    Aug 9, 2013 at 2:53 pm
  • Hello everyone! I got a out of memory problem, when I tried to insert a binary file (256MB) to bytea column; I want to get a way to insert files (vary from 1byte to 2GB) or byte array or binary ...
    Aug 6, 2013 at 7:13 am
    Aug 8, 2013 at 2:42 am
  • Hello: Sorry for disturbing. I have one question : Will checkpoint cause wal written happen? I found the following info at: http://www.postgresql.org/docs/9.2/static/wal-configuration.html .. ...
    Aug 23, 2013 at 3:00 am
    Aug 31, 2013 at 2:22 am
  • Hi all, At work we have a system that's built on top of a proprietary OLAP database system (Rocket Gentia). We're looking into replacing that system with something that's still supported and in such ...
    Alban HertroysAlban Hertroys
    Aug 27, 2013 at 3:12 pm
    Aug 28, 2013 at 3:53 am
  • Hi all, When I install the Kubuntu (13.04) postgresql (9.1) packages, the default template1 encoding turns out to be ASCII, which is not really what I want. My OS locale command reveals everything to ...
    Don ParrisDon Parris
    Aug 21, 2013 at 9:55 am
    Aug 23, 2013 at 8:59 am
  • When using array_agg on a large table, memory usage seems to spike up until Postgres crashes with the following error: 2013-08-17 18:41:02 UTC [2716]: [2] WARNING: terminating connection because of ...
    Robert SosinskiRobert Sosinski
    Aug 19, 2013 at 3:00 am
    Aug 21, 2013 at 3:56 pm
  • Hi, I have faced very strange problem in one of psotgresql query in one of the production environment. It is working fine in development and other environment. Current value in colname = 5;Update ...
    S HS H
    Aug 7, 2013 at 11:54 pm
    Aug 21, 2013 at 9:14 am
  • Hi all, I seem to be having some grief with the 9.1.9 query planner favouring an index scan + merge join, over a sequential scan + hash join. Logically I would have considered the index+merge to be ...
    Timothy KaneTimothy Kane
    Aug 10, 2013 at 5:32 pm
    Aug 21, 2013 at 9:10 am
  • Mostly just curious, as this is preventing me from using tab-separated output. I'd like there to be a header in my files. I have to use CSVs instead. Joe
    Joe Van DykJoe Van Dyk
    Aug 12, 2013 at 9:16 pm
    Aug 15, 2013 at 3:59 pm
  • Hi. I'm looking for suggestions for the best solution to the following situation. I have a database roughly 300 meg with 30 tables. For fieldwork, a copy is running on my mac laptop where I can pull ...
    Paula KirschPaula Kirsch
    Aug 9, 2013 at 2:27 pm
    Aug 9, 2013 at 9:28 pm
  • Hello, sorry for dumb question, did any one can tell me how the hell I can remove clear screen after finish the sql query from console ? This probably have some idea, but for me look like very .. ...
    Aug 7, 2013 at 3:53 pm
    Aug 8, 2013 at 2:37 pm
  • Hi, I have a Windows box running Windows Server 2003 Enterprise Edition Service Pack 2 with PostgreSQL 8.2.23 and getting a server crash while trying to select a table: select * from "TOTALL.tt_est" ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    Aug 3, 2013 at 6:41 pm
    Aug 7, 2013 at 10:48 pm
  • Hi all! I have two servers, which share a large mounted drive. I would like to share postgres databases between them dynamically so that when one makes changes, they are immediately available in the ...
    JD WongJD Wong
    Aug 6, 2013 at 5:45 pm
    Aug 6, 2013 at 7:53 pm
  • Hi, Our client has began to complain for a few days that the application can not connect to the database more times. I looked into the logs and as far as I can see, postgresql restarts more times a ...
    Aug 6, 2013 at 1:58 pm
    Aug 6, 2013 at 2:53 pm
  • Hi Folks (hope I haven't left anyone out) SUCCESS (ALMOST)!! But..I'm not 100% sure how I did it and.. I think I got Postgres to install properly because of one or more of the following, after ...
    Stephen BrearleyStephen Brearley
    Aug 2, 2013 at 9:41 am
    Aug 5, 2013 at 9:15 pm
  • Now i want to insert data to the table.... the format should be id | marks ---------- 1 |50 1 |30 1 |30 .... .... 2 |... .... the actual query is insert into table(id,marks) ...
    Aug 9, 2013 at 2:20 pm
    Aug 21, 2013 at 5:23 am
  • Dear community We have a problem on our development database server, which supports a PHP application, which connects to it from a different server. Sometimes, around 1 in 4 page loads, it fails and ...
    Stuart FordStuart Ford
    Aug 15, 2013 at 10:41 am
    Aug 16, 2013 at 7:31 am
  • Hi, I am working on a plpgsql function that is not acting as I would hope. I am working with the Postgres 9.3 beta load and would like to solicit some feedback. Looking at the outermost for loop of ...
    Day, DavidDay, David
    Aug 9, 2013 at 1:54 pm
    Aug 12, 2013 at 12:45 pm
  • Hello to everybody, I started to upload (via phpPgAdmin) to a local server a huge file (20GB) in order to fill up a database. The uploding completed and the transactions started. But unfortunately, ...
    dafNi zafdafNi zaf
    Aug 8, 2013 at 2:33 pm
    Aug 8, 2013 at 3:33 pm
  • is there a bug in age()? test=*# select *, age(birthday), age (current_date-1, birthday) from birthday ; id | birthday | age | age ----+------------+---------+------------------------- 1 | 2010-08-29 ...
    Andreas KretschmerAndreas Kretschmer
    Aug 29, 2013 at 7:11 pm
    Aug 30, 2013 at 7:44 am
  • Hello: Sorry for disturbing. I am now encountering a serious problem: memory is not enough. My customer reported that when they run a program they found the totall memory and disk i/o usage all ...
    Aug 26, 2013 at 6:08 am
    Aug 29, 2013 at 8:26 pm
  • I wrote an extension and marked one of the tables it creates as a config table using pg_extension_config_dump(). This caused the data to be dumped and restored correctly, but the sequence attached to ...
    Moshe JacobsonMoshe Jacobson
    Aug 20, 2013 at 6:25 pm
    Aug 28, 2013 at 2:53 pm
  • Hi, I'm seeing cases where I have temp files being written on commit, such as. 2013-08-16 12:09:02 GMT [14480]: [588-1] user=dbuser,db=dbname STATEMENT: COMMIT 2013-08-16 12:09:02 GMT [14480] ...
    Nicholson, Brad (Toronto, ON, CA)Nicholson, Brad (Toronto, ON, CA)
    Aug 22, 2013 at 3:21 pm
    Aug 23, 2013 at 3:13 pm
  • I'm doing a JOIN which is very slow: JOIN t ON t.f1 LIKE (q.f1 || '%') t1 has an INDEX on (f1, f2) which I thought would help for this. But Postgres seems to still use a (very slow) Nested Loop. What ...
    Robert JamesRobert James
    Aug 13, 2013 at 10:05 pm
    Aug 15, 2013 at 2:20 pm
  • Hello. I have been reading the -http://opensource.org/licenses/postgresql- to know if i can use PostgreSQL in a Privative Closed Commercial Software (The worst of the worst :P ). in the company where ...
    Eliseo ViolaEliseo Viola
    Aug 7, 2013 at 3:23 pm
    Aug 7, 2013 at 6:21 pm
  • Hello, I have a composite datatype abc which has two integer fields x,y. I have a table Test which has an array of abc. I am trying to populate Test. Tried insert into test values (ARRAY[abc(1,2)]) ...
    Sameer ThakurSameer Thakur
    Aug 7, 2013 at 10:34 am
    Aug 7, 2013 at 5:58 pm
  • Hi, I have a string like: Gloucester Catholic vs. St. Augustine baseball, South Jersey Non-Public A final, June 5, 2013 I need to extract date part from the string. I used the follows ...
    AI RummanAI Rumman
    Aug 27, 2013 at 6:44 pm
    Aug 28, 2013 at 3:29 pm
  • Hello, the issue can be show with this example: piro= SET TIMEZONE = 'America/New_York'; SET piro= select '1970-01-01T00:00:00+03:00'::timestamp; timestamp --------------------- 1970-01-01 00:00:00 ...
    Daniele VarrazzoDaniele Varrazzo
    Aug 20, 2013 at 11:00 am
    Aug 22, 2013 at 5:58 pm
  • I have a table that has around 8 million rows. The table has 71 columns and 33 indexes. The relevant indexes are: "callingpartynumber" btree ("CallingPartyNumber") "callingpartynumber_lower" btree ...
    Tyler ReeseTyler Reese
    Aug 16, 2013 at 10:44 pm
    Aug 19, 2013 at 5:03 pm
  • Dear Srs Could you please help me to fix the error shown in attachment, i'm use windows 7. ----------------------- Melhores cumprimentos / Best regards *Thodi Viola* Geólogo de Pesquisa / Exploration ...
    Thodi ViolaThodi Viola
    Aug 13, 2013 at 3:57 pm
    Aug 14, 2013 at 1:26 pm
  • I'm going through all my usual steps for setting up streaming replication on a new pair of servers. Modify configs as appropriate, rsync data from master to slave, etc. I have this all automated with ...
    Quentin HartmanQuentin Hartman
    Aug 8, 2013 at 11:55 pm
    Aug 9, 2013 at 7:32 pm
  • The company I work for has a client who has expressed interest in having a staging database for their data. Staging as in they add data, do some QCing, then push to a database with an identical ...
    Aug 7, 2013 at 4:01 am
    Aug 7, 2013 at 3:53 pm
  • Good morning all, I am trying to get a better understanding of how schemas can be used to limit access to objects, and I seem to be failing miserably. Can anyone point me to documentation about, or a ...
    Melvin CallMelvin Call
    Aug 2, 2013 at 4:33 pm
    Aug 2, 2013 at 6:52 pm
  • HI In our current project, we are opening several postgresql connection. Few connections are frequently used and few are occasionally used. Hence we plan to adapt connection pool method to avoid more ...
    Yelai, Ramkumar IN BLR STSYelai, Ramkumar IN BLR STS
    Aug 27, 2013 at 8:36 am
    Aug 28, 2013 at 12:56 pm
  • Hi all, My compagny would like to configure replication between PostgreSQL 9.2.4 and Oracle Database (11g and maybe 12c soon). We saw that Postgres Plus Database Replication could be a good solution ...
    BOUVARD AurélienBOUVARD Aurélien
    Aug 7, 2013 at 8:24 am
    Aug 27, 2013 at 1:58 am
Group Navigation
period‹ prev | Aug 2013 | next ›
Group Overview
grouppgsql-general @

208 users for August 2013

Adrian Klaver: 39 posts Tom Lane: 33 posts Jeff Janes: 23 posts Kevin Grittner: 21 posts Ascot Moss: 18 posts Sergey Konoplev: 18 posts BladeOfLight16: 17 posts David Johnston: 16 posts John R Pierce: 16 posts Luca Ferrari: 14 posts Robert James: 14 posts Don Parris: 13 posts Michael Paquier: 13 posts Alban Hertroys: 11 posts Chris Travers: 11 posts Ivan Radovanovic: 11 posts Bruce Momjian: 10 posts Pavel Stehule: 10 posts Torello Querci: 10 posts Albe Laurenz: 9 posts
show more