FAQ

PostgreSQL > pgsql-general > October 2006

Search Discussions

305 discussions - 1,571 posts

  • http://www.zabbix.com/manual/v1.1/install.php in section PostgreSQL vs MySQL : [quoting] Regarding the choice between PostgreSQL and MySQL, MySQL is recommended for several reasons: * MySQL is faster ...
    Merlin MoncureMerlin Moncure
    Oct 10, 2006 at 5:56 pm
    Oct 17, 2006 at 8:43 pm
  • Hello, I think I'm about to ask a traditional (almost religious) question, but I haven't been able to find a crystal clear answer in the mailing lists so far. Thus, here is my question: I need to ...
    TIJodTIJod
    Oct 4, 2006 at 10:03 am
    Jun 28, 2007 at 12:42 am
  • While all the talk of a hinting system over in hackers and perform is good, and I have a few queries that could live with a simple hint system pop up now and again, I keep thinking that a query ...
    Scott MarloweScott Marlowe
    Oct 12, 2006 at 8:32 pm
    Oct 17, 2006 at 6:53 pm
  • Hello, I am running into this limitation ALOT with Tsearch2. What are my options to get around it. Do I have to compile PostgreSQL with a different block size? If yes, what are the downsides to doing ...
    Joshua D. DrakeJoshua D. Drake
    Oct 25, 2006 at 10:46 pm
    Nov 3, 2006 at 6:03 pm
  • Hi all, i have a Tomcat application with PostgreSQL 8.1.4 running which performs about 10000 inserts/deletes every 2-4 minutes and updates on a database and after some hours of loadtesting the top ...
    Peter BauerPeter Bauer
    Oct 1, 2006 at 6:29 am
    Oct 10, 2006 at 5:49 am
  • I am trying to perform a complete dump of my database. However, I am getting an error when pg_dumpall reaches one particular database. I reformatted the text so that it wouldn't get chopped to pieces ...
    Richard Broersma JrRichard Broersma Jr
    Oct 26, 2006 at 3:07 am
    Oct 27, 2006 at 9:28 pm
  • I was just reading http://www.opencrx.org/faq.htm where RDBMS engines are one of the questions and see pgsql bashed sentence after sentence. Can anyone offer any insight as to weather it's fact or ...
    Tomi NATomi NA
    Oct 7, 2006 at 6:06 pm
    Oct 24, 2006 at 3:49 pm
  • Its always said that don't kill -9 postmaster. Whats the reason not to do it. Why is it so strictly prohibited? Thanks, ~Harpreet.
    Harpreet DhaliwalHarpreet Dhaliwal
    Oct 20, 2006 at 9:00 am
    Oct 22, 2006 at 1:55 am
  • Can someone please provide a bit of information where the following error is coming from? This is PG 8.1.3 on AIX 5.3 LOG: could not bind socket for statistics collector: Permission denied LOG: ...
    Brad NicholsonBrad Nicholson
    Oct 18, 2006 at 3:00 pm
    Oct 19, 2006 at 5:28 pm
  • Hi all, we are struggling for some time now with PostgreSQL 8.1.4 and the situation is pretty critical so please help with whatever comes to your mind. We even did an upgrade from version 7.4.13, ...
    Peter BauerPeter Bauer
    Oct 19, 2006 at 11:58 am
    Oct 23, 2006 at 7:43 am
  • Hello! One important use case in my libpq based application (PostgreSQL 8.1.4) is a sort of massive data loading. Currently it is implemented as a series of plain normal INSERTs (binary form of ...
    Ilja GolshteinIlja Golshtein
    Oct 18, 2006 at 6:11 am
    Oct 18, 2006 at 6:46 pm
  • Hi I'm running 7.4 on RHAS 4, and I think I've had a transaction id wraparound issue. Running the command below gives the suitably worrying negative number: emystery=# SELECT datname, ...
    Shane WrightShane Wright
    Oct 24, 2006 at 6:15 am
    Oct 24, 2006 at 3:24 pm
  • Does anyone know of any work being done to get wordpress ported to PostgreSQL? My search on the web finds emails from March of this year concerning some ppl more or less "looking into it", but I ...
    Marc G. FournierMarc G. Fournier
    Oct 22, 2006 at 3:00 am
    Oct 30, 2006 at 3:16 pm
  • Hi, here are my tables table name { id integer primary key first_name text, middle_name text, last_name text } table address { id integer primary key number int, street text, city text, state text } ...
    QuickcurQuickcur
    Oct 11, 2006 at 4:51 am
    Oct 18, 2006 at 8:46 pm
  • Hi everyone, I am searching for the easiest way to let PostgreSQL parse a special dialect of SQL. The dialect I want to parse augments common SQL in a way that enables expressions within a WHERE ...
    Matthias LüdtkeMatthias Lüdtke
    Oct 27, 2006 at 6:12 pm
    Oct 30, 2006 at 1:10 am
  • Can we convert from Postgres to Oracle !!???
    Sandeep Kumar JakkarajuSandeep Kumar Jakkaraju
    Oct 17, 2006 at 8:51 am
    Oct 27, 2006 at 5:51 pm
  • To make a long story short lets just say that I had a bit of a hardware failure recently. If I got an error like this when trying to dump a db from the mangled data directory is it safe to say it's ...
    Rick GiggerRick Gigger
    Oct 19, 2006 at 1:04 am
    Oct 24, 2006 at 4:22 am
  • 12

    UTF-8

    Hello! I'm using PgSQL for a 3 years for web applications, but not only. But the main problem is in encoding. My web applications are used by international (mostly 3 languages: latvian (LATIN7), ...
    Martins MihailovsMartins Mihailovs
    Oct 6, 2006 at 10:10 am
    Oct 13, 2006 at 5:22 pm
  • Moving to -general. Is there a reason you're not using 8.1.4? 8.0 was the first windows release, and as such there's a number of issues that were improved in 8.1. You should at least be using the ...
    Jim C. NasbyJim C. Nasby
    Oct 10, 2006 at 2:16 pm
    Oct 11, 2006 at 2:00 am
  • I'm running postgres 8.0.8. I have a table that is updated very rapidly, so I vacuum it every 10 minutes. The problem is that I sometimes have transactions that hang out for a long time without doing ...
    Joseph ShraibmanJoseph Shraibman
    Oct 19, 2006 at 8:19 pm
    Jan 31, 2007 at 4:09 am
  • Hi, I'm new to postgresql and I'm looking for references and books. We are usually coding in php/C. Can somebody recommend me good books which covers Postgresql 8.x? Which one is worth from following ...
    GanboldGanbold
    Oct 30, 2006 at 2:30 am
    Oct 31, 2006 at 4:59 am
  • Hello, I have a table like this: create table dummy (value integer primary key); and I insert a row like this insert into dummy values(0); then I want to insert three rows: insert into dummy ...
    Jean-Christophe RouxJean-Christophe Roux
    Oct 20, 2006 at 3:02 pm
    Oct 27, 2006 at 2:49 pm
  • We're looking to upgrade from 7.4 - should we go to 8.1.5 or 8.2? We have two databases; 7.4.6 and 7.4.11 in a master slave config using Slony. Both databases use the C locale with UTF-8 encoding on ...
    John Sidney-WoollettJohn Sidney-Woollett
    Oct 20, 2006 at 3:08 pm
    Oct 20, 2006 at 9:28 pm
  • Hello, I've got a failing sql-Script that I execute with the psql command. The Script contains: ----------------------------8<----------------------------- SET CLIENT_ENCODING = 'LATIN1'; (Some other ...
    Stefan SassenbergStefan Sassenberg
    Oct 17, 2006 at 11:11 am
    Oct 18, 2006 at 5:41 pm
  • Can anyone point me to an overview of PostGIS and how it is being used??? Bob Pawley
    Bob PawleyBob Pawley
    Oct 19, 2006 at 3:09 pm
    Nov 4, 2006 at 4:19 am
  • Hi Has anybody got any expierience with PITR recovery under Windows. PostgreSQL just doesn't seem to copy the WAL Files to the acrive location. We have done the initial backup and the first wal file ...
    Tim TassonisTim Tassonis
    Oct 30, 2006 at 4:01 pm
    Oct 31, 2006 at 5:18 pm
  • Hello, Command Prompt has been teaching alot of classes lately, and one of the questions that I received recently was: What is the use case for a READ ONLY transaction? I haven't been able to come up ...
    Joshua D. DrakeJoshua D. Drake
    Oct 14, 2006 at 6:34 pm
    Oct 16, 2006 at 5:54 am
  • Hi, I have set up a postgreSQL on a x86 Solaris 10 box with compiling the source code 8.1.4. My application is need to store the characters encoding with GB18030 or GBK. My Solaris box is installed ...
    StevegyStevegy
    Oct 3, 2006 at 9:01 am
    Oct 8, 2006 at 12:19 pm
  • Hey guys, I have a question regarding the ISO 8601 week date format. Outputting dates in this format seems to be partially supported, and rather inconsistent. The documentation for to_char() lists ...
    Brendan JurdBrendan Jurd
    Oct 2, 2006 at 3:14 am
    Nov 23, 2006 at 3:26 pm
  • Hi, Is there a problem on the mail lists? I've been getting these messages for a couple of days, one for each and every message that is posted to the pgsql-es-ayuda list. It says "executed with ...
    Alvaro HerreraAlvaro Herrera
    Oct 27, 2006 at 3:25 pm
    Oct 28, 2006 at 5:40 pm
  • Hi all, I am using a Fedora Core 5 system. I want to know what is the default username password for PostgreSQL, which was installed with FC5. :) Purusothaman A
    Purusothaman APurusothaman A
    Oct 27, 2006 at 9:16 am
    Oct 27, 2006 at 11:28 am
  • I'm writing some stored procedures in pl/pgsql for a database using postgresql 7.4.7. I need to write a complex function with 65 arguments, but when I try to run it I get an error complaining that ...
    Ottavio CampanaOttavio Campana
    Oct 26, 2006 at 5:32 pm
    Oct 26, 2006 at 7:55 pm
  • Hi everybody! I ask you for your help on a problem I have. I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have some VERY memory intense queries, that put processor up to 40%. I see ...
    Adrian SuciuAdrian Suciu
    Oct 16, 2006 at 3:41 pm
    Oct 18, 2006 at 11:37 pm
  • Hi I would like to know that what can be the maximum size of database in postgres 8.1.4. Currently my database size is 37GB & its pretty slow. I wonder if its b'cos of huge amount of data in it. ...
    Roopa perumalrajaRoopa perumalraja
    Oct 18, 2006 at 2:26 am
    Oct 18, 2006 at 6:04 pm
  • Is there any good documentation, example, tutorial, pamphlet, discussion... to exploit pg features to obtain "polymorphic" behavior without renouncing to referential integrity? Inheritance seems ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Oct 6, 2006 at 9:09 pm
    Oct 17, 2006 at 9:25 pm
  • Pgsql 8.1.4. I want return custom type from function as row, not as values in brackets (1,2). I have following type and function: CREATE TYPE new_item_return_type AS (item_id bigint, last_update ...
    Joe KramerJoe Kramer
    Oct 11, 2006 at 3:26 pm
    Oct 11, 2006 at 9:27 pm
  • Hi, I'm trying to start my postgres server using # pg_ctl start -D /usr/local/pgsql/abc and get an error like: invalid data in PID file "/usr/local/pgsql/abc/postmaster.pid" can anyone comment whats ...
    J S BJ S B
    Oct 11, 2006 at 6:51 pm
    Oct 11, 2006 at 8:29 pm
  • Hi all, I have installed postgresql(8.1.4) data dir on a partition (/data) which rests on a separate disk from OS disk. The install dir is default (usr/local/pgsql). Now when i use use pgbench with ...
    KmKm
    Oct 6, 2006 at 1:32 pm
    Oct 6, 2006 at 3:05 pm
  • Hi all, I am (re)writing a backup program and I want to add a section for backing up pSQL DBs. In the planning steps (making sure a given destination has enough space) I try to calculate how much ...
    Madison KellyMadison Kelly
    Oct 2, 2006 at 8:37 pm
    Oct 3, 2006 at 12:05 am
  • Hi all, I have a little problem. I have an .sql file ( db dump ) and i want to import it to postgres on linux. Does anyone know how i can do it? thnx a lot mates --------------------------------- We ...
    Antonios KatsikadamosAntonios Katsikadamos
    Oct 31, 2006 at 8:27 am
    Nov 2, 2006 at 3:44 pm
  • How widespread is the use of PostgreSQL on Solaris? I am beginning to sense that community support is not currently very strong on this platform, and that pgsql may not be the best candidate for my ...
    VodhnerVodhner
    Oct 31, 2006 at 5:44 pm
    Nov 1, 2006 at 7:33 pm
  • I was looking through the various contrib packages and pgfoundry projects. I noticed that many of them are GPL like PostGIS or LGPL like Npgsql. I have questions. If you make create a PostgreSQL ...
    Karen HillKaren Hill
    Oct 20, 2006 at 6:30 pm
    Oct 20, 2006 at 8:42 pm
  • I am looking for a *fast* backup/restore tools for Postgres. I've found the current used tools pg_dump and pg_restore to be very slow on large databases (~30-40GB). Restore takes time in the tune of ...
    GandalfGandalf
    Oct 16, 2006 at 10:59 am
    Oct 18, 2006 at 9:07 pm
  • Hello all, I have user information in a table that I want to use to add users to the user roles tables that are part of postgresql. My question is this: the passwords in my user table are in there as ...
    DEVDEV
    Oct 17, 2006 at 2:42 pm
    Oct 17, 2006 at 10:06 pm
  • I'm trying to create a new tablespace in a directory that postgres owns, but PG says it cannot set permissions on this directory. [root@localhost ~]# su - postgres -bash-3.1$ mkdir ...
    Andras SimonAndras Simon
    Oct 17, 2006 at 1:06 am
    Oct 17, 2006 at 1:29 pm
  • Hi, I don´t know why the developers build in this way... but let me change a little bit my question. I´ve executed tree to_date functions but they give a strange answer for date 16/10/2006 ...
    Carlos H. ReimerCarlos H. Reimer
    Oct 16, 2006 at 5:08 pm
    Oct 17, 2006 at 2:02 am
  • Is there a utility that could update/merge functions/views from a postgresql dump to an existing db?
    Jan CruzJan Cruz
    Oct 11, 2006 at 6:59 am
    Oct 16, 2006 at 12:48 am
  • Hi, I get this error when accessing the postgresl database -- any ideas? What should I look at? I can query all of the other tables in the database, just not the email_queue table. Weird! Thanks in ...
    Mark GreenbankMark Greenbank
    Oct 6, 2006 at 3:03 pm
    Oct 6, 2006 at 6:34 pm
  • I had 8.1.4 i386 installed from the FC5 repository. To upgrade to 8.1.5 I downloaded the srpm from pgsql mirrors and rebuilt it for i686. Then installed the 8 resulting rpms with yum update from a ...
    Clodoaldo Pinto NetoClodoaldo Pinto Neto
    Oct 27, 2006 at 3:08 pm
    Oct 27, 2006 at 10:04 pm
  • Hello all! I have databases of sizes ranging from 30-60GB that have to be backed-up and restored. I want to reduce the pg_dump and pg_restore times for the same. Can someone throw some light on how ...
    C.M. ShivkumarC.M. Shivkumar
    Oct 26, 2006 at 5:10 am
    Oct 27, 2006 at 9:28 am
Oct 2006
12345…7
Group Navigation
period‹ prev | Oct 2006 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions305
posts1,571
users358
websitepostgresql.org
irc#postgresql

358 users for October 2006

Tom Lane: 150 posts Ron Johnson: 56 posts Merlin Moncure: 44 posts Martijn van Oosterhout: 43 posts Richard Broersma Jr: 41 posts Joshua D. Drake: 37 posts Alvaro Herrera: 31 posts Andreas Kretschmer: 28 posts Jim Nasby: 28 posts Jeff Davis: 24 posts Alexander Staubo: 22 posts Peter Bauer: 20 posts Shane Ambler: 17 posts Chris Browne: 14 posts Rafal Pietrak: 14 posts Albe Laurenz: 13 posts Andrew Sullivan: 13 posts J S B: 13 posts Richard Huxton: 13 posts David Fetter: 12 posts
show more
Archives