FAQ

Search Discussions

98 discussions - 340 posts

  • I have a database that will hold massive amounts of scientific data. Potentially, some estimates are that we could get into needing Petabytes (1,000 Terabytes) of storage. 1. Do off-the-shelf servers ...
    Tony ReinaTony Reina
    Apr 1, 2004 at 5:51 pm
    Apr 5, 2004 at 9:27 pm
  • I've been running a postgres for 2 or 3 years without a problem. This morning my disk space for the database filled up. I need to know what transaction/log files I can truncate or delete without ...
    Tom BakkenTom Bakken
    Apr 7, 2004 at 4:29 pm
    Apr 8, 2004 at 2:12 pm
  • I'm developing a database for scientific recordings. These recordings are traditionally saved as binary flat files for simplicity and compact storage. Although I think ultimately having a database is ...
    Tony ReinaTony Reina
    Apr 8, 2004 at 9:40 am
    Apr 11, 2004 at 9:11 pm
  • No point to beating a dead horse (other than the sheer joy of the thing) since postgres does not have raw device support, but ... raw devices, at least on solaris, are about 10 times as fast as ...
    Gregory S. WilliamsonGregory S. Williamson
    Apr 5, 2004 at 7:42 pm
    Apr 9, 2004 at 8:10 pm
  • I am using the oid of the table as the main key and I've found that is not indexed (maybe because I have declared another primary key in the table) it is a good practice to create an index like this ...
    Edoardo CeccarelliEdoardo Ceccarelli
    Apr 26, 2004 at 4:38 pm
    Apr 28, 2004 at 8:28 am
  • G'day ... I've got a script that runs on all the servers that dump's IP traffic data to a 7.4 database ... they all run at the same time, but I'm starting to get the following on a reasonably regular ...
    Marc G. FournierMarc G. Fournier
    Apr 5, 2004 at 2:52 pm
    Apr 6, 2004 at 12:25 am
  • Hi All, I desperately need to set up a real time replication of several databases (for failover) between two servers. Last time I looked at the PG replication it wasn't yet production level. I wonder ...
    Bradley KieserBradley Kieser
    Apr 13, 2004 at 11:39 am
    Apr 24, 2004 at 10:43 am
  • Are there any binaries for the Red Hat Enterprise Linux 2.1. The OS shipped with Postgresql 7.1.3... I would like to upgrade. Are there any suggestions? Thanks
    Christopher SmithChristopher Smith
    Apr 28, 2004 at 6:23 pm
    May 4, 2004 at 8:10 pm
  • Hi I'm trying to restore tsearch2 featuring database like discribed in the 'tsearch-V2-intro' document. (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html) In point ...
    Fischer UlrichFischer Ulrich
    Apr 22, 2004 at 8:55 am
    Apr 22, 2004 at 3:33 pm
  • Hi - We are running PostgreSQL 7.1.4, and are finally upgrading... to 7.4.2. While we do this upgrade, we also want to make create our DB as UNICODE (we are having problems with SQL_ASCII where we ...
    Dion AlmaerDion Almaer
    Apr 19, 2004 at 7:44 pm
    Apr 21, 2004 at 9:51 am
  • Please unsubscribe me from this list.
    Raquel VieiraRaquel Vieira
    Apr 20, 2004 at 1:50 pm
    Apr 29, 2004 at 3:48 pm
  • What is the best/simplest way to split: a database multiple databases a table multiple tables across more than one disk drive? I know that this has come up before but I can't find any info. A pointer ...
    HalHal
    Apr 8, 2004 at 9:36 pm
    Apr 19, 2004 at 8:06 pm
  • I am trying to build Postgres 7.4.2 from the source rpm on Red Hat Linux 7.1 2.96-98 I get the following error message: [root@CISX_Linux1 usr]# rpmbuild --rebuild postgresql-7.4.2-1PGDG.src.rpm ...
    Donald FraserDonald Fraser
    Apr 13, 2004 at 8:44 pm
    Apr 14, 2004 at 2:29 pm
  • Please can anyone confirm (or otherwise) the situation with restoring large objects? I am running with 7.1.2 (I know it's old, but I don't have a lot of choice given the application running on it), ...
    Marion McKelvieMarion McKelvie
    Apr 6, 2004 at 12:01 pm
    Apr 7, 2004 at 9:28 am
  • Hi, i would configure Oracle 9i not case sensitive and in the table names dont use ""... How can i do this ? Thanks in advance
    Eloy Mier PérezEloy Mier Pérez
    Apr 23, 2004 at 9:43 am
    Apr 26, 2004 at 11:14 pm
  • Hi I try to move my datas from a postresql 7.3.2 to a postgresql 7.4.1. The database was dumped with: pg_dumpall -g GLOBALobjects.sql pg_dump -s DATABASE DBschema.sql pg_dump -Fc DATABASE DBdata.tar ...
    Fischer UlrichFischer Ulrich
    Apr 21, 2004 at 12:46 pm
    Apr 21, 2004 at 6:01 pm
  • Hi admins, I got a conceptual question on creating a stored procedure I need for my app. First the description of the problem: I need a counter which works with 36 possible values per character [0-9 ...
    Enrico OrtmannEnrico Ortmann
    Apr 20, 2004 at 7:56 am
    Apr 21, 2004 at 1:10 am
  • Dear admins, I have a table whose primary key is a record_id with serial type. I would like to know, when I insert a new row, what was the value of the record_id that I just inserted. Since this is a ...
    Ben KimBen Kim
    Apr 9, 2004 at 2:59 pm
    Apr 15, 2004 at 2:01 am
  • Can anyone recommend an editor (windows OR linux) for writing plpgsql code, that might be friendlier than a standard text editor? Nice features I can think of might be: - smart tabbing (1 tab = N ...
    Andrew BiagioniAndrew Biagioni
    Apr 1, 2004 at 11:13 pm
    Apr 5, 2004 at 10:09 pm
  • Hi All, I am using a cascade delete on the following table: vid vname parentname 1 n1@test.com 2 n2@test.com n1@test.com 3 n3@test.com n1@test.com 4 n4@test.com n1@test.com 5 n5@test.com n3@test.com ...
    Glenn MacGregorGlenn MacGregor
    Apr 22, 2004 at 7:47 pm
    Apr 27, 2004 at 1:58 pm
  • I'm using postgres 7.3.x (the default installed on Fedora Core 1) and I'm running into a serious bug in the insert performance. When I try a query like this... <snip INSERT INTO table_a (session, ...
    Tyler WardTyler Ward
    Apr 21, 2004 at 2:44 pm
    Apr 24, 2004 at 3:02 am
  • Greetings, in my database i have both tsearch1 and tsearch2 . the following sequence of commands lead to this repeatble problem . Any solution ? Regds mallah. Welcome to psql 7.4RC2, the PostgreSQL ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Apr 21, 2004 at 5:16 pm
    Apr 22, 2004 at 6:05 am
  • Does ANYBODY know where I can get my hands on the GPL'd PGfs (Postgres File System) code? I saw a note in the archives from 2002 that nobody has seen it in 'years'... and I've just spent over 2 1/2 ...
    Matt DentMatt Dent
    Apr 17, 2004 at 11:22 pm
    Apr 19, 2004 at 4:01 pm
  • Hi all, In order to setup a SSL connection to the DataBase I did the following: - compiled --with-openssl - ssl=true in postgresql.conf - hostssl all dbuser 212.205.129.107 255.255.255.0 md5 in ...
    GPGP
    Apr 15, 2004 at 3:33 pm
    Apr 16, 2004 at 3:23 am
  • Hello! Would it be possible to have an option "log_min_cost_statement", similar to "log_min_duration_statement" except that it logs all statement that has an minimum cost estimated by the planner? I ...
    Nichlas LöfdahlNichlas Löfdahl
    Apr 13, 2004 at 3:26 pm
    Apr 13, 2004 at 6:46 pm
  • All, I thought this was answered before, but I could not find anything in my saved email. I need to ALTER a table to add a new column. I want the new column to be between two existing columns, ...
    Terry HamptonTerry Hampton
    Apr 8, 2004 at 1:37 pm
    Apr 12, 2004 at 10:36 pm
  • Hi, I get the following error trying to update a view: "ERROR: query rewritten 10 times, may contain cycles" and it doesn't. There is a function in there legitimately called 10 times with the same ...
    Coby BeckCoby Beck
    Apr 7, 2004 at 11:41 pm
    Apr 9, 2004 at 12:44 pm
  • Anyone know this list member, who was kind enought to reply? -------- Original Message -------- Subject: Re: [ADMIN] Location of a new column Date: Thu, 8 Apr 2004 06:58:56 -0700 From: "scott" ...
    Terry HamptonTerry Hampton
    Apr 8, 2004 at 2:39 pm
    Apr 8, 2004 at 8:16 pm
  • Hi, we have table having 23 million rows. This is the table structure. Table Request: Column | Type | Modifiers -----------+-----------------------------+----------- origindb | character(1) | not ...
    HemapriyaHemapriya
    Apr 7, 2004 at 9:03 pm
    Apr 8, 2004 at 2:07 am
  • I downloaded postgresql (client, server and libs) but cannot complete installation for want of the libraries listed below libcrypto.so.2 is needed by postgresql-7.2.3-2PGDG libssl.so.2 is needed by ...
    Kandiah ratnavaleKandiah ratnavale
    Apr 27, 2004 at 6:32 am
    May 3, 2004 at 8:48 pm
  • Question, I have several db servers that have postgresql clusters with many db's (5 upto 170) in them. Is there a way to breakout the postgres logs by the database? Thanks, chris
    Chris HooverChris Hoover
    Apr 27, 2004 at 5:21 pm
    Apr 27, 2004 at 7:47 pm
  • Hello *, I have a problem with select lower() using capital letters with diaeresis. I tried with encoding SQL_ASCII und UNICODE. newsdb=# select lower('Ökosteuer'); lower ------------ Ökosteuer (1 ...
    Andreas SchmitzAndreas Schmitz
    Apr 22, 2004 at 8:55 am
    Apr 22, 2004 at 1:32 pm
  • I have just migrated from 7.2.1 to 7.4.2 and I have the following tables defined in my database. /* ============================================================ */ /* Table: vm_config */ /* ...
    Chris White (cjwhite)Chris White (cjwhite)
    Apr 20, 2004 at 11:24 pm
    Apr 22, 2004 at 6:45 am
  • I'm new to PostgreSQL and I was wondering if there were any tips or tricks to admining a postgre db and if there are any tools like phpmyadmin for postgre. TIA -- Joseph A. Nagy, Jr. ...
    Joseph A. Nagy, Jr.Joseph A. Nagy, Jr.
    Apr 18, 2004 at 2:17 am
    Apr 19, 2004 at 4:00 pm
  • Hi All, I have a query. What is the maximum number of tables I can have in a PGSql Database, without affecting performance? Thanks in advance. Regards, Ashvinder
    Ashvinder SinghAshvinder Singh
    Apr 12, 2004 at 4:28 am
    Apr 15, 2004 at 11:33 pm
  • I have just upgraded my development machine from 7.3.4 to 7.4.2 and have a couple of small questions which I can't find any answers to in the documents or history. 1) What does the TRIGGER group/user ...
    Donald FraserDonald Fraser
    Apr 14, 2004 at 1:21 pm
    Apr 15, 2004 at 9:31 am
  • I hope it is OK to ask the question here. Perl's DBI has the following function. $rv = $dbh- last_insert_id($catalog, $schema, $table, $field); "Returns a value 'identifying' the row just inserted, ...
    Ben KimBen Kim
    Apr 14, 2004 at 5:53 pm
    Apr 15, 2004 at 1:56 am
  • Hi, I am trying to take Database backup. I use this command. # ./pg_dump -U username -cif filename.sql dbname Its exporting, but in the Log, its giving like "LOG: out of file descriptors: Too many ...
    JinNet PickerJinNet Picker
    Apr 13, 2004 at 8:37 am
    Apr 13, 2004 at 5:16 pm
  • I have just installed 7.4.2 and initialized a database using the default values. When I start the database It fails with the following message: FATAL: invalid value for parameter "lc_messages": ...
    Chris White (cjwhite)Chris White (cjwhite)
    Apr 8, 2004 at 5:53 pm
    Apr 9, 2004 at 4:00 am
  • I have just upgraded to 7.4.2 from 7.2.1 and I am having problems inserting data into a database table that worked just fine under 7.2.1. I have a table defined as follows: create table vm_mailbox ( ...
    Chris White (cjwhite)Chris White (cjwhite)
    Apr 8, 2004 at 10:44 pm
    Apr 8, 2004 at 11:57 pm
  • Hi all, using Postgres 7.4.2 I'm seeing in my log file thousand of line with "CONTEXT: " I need to habe the log level debug2, and I'm seeing that the CONTEXT disappear only with: log_min_messages = ...
    Gaetano MendolaGaetano Mendola
    Apr 8, 2004 at 11:34 am
    Apr 8, 2004 at 9:40 pm
  • hi all, there is a way to use my own index with pk constraint instead of the implicitly created one? why? just because i don't like the name, maybe can i change the generated name? thanx in advance, ...
    Jaime CasanovaJaime Casanova
    Apr 7, 2004 at 9:11 pm
    Apr 7, 2004 at 11:43 pm
  • Dear all I am using PostgreSQL 7.3 as DB server in my company. I am preparing some DB backup and maintenance procedures. I found from Administrator guide that we can use "dump" command to backup the ...
    Eric YumEric Yum
    Apr 6, 2004 at 2:33 am
    Apr 6, 2004 at 8:44 pm
  • I recently built my RH9 system and updated the binary RPMs to 7.4.2. I am new to Postgresql, but I think I understand the PDF documentation provided. However, I couldn't find any documentation on ...
    Bud CurtisBud Curtis
    Apr 4, 2004 at 5:39 am
    Apr 6, 2004 at 2:28 am
  • Can I use the pg_dump from 7.4.1 on 7.4.2? I tried copying a couple of libraries that it needed, and I can copy one-by-one that it looks for, but I am not sure how many does it need in all for the ...
    Anjan DaveAnjan Dave
    Apr 5, 2004 at 4:50 pm
    Apr 5, 2004 at 6:02 pm
  • at a point the postgresql ODBC driver issues a command like this (not questioning here how useful or correct it could be) select * from table1 where ctid = '(,)'; this command works (?) returning ...
    Jose' CruanyesJose' Cruanyes
    Apr 3, 2004 at 5:57 pm
    Apr 4, 2004 at 5:04 am
  • Hi, Does anyone know postgres performance in Linux vs Mac Os.. Pls suggest the best platform to go for.. Thanks in Advance. Priya
    HemapriyaHemapriya
    Apr 1, 2004 at 3:21 pm
    Apr 1, 2004 at 5:19 pm
  • unable to complete install of PosrtgreSQL without undernoted libraries libcrypto.so.2 libssl.so.2 need assistance to locate these libraries for download?? earlier request of few days ago not ...
    Kandiah ratnavaleKandiah ratnavale
    Apr 30, 2004 at 6:08 pm
    May 3, 2004 at 8:23 pm
  • Im looking for some documentation on writing stored procedures using PL/Perl. The PostrgeSQL tutorials give only a brief introduction to this which is good but enough : ...
    Rahul kRahul k
    Apr 28, 2004 at 6:59 pm
    Apr 30, 2004 at 7:15 am
  • I tried but couldn't find an answer if this is possible in psql. Create a file named test.sql select * from mytable where id = ? (or use $1, $2...) Then in psql do \i test.sql 337 to achieve the same ...
    Ben KimBen Kim
    Apr 28, 2004 at 3:47 pm
    Apr 28, 2004 at 4:06 pm
Group Navigation
period‹ prev | Apr 2004 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions98
posts340
users139
websitepostgresql.org
irc#postgresql

139 users for April 2004

Tom Lane: 46 posts Scott.marlowe: 14 posts Peter Eisentraut: 11 posts Tony Reina: 11 posts Tom Bakken: 9 posts Chris White (cjwhite): 7 posts Bradley Kieser: 6 posts Bruno Wolff III: 6 posts Donald Fraser: 6 posts Fischer Ulrich: 6 posts Chris Browne: 5 posts Edoardo Ceccarelli: 5 posts Gregory S. Williamson: 5 posts Marc G. Fournier: 5 posts Stephan Szabo: 5 posts Ben Kim: 4 posts Christopher Kings-Lynne: 4 posts Goulet, Dick: 4 posts Greg Sabino Mullane: 4 posts Jaime Casanova: 4 posts
show more
Archives