Search Discussions

195 discussions - 993 posts

  • Hello fellow PostgreSQL-users, I run a Drupal 7 (+Facebook app) website with a multiplayer flash game and use postgresql-server-8.4.8-1PGDG.rhel5 + CentOS 5.6 64 bit on a Quad-Core/4GB machine. I ...
    Alexander FarberAlexander Farber
    May 25, 2011 at 6:25 pm
    Jun 26, 2011 at 10:26 pm
  • Hi, Is there any way to do bidirectional replication for Postgresql Plus Advance Server 8.4.5? I tried SLONY-I but its master-slave asynchronous replication. Can we configure master-master ...
    Tushar neheteTushar nehete
    May 3, 2011 at 6:15 am
    May 29, 2011 at 4:48 am
  • now all the question: 1.how start a procedure or a script after postgresql start. 2.how to get notify when a table created. 3.how to get notify when a database created.
    Jun yangJun yang
    May 22, 2011 at 4:57 am
    May 24, 2011 at 9:27 am
  • As a (lapsed) electronics design engineer, I'm suspicious of the notion that a subassembly consisting of solid state devices surface-mounted on FR4 substrate will fail except in very rare (and of ...
    David BorehamDavid Boreham
    May 4, 2011 at 7:50 pm
    May 19, 2011 at 2:17 am
  • Respected Committers, It may be a silly question, still out of curiosity I want to know, is there any possible way to flush the Postgres Shared Memory without restarting the cluster. In Oracle, we ...
    Raghu ramRaghu ram
    May 3, 2011 at 11:12 am
    May 3, 2011 at 6:44 pm
  • I created a modifier for auto incrementing my primary key as follows: records=# \d users Table "public.users" Column | Type | Modifiers ...
    Carlos MennensCarlos Mennens
    May 16, 2011 at 6:26 pm
    May 17, 2011 at 8:46 pm
  • There might be a very cheap and simple way to help reduce the number of people running into problems because they set massive max_connections values that their server cannot cope with instead of ...
    Craig RingerCraig Ringer
    May 26, 2011 at 2:58 am
    May 30, 2011 at 12:46 am
  • Hi, the doc pages are somehow "cryptic" regarding FILLFACTOR. (well, at least they're cryptic to me, since I don't know a lot of btree stuff...) I have an index on a timestamp value that is inserted, ...
    Leonardo FrancalanciLeonardo Francalanci
    May 8, 2011 at 6:57 am
    Jun 12, 2011 at 10:18 pm
  • Hi All, I am little confused about the internal working of PostgreSQL. There is a parameter shared_buffer in postgres.conf and I am assuming that it is used for buffer management in PostgreSQL. If ...
    Preetika tyagiPreetika tyagi
    May 27, 2011 at 7:37 pm
    May 31, 2011 at 11:16 am
  • In my environment which is linux on the server side and both windows and linux on the client side I have noticed that the introduction of pg_notify (with payload) makes the size of the postgres ...
    Per-Olov EsgardPer-Olov Esgard
    May 26, 2011 at 12:42 pm
    May 30, 2011 at 8:13 pm
  • Dear all, I need to research on Memcache in the next few days. What I want to know is it worth to have memcahed enable in our Mysql/ Postgres Production Servers. We have databases from 20 to 230 GB ...
    Adarsh SharmaAdarsh Sharma
    May 17, 2011 at 5:09 am
    May 23, 2011 at 5:50 am
  • Hi, I've got a question about quite a strange configuration. I was asked if we can have one storage, with one data directory where one postgresql instance writes data, and many other instances read ...
    Szymon GuzSzymon Guz
    May 18, 2011 at 11:21 am
    May 19, 2011 at 8:30 am
  • Hello everybody, I was experimenting with the FTS feature on postgres 8.3.4 lately and encountered a weird performance issue when using a custom FTS configuration. I use this german ispell ...
    Stanislav RaskinStanislav Raskin
    May 11, 2011 at 11:29 am
    May 12, 2011 at 8:26 am
  • Hi, Id like to familiarize with postgresql and looking for a decent CBT but not able to find it. Could someone help pls? Sent from my iPhone
    May 24, 2011 at 6:06 am
    May 25, 2011 at 2:25 am
  • Hi, pg_upgrade brakes with the following error: pg_upgrade 8.4.5 to 9.0.4: Restoring user relation files /data1/postgres/pgsql/foo/data_8.4/base/11564/2613 ^M ...
    Jens WilkeJens Wilke
    May 4, 2011 at 12:19 pm
    May 6, 2011 at 4:44 pm
  • Hi, I have installed postres/postgis 9 in win7. I tried to edit pg_hba.conf not as postgres user and although i cancelled all changes I can start my postgres any more...... Now I am thinking of ...
    G. P.G. P.
    May 17, 2011 at 9:59 pm
    May 19, 2011 at 2:28 am
  • It is required for application data verification filters that default values for table columns are known to ActiveRecord when creating a new row. So ActiveRecord obtains the default values from the ...
    James B. ByrneJames B. Byrne
    May 12, 2011 at 1:19 pm
    May 18, 2011 at 12:48 am
  • Dear all - I would like to know if any one has migrated database from MS access to Postgres . We use postgres 9.0.2 on solaris . Are there any open source tools that you have used to do this task. ...
    Akp geekAkp geek
    May 25, 2011 at 7:49 pm
    Jun 2, 2011 at 4:06 pm
  • PostgreSQL 9.0.4 The following script fails even though the "pkonlytest" table is empty since we just created it. CREATE TABLE pkonlytest ( pkid text PRIMARY KEY ); CREATE OR REPLACE FUNCTION ...
    David JohnstonDavid Johnston
    May 30, 2011 at 9:09 pm
    May 31, 2011 at 10:15 pm
  • Hi, I’d like to monitor a table in a read-only Postgres database by writing a PL/pgSQL function. The database gets periodically overwritten by a mirroring loading process. The success criteria is, ...
    Stefan KellerStefan Keller
    May 28, 2011 at 7:13 pm
    May 30, 2011 at 9:06 pm
  • Hello I am trying to move a postgres cluster with 90 databases and around 140GB of data between two servers (8.3.12 - 8.3.15). I am using 'pg_dumpall | psql' in the process and everything works ok ...
    Rafael MartinezRafael Martinez
    May 25, 2011 at 11:30 am
    May 25, 2011 at 1:25 pm
  • I had the following error during compile of sepgsqk contrib: root@postgresql:~/postgresql-9.1beta1/contrib/sepgsql# make sed 's,MODULE_PATHNAME,$libdir/sepgsql,g' sepgsql.sql.in sepgsql.sql gcc -O2 ...
    Emanuel Calvo FrancoEmanuel Calvo Franco
    May 20, 2011 at 9:03 am
    May 24, 2011 at 6:14 pm
  • Hi list I use PostgreSQL 8.4.4. (with Postgis 1.4) I have a simple update query that takes hours to run. The table is rather big (2 millions records) but it takes more than 5 hours to run !! The ...
    F TF T
    May 9, 2011 at 2:40 pm
    May 13, 2011 at 6:50 pm
  • What is the preferred way to share tables between databases? I read about dblink but it doesn't seem optimal because it needs to pull in the entire query every time the view is referenced so it might ...
    Tim UckunTim Uckun
    May 12, 2011 at 12:48 am
    May 13, 2011 at 5:17 am
  • Hi, If I understand correctly, Tom's reply in: http://archives.postgresql.org/pgsql-general/2007-06/msg01668.php suggests that temp schemas are kept when a session gets disconnected because ...
    Marek WięckowskiMarek Więckowski
    May 2, 2011 at 7:52 am
    May 12, 2011 at 1:58 pm
  • Hi My postgresql client (ejabberd postgresql lib) does not seem to be capable of ssl connection to postgresql server (with hostssl in pg_hba) So I tried to use run stunnel on the client box ...
    Zhong ming wuZhong ming wu
    May 9, 2011 at 2:36 pm
    May 10, 2011 at 2:04 pm
  • Hi: From within a perl/DBI script, I want to be able to make a copy of a record in a table, changing only the value of the primary key. I don't know in advance what all the columns are, just the ...
    Gauthier, DaveGauthier, Dave
    May 26, 2011 at 8:33 pm
    Jul 24, 2011 at 3:44 am
  • Hello Guys, In a multi-threaded server program using Postgresql 8.3.5 with ECPG interface for C, we have problems using descriptors (and possibly cursors). We have created a common database interface ...
    Leif JensenLeif Jensen
    May 23, 2011 at 12:52 pm
    Jun 2, 2011 at 7:21 pm
  • EXECUTE 'SELECT 1 FROM ' || TG_TABLE_NAME || ' WHERE ' || whereclause I am generating the whereclause dynamically as the number of columns queried varies. Am I right in assuming that I cannot use ...
    Tarlika Elisabeth SchmitzTarlika Elisabeth Schmitz
    May 22, 2011 at 5:38 pm
    May 31, 2011 at 10:39 am
  • What is the best way to handle multiple table relationships where attributes of the tables at the ends of the chain must match? Example: CREATE TABLE achievements( achievement_id serial PRIMARY KEY, ...
    Jack ChristensenJack Christensen
    May 5, 2011 at 7:20 pm
    May 9, 2011 at 1:35 pm
  • Somebody is making a very specific claim that Postgres can support a limited number of rows: "INPS (a data forensics team) said that there is 7 main Databases all hosted at different data centers but ...
    Mark Morgan LloydMark Morgan Lloyd
    May 1, 2011 at 6:00 am
    May 2, 2011 at 6:59 am
  • I'm doing some tests with date-time related fields to design my web application. I was already dissatisfied with Postgresql handling of timezones concepts (issue already discussed here - not entirely ...
    Hernan gonzalezHernan gonzalez
    May 31, 2011 at 4:45 pm
    Jun 1, 2011 at 5:54 pm
  • Hi, I have build an index. When, i execute the query, it gives the result by sequential scan, not by using my index. I have already run vacuum analyze to collect some statistics regarding table. May ...
    Nick RajNick Raj
    May 23, 2011 at 12:01 pm
    May 24, 2011 at 9:02 am
  • Hi ! I'm running "PostgreSQL 9.0.2, compiled by Visual C++ build 1500, 32-bit" I have found an odd behaviour in pl/pgsql when using 'return query execute' The function produce the dynamic query ...
    Dan SDan S
    May 21, 2011 at 1:41 pm
    May 22, 2011 at 4:26 am
  • Hey guys, If I get H1B visa as Postgresql DBA, then what may I expect to get as my salary? Does anyone have idea on this? Thanks.
    AI RummanAI Rumman
    May 19, 2011 at 5:52 am
    May 19, 2011 at 4:18 pm
  • Hi there, We'd like to use a plpgsql function to use results from query A to execute several queries B, C, etc., and return the results of all B, C, etc queries as one result set. Would placing ...
    Bernardo TellesBernardo Telles
    May 16, 2011 at 3:53 am
    May 17, 2011 at 12:51 pm
  • Hi Been reading some old threads (pre 9.x version) and it seems that the consensus is to avoid doing massive deletes from a table as it'll create so much unrecoverable space/gaps that vacuum full ...
    Phoenix KiulaPhoenix Kiula
    May 12, 2011 at 2:23 pm
    May 12, 2011 at 8:09 pm
  • Hi, I would use custom types in several stored functions and I would my sotred function return these custom types. I would launch stored functions and retrieve results by JDBC interface: is it ...
    May 11, 2011 at 7:19 am
    May 11, 2011 at 3:50 pm
  • Hi, We have certain types of query that seems to take about 900ms to run according to postgres logs. When I try to run the same query via command line with "EXPLAIN ANALYZE", the query finishes very ...
    John ChengJohn Cheng
    May 5, 2011 at 3:03 pm
    Jul 27, 2011 at 7:56 pm
  • Hello, after configuring a new home server with PostgreSQL 9.0.4, I observe some regular disk activity, even though the server is completely idle (disconnected from the network, no users but one ...
    Andrej PodzimekAndrej Podzimek
    May 28, 2011 at 3:07 pm
    May 31, 2011 at 2:11 pm
  • I need to calculate the long/lat values between a line demarcated by two long/lat points. The points will be very close, but there is the 180 degree problem to consider, so a simple average won't ...
    Carlo StonebanksCarlo Stonebanks
    May 25, 2011 at 4:52 pm
    May 26, 2011 at 9:18 pm
  • PG tends to be picked on by the Linux OOM killer, so lately we've been forcing the OOM killer to kill other processes first with this script: while true; do for i in `pgrep postgres`; do echo -17 ...
    Yang ZhangYang Zhang
    May 25, 2011 at 12:33 am
    May 25, 2011 at 6:52 pm
  • Hi ! I'm running "PostgreSQL 9.0.2, compiled by Visual C++ build 1500, 32-bit". I'm trying to get type information on functions out of information_schema. When there is an array as input or output of ...
    Dan SDan S
    May 21, 2011 at 5:59 pm
    May 21, 2011 at 7:11 pm
  • Hi, I'm trying to implementing the checking in and checking out of items in a table, whereby an item cannot be checked out if it's not checked-in. I've searched for schemas for public libraries where ...
    May 20, 2011 at 1:41 pm
    May 20, 2011 at 7:00 pm
  • Yeah, on that subject, anybody else see this: < Absolutely pathetic. -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice
    Scott RibeScott Ribe
    May 4, 2011 at 3:07 pm
    May 6, 2011 at 1:50 am
  • hi all I am trying to create a second instance of PostgreSQL (8.3) on a Windows 2003 server with initdb, but am running into an error message I can't seem to resolve. Here's what I've done so far: ...
    May 31, 2011 at 3:16 pm
    Jun 1, 2011 at 2:10 pm
  • Hi, I am trying to generate self-signed certificate for full ssl authentication. I need to have universal version of this certificate for development purposes (so any client can connect with any ...
    May 30, 2011 at 9:01 pm
    May 31, 2011 at 10:47 am
  • Suppose you want to write a program that connects to a PostgreSQL database and lists its tables and views, the type of their columns and their relationships (REFERENCES) for automatic joins. Would ...
    Andre MajorelAndre Majorel
    May 27, 2011 at 5:33 pm
    May 30, 2011 at 9:01 pm
  • Hi, I have Debian Lenny server with Postgres 8.3 that is workin correctly, but I have some questions about this installation. This server is working whitout any problem but it is a little critical ...
    Trenta sisTrenta sis
    May 23, 2011 at 10:10 pm
    May 28, 2011 at 11:49 am
  • I'm running 9.0.3, and recently started getting temp files being created. This is a problem because it's making a bunch of dirty buffers that have to be flushed to disk and my poor little disk isn't ...
    Ben ChobotBen Chobot
    May 25, 2011 at 4:39 pm
    May 26, 2011 at 4:15 am
Group Navigation
period‹ prev | May 2011 | next ›
Group Overview
grouppgsql-general @

261 users for May 2011

Tom Lane: 60 posts Craig Ringer: 50 posts Merlin Moncure: 40 posts David Johnston: 31 posts John R Pierce: 27 posts Scott Marlowe: 27 posts Pavel Stehule: 25 posts Greg Smith: 21 posts Tomas Vondra: 17 posts Andrew Sullivan: 16 posts Cédric Villemain: 13 posts Adarsh Sharma: 11 posts Rick Genter: 11 posts Adrian Klaver: 10 posts Raymond O'Donnell: 10 posts Salah jubeh: 10 posts Seb: 10 posts Alban Hertroys: 9 posts Albe Laurenz: 9 posts Bosco Rama: 9 posts
show more