Search Discussions

178 discussions - 916 posts

  • http://www.dbms2.com/2011/11/23/hope-for-a-new-postgresql-era/ Some of the points mentioned: - MySQL is narrowing the gap, but PostgreSQL is still ahead of MySQL in some ways. (Database extensibility ...
    Rodrigo E. De León PlicetRodrigo E. De León Plicet
    Dec 8, 2011 at 3:11 am
    Dec 13, 2011 at 11:22 pm
  • I upgraded to PostgreSQL 9.1. I was using 8.4 previously. My problem is with the new version of pg_dump. It no longer (consistently) dumps my sequence values correctly. For example, I have a table ...
    Greg DonaldGreg Donald
    Dec 28, 2011 at 5:20 am
    Dec 29, 2011 at 5:54 pm
  • You may have seen this, but RedGate software is sponsoring a contest to send a DBA on a suborbital space flight. And there is a PostgreSQL representative....me! ...
    Joe MillerJoe Miller
    Dec 6, 2011 at 4:56 pm
    Dec 24, 2011 at 11:22 pm
  • Hi, I asked elsewhere about the best way to store db credentials within a user-session of a web-app. It appeared that it was for everybody but me evident that instead of heaving a db-role+passwd for ...
    Dec 14, 2011 at 12:33 pm
    Dec 15, 2011 at 8:26 pm
  • In fresh Debian installation default system locale is set to et_EE.UTF-8 using dpkg-reconfigure locales Postgres is installed using apt-get update apt-get -t squeeze-backports install postgresql-9.1 ...
    Dec 21, 2011 at 6:29 pm
    Dec 23, 2011 at 5:48 pm
  • Hi, we're currently investigating a statistics issue on postgres. We have some tables which frequently show up with strange values for n_live_tup. If you compare those values with a count on that ...
    Andreas BrandlAndreas Brandl
    Dec 8, 2011 at 4:19 pm
    Dec 9, 2012 at 8:05 pm
  • Hello fellow postgres users, in my game using PostgreSQL 8.4.9 players can purchase a VIP ("very important person") status: # \d pref_users; Table "public.pref_users" Column | Type | Modifiers ...
    Alexander FarberAlexander Farber
    Dec 29, 2011 at 6:16 pm
    Jan 2, 2012 at 11:01 pm
  • Hi, I have 2 cluster databases, running on the same host, Linux with redHat. My fist database port is set to default, 5432, but my second database port is set to 5436 in the postgresql.conf file. ...
    Jacques LamotheJacques Lamothe
    Dec 27, 2011 at 7:07 pm
    Dec 27, 2011 at 7:49 pm
  • Hi List, When I try to change my db password like below SQL statement from psql or pgAdmin tool, it outputs to server logs as like this: *postgres=# alter user mkoc password 'dummy'; ALTER ROLE ...
    Dec 19, 2011 at 1:01 pm
    Dec 19, 2011 at 10:59 pm
  • For a PostgreSQL 9.1.1 instance, I have used the following postgresql.conf settings: max_connections = 100 shared_buffers = 400MB wal_buffers = 16MB All the other parameters have been left as default ...
    Christoph ZwerschkeChristoph Zwerschke
    Dec 3, 2011 at 12:39 pm
    Dec 4, 2011 at 9:24 pm
  • Hello, after several attempts I have finally succeeded in developing a urlencode() function to encode text correctly like defined in RFC 1738. Now i have a big problem: how to decode the text? ...
    Torsten ZuehlsdorffTorsten Zuehlsdorff
    Dec 2, 2011 at 1:47 pm
    Dec 23, 2011 at 2:15 pm
  • I've finally received my new virtual database server (Debian Linux) & this weekend I'll be rolling my new PostgreSQL server online. My question is I've never migrated production data from 8.4.8 to ...
    Carlos MennensCarlos Mennens
    Dec 12, 2011 at 5:12 pm
    Dec 15, 2011 at 4:18 pm
  • Oddball data distribution giving me headaches. We have a distinct 'customer' table with customer_id, type and name/demographic information. Assume some 1 million rows in the customer table. We then ...
    Jeff AmielJeff Amiel
    Dec 2, 2011 at 8:19 pm
    Dec 3, 2011 at 9:13 am
  • Hi, I have installed postgresql-9.0 on my CentOS 6.0 server in the directory /usr/pgsql-9.0/. Its data directory resides in /var/lib/pgsql/9.0/ unable to run $psql dbname command when i run the ...
    Dec 28, 2011 at 9:54 am
    Dec 29, 2011 at 8:25 am
  • I have a very long query. Due to the planner and good indexing, it runs quite fast. But it's so long, it's quite hard to follow. I'm trying to break it up into pieces, but am running up against ...
    Robert JamesRobert James
    Dec 12, 2011 at 12:46 am
    Dec 15, 2011 at 9:53 am
  • Hello I am trying to migrate a database from 8.4.0 to 9.1.2 on a test server before updating the production server. When piping the dump file created with pg_dump in psql I am getting duplicate key ...
    Culley HarrelsonCulley Harrelson
    Dec 30, 2011 at 2:33 pm
    Dec 30, 2011 at 4:59 pm
  • http://triangle-newhomes.com/view_articles.php?mid=46&detail=917&topic=89&topic=767&string=24
    Gouse shaikGouse shaik
    Dec 3, 2011 at 2:37 am
    Dec 30, 2011 at 6:31 am
  • Dear List, I found this interesting: SELECT regexp_matches('123-A' , E'(3[A-Z\- ])'); ERROR: invalid regular expression: invalid character range whereas: SELECT regexp_matches('123-A' , E'(3[\- ...
    Dec 13, 2011 at 1:05 pm
    Dec 13, 2011 at 4:59 pm
  • Some of my code involves transactions which will not have significant effect on the database. It might be a read-only transaction (possibly declared as one, but possibly not), or perhaps a completely ...
    Chris AngelicoChris Angelico
    Dec 18, 2011 at 2:53 am
    Dec 25, 2011 at 12:30 am
  • Hi all, Somewhy fsync does not work for me. PgSql 9.1.2 Debian, 2.6.32 kernel WAL filesystem: ext4 with defaults config: fsync=on sync_commit=on wal_sync_method=fsync Even though the TPS in pgbench ...
    Havasvölgyi OttóHavasvölgyi Ottó
    Dec 19, 2011 at 3:52 pm
    Dec 22, 2011 at 10:32 am
  • For the boolean column Foo in Table1, if I want to index all values of TRUE, is this syntax correct? CREATE INDEX IDX_MyIndex ON Table1(Foo) WHERE Foo; The query: SELECT * FROM Table1 WHERE Foo; ...
    Mike ChristensenMike Christensen
    Dec 15, 2011 at 4:43 am
    Dec 15, 2011 at 3:31 pm
  • Hey guys, In PG 8.x, when I did an initdb with --lc-collate=c it was always effective in setting it server wide so it would apply to all databases. However, in 9.1.2, when I run initdb like so: ...
    Scot KreienkampScot Kreienkamp
    Dec 12, 2011 at 6:50 pm
    Dec 13, 2011 at 4:58 pm
  • Hallo, psql latex output format needs to differentiate between a newline and a tabularnewline. the problem arises when u have a field value that contains a newline character, when this field is not ...
    Wim BertelsWim Bertels
    Dec 12, 2011 at 6:15 pm
    May 2, 2012 at 8:30 pm
  • Hi I am having problems recovering storage from a Postgres 9.05 database that is used to hold large XML blocks for a week, before they are archived off line. The main tables are partitioned in daily ...
    Simon WindsorSimon Windsor
    Dec 14, 2011 at 8:01 pm
    Jan 9, 2012 at 2:02 pm
  • I need to convert timestamp to a format with a time zone offset, like this: select clock_timestamp()::text; which returns: "2011-12-30 11:59:06.538+01" What is the default format for timestamp::text ...
    Cezariusz MarekCezariusz Marek
    Dec 30, 2011 at 11:05 am
    Dec 30, 2011 at 5:49 pm
  • I am bumping into some performance issues and am seeking help. I have two tables A and B in a one (A) to many (B) relationship. There are 1.4 million records in table A and 44 million records in ...
    Culley HarrelsonCulley Harrelson
    Dec 20, 2011 at 11:57 pm
    Dec 21, 2011 at 11:40 pm
  • I see Postgres (I'm using 8.3) has bitwise aggregate functions (bit_or), but doesn't seem to have logical aggregate functions. How do I do the equivalent of an ANY() or ALL() in PG Aggregate SQL?
    Robert JamesRobert James
    Dec 15, 2011 at 4:10 pm
    Dec 19, 2011 at 1:02 pm
  • Do many of you implement fine grained security provisions at the DBMS level using GRANT PRIVILEGE ON object TO user/role? My background with DBMS security is mostly in CODASYL shallow network systems ...
    James B. ByrneJames B. Byrne
    Dec 8, 2011 at 9:47 pm
    Dec 9, 2011 at 6:49 pm
  • Is there any way to get the database system identifier via a select statement? I have a primary/secondary async replication setup, and I'd like be able to verify from the client side that the ...
    Chris RedekopChris Redekop
    Dec 8, 2011 at 6:08 pm
    Dec 9, 2011 at 2:16 pm
  • Hi, We are planning to use Postgres 9.1 in our commercial product having a coldfire m68k architecture based controller on Linux platform. Since ready installer was not present for this architecture, ...
    Jayashankar K BJayashankar K B
    Dec 5, 2011 at 8:24 am
    Dec 6, 2011 at 12:37 am
  • Hello. This is my first post. As such, feedback on style and choice of venue are especially welcome. I am a regular but not especially expert user of a variety of databases, including postgreSQL. I ...
    C. MundiC. Mundi
    Dec 5, 2011 at 6:31 pm
    Dec 5, 2011 at 11:00 pm
  • I have a database full of recipes, one recipe per row. I need to store a bunch of arbitrary "flags" for each recipe to mark various properties such as Gluton-Free, No meat, No Red Meat, No Pork, No ...
    Mike ChristensenMike Christensen
    Dec 5, 2011 at 4:10 am
    Dec 5, 2011 at 4:42 pm
  • Hi, I have 2 cluster databases, running on the same host, Linux with redHat. My fist database port is set to default, 5432, but my second database port is set to 5436 in the postgresql.conf file. ...
    Jacques LamotheJacques Lamothe
    Dec 21, 2011 at 1:26 pm
    Jan 20, 2012 at 9:01 pm
  • Hi, I try to run postgresql on my mips based openwrt router. Although openwrt provides precompiled packages, I have troubles initializing postgresql's file system: # creating template1 database in ...
    Clemens EissererClemens Eisserer
    Dec 22, 2011 at 10:29 pm
    Jan 8, 2012 at 11:01 pm
  • I've been asked to stand up a dedicated database server for a new office. They're only requirement is the server run RHEL 6.2 64-bit. I told them no problem as I'm very familiar with Linux and ...
    Carlos MennensCarlos Mennens
    Dec 30, 2011 at 4:51 pm
    Dec 30, 2011 at 5:53 pm
  • Hi, is there a way I can detect if the current session has any uncommitted changes? I'm not trying to find uncommitted changes from other sessions (connections) only for the *current* one. I thought ...
    Thomas KellererThomas Kellerer
    Dec 27, 2011 at 6:29 pm
    Dec 28, 2011 at 9:50 am
  • Dear all, I am facing a unique issue when I try to load an sql into a postgresql database :- ERROR: invalid byte sequence for encoding "UTF8": 0xe32720 HINT: This error can also happen if the byte ...
    Adarsh SharmaAdarsh Sharma
    Dec 26, 2011 at 7:21 am
    Dec 27, 2011 at 2:40 pm
  • Hi, Unable to connect to PostgreSQL server : Could not get socket error status: No such file or directory in index.php on line 5 Can any one help me on this ? I am getting the following error when I ...
    Shankar PalaniappanShankar Palaniappan
    Dec 22, 2011 at 9:41 am
    Dec 26, 2011 at 10:48 pm
  • Hi, I'm running postgres 8.3.17 on a redhat linux mips derivative and I've observed a postgres crash and the subsequent messages in my postgres debug log. 2011-12-21 19:08:49 UTC - LOG: shutting down ...
    Hanns HartmanHanns Hartman
    Dec 22, 2011 at 12:48 am
    Dec 22, 2011 at 6:43 pm
  • I'm wanted to find out why is it recommended or even an option to lock tables during a backup of a database? I've never experimented with database backups so I'm only guessing it locks / freezes the ...
    Carlos MennensCarlos Mennens
    Dec 14, 2011 at 5:52 pm
    Dec 15, 2011 at 8:27 am
  • I'm trying to install PG9.1 on RHEL5 and I have some problems with it. Currently there is some old version of PG90 installed but theoretically 90 & 91 should cohabit together without any problems. ...
    Dec 11, 2011 at 5:41 pm
    Dec 12, 2011 at 6:05 pm
  • Hello All, I'm currently on a development team utilizing PostgreSQL and we are looking into the possibility of using dblink to reference an external database (read only). Our system administrator and ...
    Alex BibleAlex Bible
    Dec 7, 2011 at 4:14 pm
    Dec 7, 2011 at 9:49 pm
  • Hello, i have a problem. I've got a production server, working fine. Then i've got strange error: instead of expected 146 in index "order_status_key"' And decidet to backup all server. So i shut-down ...
    Oleg SerovOleg Serov
    Dec 2, 2011 at 1:08 am
    Dec 3, 2011 at 3:31 pm
  • Hi, I've installed PostgreSQL 9.0 in CentOS6 I don't have configured anything in Postgre, I just created a user with this method: [article] Here is how I do to create a Postgres user with the same ...
    Andre LopesAndre Lopes
    Dec 2, 2011 at 11:13 pm
    Dec 2, 2011 at 11:52 pm
  • Hi I am struggling with the volume and number of XML files a new application is storing. The table pg_largeobjects is growing fast, and despite the efforts of vacuumlo, vacuum and auto-vacuum it ...
    Simon WindsorSimon Windsor
    Dec 30, 2011 at 11:55 pm
    Jan 3, 2012 at 11:13 am
  • Respected, Am in PG 9.1. See below ouputs. *By query:* postgres=# SELECT name, setting, unit,context FROM pg_settings WHERE category like '%Resource Usage / Memory%' ORDER BY name; name | setting | ...
    Dec 27, 2011 at 9:26 am
    Dec 28, 2011 at 5:28 am
  • Why does index not use for CTE query? I am using Postgresql 9.1 select version(); version -------------------------------------------------------------------------------------------------------- ...
    AI RummanAI Rumman
    Dec 27, 2011 at 8:45 am
    Dec 27, 2011 at 10:38 am
  • Hi folks, In a Perl application I would like to frequently bulk load several hundred thousand rows of data into a temporary table before merging the contents into the database proper. I'm currently ...
    Roger LeighRoger Leigh
    Dec 19, 2011 at 11:57 am
    Dec 22, 2011 at 1:16 am
  • Hello, Why I can not do something like this in Postgres.  SELECT 1 as a , 2 as b , a + b as c ; Regards
    Salah jubehSalah jubeh
    Dec 21, 2011 at 11:39 am
    Dec 21, 2011 at 4:06 pm
  • Hello, I have a problem with PL/Proxy (sorry for not posting to plproxy-users, but I have some problem subscribing there). I try to use it to achieve "single node paralellism" - as MattK nicely put ...
    Filip RembiałkowskiFilip Rembiałkowski
    Dec 17, 2011 at 9:26 pm
    Dec 20, 2011 at 4:59 pm
Group Navigation
period‹ prev | Dec 2011 | next ›
Group Overview
grouppgsql-general @

225 users for December 2011

Adrian Klaver: 61 posts Tom Lane: 41 posts David Johnston: 32 posts Merlin Moncure: 29 posts Craig Ringer: 27 posts John R Pierce: 23 posts Tomas Vondra: 21 posts Alban Hertroys: 16 posts Carlos Mennens: 16 posts Devrim Gündüz: 14 posts Pavel Stehule: 14 posts Scott Marlowe: 14 posts Bèrto ëd Sèra: 13 posts Chris Travers: 12 posts Jacques Lamothe: 11 posts Chris Angelico: 10 posts Greg Donald: 10 posts Raymond O'Donnell: 10 posts Maxim Boguk: 9 posts Raghavendra: 9 posts
show more