FAQ

PostgreSQL > pgsql-admin > October 2005

Search Discussions

87 discussions - 292 posts

  • I'm going to attempt to do my best in describing the situation... so please forgive any ignorance on my part since I am very new to the Postgres community. We have 2 identical Postgres databases, one ...
    Jeff KirbyJeff Kirby
    Oct 2, 2005 at 4:43 pm
    Oct 4, 2005 at 1:54 am
  • I'm experiencing an unusual situation on a recently reprovisioned server. It's a Debian server (testing/unstable) running a 2.6.13.3 kernel. postgres 8.0.4 was built from source. I'm using a slightly ...
    Thomas F. O'ConnellThomas F. O'Connell
    Oct 14, 2005 at 12:55 am
    Oct 18, 2005 at 3:17 pm
  • Hi, I've got a postgres installation which is accessed by users thru a set of perl CGIs. Unlickily, when the user enters some characters in a description (string) field, like "èòéàùì", the string is ...
    Luca FerrariLuca Ferrari
    Oct 10, 2005 at 6:33 am
    Oct 12, 2005 at 11:02 pm
  • Hi All, We vacuum busy tables in different frequencies depending on how busy the table is. Today I noticed that one of the task that was suppose to delete rows from a busy table was running for a ...
    Subbiah, StalinSubbiah, Stalin
    Oct 31, 2005 at 8:14 pm
    Nov 4, 2005 at 1:34 am
  • Hi, I got this error message when I tried to do pg_dump on the database. pg_dump: ERROR: invalid memory alloc request size 4294967293 pg_dump: SQL command to dump the contents of table "wordlist" ...
    Nirav ParikhNirav Parikh
    Oct 13, 2005 at 1:15 am
    Oct 13, 2005 at 4:31 pm
  • I apologize for the wrong subject in a previous post. Here it is again: My understanding that the current release of Postgres does not allow the DBA to pre-allocated space for the data files or ...
    Tomeh, HusamTomeh, Husam
    Oct 31, 2005 at 11:14 pm
    Nov 1, 2005 at 5:41 pm
  • In-time for PostgreSQL 8.1 gold, The pgAdmin Developer Team will release pgAdmin III V1.4, which has a new Guru hint feature that tries to give users helpful hints on typical beginner's pitfalls. The ...
    Andreas PflugAndreas Pflug
    Oct 3, 2005 at 12:16 am
    Oct 25, 2005 at 8:33 pm
  • We have installed a product called Quasar for accounting needs at our company, which is back ended by PostgreSQL. It is a requirement that the database is replicated, real time, to a secondary ...
    Kirby UbbenKirby Ubben
    Oct 21, 2005 at 4:19 pm
    Oct 21, 2005 at 10:21 pm
  • Building a new server here (solaris 9), was going to put 8.0.3 on it. ./configure --with-openssl --enable-syslog fails with this error message: configure: error: header file <openssl/ssl.h is ...
    Roth, GabrielleRoth, Gabrielle
    Oct 17, 2005 at 7:45 pm
    Oct 29, 2005 at 3:32 pm
  • Hi: I don't think this is possible, but I want to make sure. Let's say I have a database that I want to dump in its entirety, all except for one particular table. Is there an option flag on pg_dump ...
    Colton A SmithColton A Smith
    Oct 20, 2005 at 2:23 pm
    Oct 27, 2005 at 9:43 pm
  • Hi, I'm hoping that someone will be able to answer this query: Last night at 3am our Postgresql DB cluster hung. At the time data was being loaded. The parameter log_statement_stats in the ...
    Nigel BishopNigel Bishop
    Oct 13, 2005 at 4:44 am
    Oct 13, 2005 at 5:18 pm
  • Hi, I'm performing some tests on performance: when to use or not use foreign keys. I have a table A with 50 columns, 8 of them have a foreign key to some other table, and there is a table B with 65 ...
    Pieter-Jan SavatPieter-Jan Savat
    Oct 11, 2005 at 10:18 am
    Oct 27, 2005 at 2:45 am
  • Hi everyone, My name is Ken working in Tokyo,Japan. Please forgive my poor English. We have been using PostgreSQL7.3.4 on a Map GIS engine since last year.To tune the system, I need to get the log ...
    AcemeicnAcemeicn
    Oct 26, 2005 at 2:14 am
    Oct 27, 2005 at 2:02 am
  • Hi, I sent this request recently but have heard nothing. I'm new to he whole procedure and may be doing this incorrectly. Please advise. Thanks Will Lewis Database Administrator (DBA) Central IT ...
    Will LewisWill Lewis
    Oct 11, 2005 at 7:56 am
    Oct 24, 2005 at 1:28 pm
  • Hi, I have a query about a backup policy that I wish to implement. Currently, we are running a PostgreSQL server with a very large database on it. The database consists of a core of read-only tables, ...
    Chris JewellChris Jewell
    Oct 14, 2005 at 1:19 pm
    Oct 23, 2005 at 4:10 pm
  • Hi friends, greetings :-) Please apologize by my bad english, I speak sapnish. This question that I'll do could be a little difficult because I'm award that it should be very especific, although I'm ...
    Alfredo RicoAlfredo Rico
    Oct 20, 2005 at 5:45 pm
    Oct 21, 2005 at 2:17 pm
  • On behalf of a previous employer who, due to major downsizing, is left without an answer to this: What's the best way to treat impending OID wrap-around in a 7.4.8 database? This DB has been online ...
    Jeff BoesJeff Boes
    Oct 16, 2005 at 11:28 am
    Oct 18, 2005 at 4:13 pm
  • Hi, Which backup software out there work well with postgresql, I cannot find one with backup agent for postgres. I am looking for a backup solution that will backup the postgres database from a fiber ...
    Robert NgoRobert Ngo
    Oct 2, 2005 at 12:06 pm
    Oct 5, 2005 at 4:04 pm
  • Dear Sir, How can I altered the WAL segment file size when building the server. The default size was 16 MB. I want only 1 MB size... Waiting for your kind reply Regards Dhanesh Dhanesh Prabha P.V ...
    Dhanesh PrabhaDhanesh Prabha
    Oct 4, 2005 at 10:02 am
    Oct 4, 2005 at 5:32 pm
  • I noticed recently that my PITR base backups were occassionally returning non-zero, so I turned up the verbosity on rsync and it appears that occassionally a file vanishes out from under rsync while ...
    Jeff FrostJeff Frost
    Oct 25, 2005 at 3:44 pm
    Oct 25, 2005 at 8:35 pm
  • In error handling suppose if the database already exists.. It is returning : database "sample(say)" doesn't exists. If i want to return general error messages with out specifying names how can i? ...
    SandhyaSandhya
    Oct 19, 2005 at 10:19 am
    Oct 20, 2005 at 6:18 am
  • Hello erverybody, I need to install a new version of Redhat on my server. On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on its own partition). Can I "just" install the new ...
    FMFM
    Oct 19, 2005 at 3:47 pm
    Oct 19, 2005 at 4:57 pm
  • I'm wondering, does anyone know of any timing tests for pg_dump? I am trying to find the fastest way to do our nightly database backups using pg_dump. And I just wanted to make sure I don't reinvent ...
    Chris HooverChris Hoover
    Oct 12, 2005 at 1:36 pm
    Oct 17, 2005 at 2:28 pm
  • Hi everybody, i'd like to know if my database (settings, indexes, materialized views, etc) is correctly tuned. To do this, i think the best way is to watch the queries actually processed and the time ...
    David PradierDavid Pradier
    Oct 11, 2005 at 9:58 am
    Oct 11, 2005 at 2:36 pm
  • Hi folks. I'm trying to move an existing setup on a 7.2 system to another existing box running 7.4. I've done a pg_dumpall and then imported that to the new system but a copy is failing with the ...
    Gary StainburnGary Stainburn
    Oct 10, 2005 at 11:22 am
    Oct 10, 2005 at 2:30 pm
  • is there a syntax that would look something like: create table newTable like oldTable without indexes || records || constraints with indexes || records || constraints built into postgres?
    David DurhamDavid Durham
    Oct 6, 2005 at 3:04 am
    Oct 7, 2005 at 2:48 pm
  • Hello! When I install Postgresql 8.0.3 on my Windows server, I set LC_COLLATE and LC_CTYPE to Russian_Russia.1251 via install process. But when I install Postgresql server on Fedora Core 4 Linux, I ...
    Петров Р.В.Петров Р.В.
    Oct 2, 2005 at 4:09 am
    Feb 6, 2006 at 8:13 am
  • Hi, I have a small company and I am quite new in using postgres, I have established that I can intall postgres on a database server and connect to it from terminals all over, and I just wanted to ...
    Tharo MohonoTharo Mohono
    Oct 31, 2005 at 1:42 pm
    Oct 31, 2005 at 5:12 pm
  • Hi, Is there a way to actually determine if the database is doing anything after a query is send to the backend during *long* lasting queries besides waiting and hoping? -- Groeten, Joost Kraaijeveld ...
    Joost KraaijeveldJoost Kraaijeveld
    Oct 30, 2005 at 9:50 am
    Oct 31, 2005 at 4:16 am
  • what happend with postgresql 8.1b4 performance on query? look at this: select count(*) from fotos where archivo not in (select archivo from archivos) Aggregate (cost=4899037992.36..4899037992.37 ...
    Sidar López CruzSidar López Cruz
    Oct 25, 2005 at 11:31 pm
    Oct 26, 2005 at 5:57 pm
  • Hi. I wondering about file size of a table. The table has 43000 pages and in documentation is say's its around 8kb. It makes it supose to be around 336Mb on disk. The table is simple just: org_no ...
    Roger Strandberg / HamstaRoger Strandberg / Hamsta
    Oct 21, 2005 at 10:41 pm
    Oct 22, 2005 at 6:03 pm
  • Hello I want to write some scripts which could connect to databse and work in background. I want to avoid situation in which i have to manually/interactively give appriopriate password everytime i ...
    TeknetTeknet
    Oct 15, 2005 at 4:08 pm
    Oct 18, 2005 at 8:26 pm
  • hi, please do the needful.. I am using j2ee on the server side and postgresql as the database to connect. This database is exposed to the internet. The user is shown a login page in which user enters ...
    Ashish srivastavaAshish srivastava
    Oct 12, 2005 at 10:23 am
    Oct 13, 2005 at 5:36 am
  • I've been playing with postgresql for a while now. I'm curious how others develop front ends for pg. I have looked at using pgaccess, and ReKall. Both seem pretty good. I've also been playing with MS ...
    David BearDavid Bear
    Oct 12, 2005 at 5:19 pm
    Oct 12, 2005 at 11:14 pm
  • I have a table in the databases I work with, that contains two text columns with XML data stored inside them. This table is by far the biggest table in the databases, and the text columns use up the ...
    StefStef
    Oct 10, 2005 at 12:19 pm
    Oct 10, 2005 at 5:48 pm
  • I learned for other database systems, that it is an advantage to have database on one physical drive and transaction logs on a different physical drive, as this should minimize seeks on the ...
    Weber, Johann (ISS Kassel)Weber, Johann (ISS Kassel)
    Oct 10, 2005 at 11:41 am
    Oct 10, 2005 at 2:40 pm
  • tried 3 or 4 times and no luc k. lori
    LoridLorid
    Oct 7, 2005 at 3:06 pm
    Oct 8, 2005 at 1:02 am
  • Silly question, but in a shell script, what is the best way to check for a pg_dump problem? I'm working on reworking our backup methodology, and want to make sure that if pg_dump can't dump a db, we ...
    Chris HooverChris Hoover
    Oct 7, 2005 at 8:13 pm
    Oct 7, 2005 at 8:50 pm
  • Hii all, I eould like to asking about creating table in postgres here is the 1 can postgres do such things like this one? # create table address as object(address varchar(100), post(6)); # create ...
    DedyDedy
    Oct 6, 2005 at 6:15 am
    Oct 7, 2005 at 4:48 am
  • Hi: I wrote a function for my database and 'loaded' it, but then misplaced the code. Is there a query I can issue to retrieve it? Thanks
    Colton A SmithColton A Smith
    Oct 1, 2005 at 4:03 pm
    Oct 3, 2005 at 1:48 am
  • I am running Postgresql 7.4.7. on RedHat ES-64 version 4 on a Dual-Opteron Dual Core system. I am having problems with the pg_dump command due to improper initialization of the Database cluster on RH ...
    Fred PopeFred Pope
    Oct 28, 2005 at 9:23 pm
    Nov 3, 2005 at 6:12 pm
  • Hello, I get the following messages when starting the PostgreSQL-Server. What does the LOG message mean? Regards Michaela $ /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data postmaster ...
    MGMG
    Oct 31, 2005 at 7:58 am
    Nov 2, 2005 at 4:50 pm
  • I get this message in the log file. And I want to know is how the fix it. FATAL: could not read statistics message: Resource temporarily unavailable Any idea? /Peter
    Peter IvarssonPeter Ivarsson
    Oct 29, 2005 at 9:18 am
    Oct 29, 2005 at 5:31 pm
  • Hi, I just wanted to know how possible it is to install postgres on the windows server and have some terminals conneting to the server to query the database, and if possible, could you please give me ...
    Tharo MohonoTharo Mohono
    Oct 26, 2005 at 2:06 pm
    Oct 26, 2005 at 3:11 pm
  • Hi All, I am Kishore doing freelance development of J2EE applications. We switched to use Postgresql recently because of the advantages it has over other commercial databases. All went well untill ...
    Kishore BKishore B
    Oct 25, 2005 at 8:18 pm
    Oct 25, 2005 at 8:44 pm
  • Hi Craig, Does the no of tables and the size of each table affect the performance of a join operation? When we are trying to join the two big tables that I described above, pg is taking so long to ...
    Kishore BKishore B
    Oct 23, 2005 at 9:55 pm
    Oct 24, 2005 at 3:28 pm
  • Hello, when I read documentation for PgSQL 8.1beta3 about krb_server_hostname I think that it's enough insert into kerberos keytab only: krb_srvname/krb_server_hostname@REALM But pgsql have different ...
    Ludek FinstrleLudek Finstrle
    Oct 20, 2005 at 2:24 pm
    Oct 23, 2005 at 4:50 pm
  • how to copy data from file with fixed columns width to postgresql table? MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
    Sidar López CruzSidar López Cruz
    Oct 20, 2005 at 11:05 pm
    Oct 21, 2005 at 7:39 am
  • Tom, Need some help in analyzing the pg_controldata output. pg_control version number: 72 Catalog version number: 200310211 Database cluster state: in production pg_control last modified: Wed 19 Oct ...
    Gourish SingbalGourish Singbal
    Oct 19, 2005 at 11:55 am
    Oct 20, 2005 at 9:11 am
  • To whom it may concern, My pgAdmin crashed when I tried to vacuum the "template0" database. It is of course not needed to vacuum this database, but I clicked on it by accident. When I tried it again, ...
    A.j. LangereisA.j. Langereis
    Oct 19, 2005 at 4:31 pm
    Oct 20, 2005 at 8:58 am
Oct 2005
12
Group Navigation
period‹ prev | Oct 2005 | next ›
Group Overview
grouppgsql-admin @
categoriespostgresql
discussions87
posts292
users112
websitepostgresql.org
irc#postgresql

112 users for October 2005

Tom Lane: 31 posts Jim C. Nasby: 16 posts Jeff Frost: 12 posts Hannes Dorbath: 11 posts Scott Marlowe: 9 posts Alvaro Herrera: 8 posts Michael Fuhr: 7 posts Kevin Grittner: 6 posts Simon Riggs: 6 posts Thomas F. O'Connell: 6 posts Bruno Wolff III: 5 posts Chris Browne: 5 posts Gourish Singbal: 5 posts Peter Eisentraut: 5 posts Ashish srivastava: 4 posts Kirby Ubben: 4 posts Luca Ferrari: 4 posts Sidar López Cruz: 4 posts Tomeh, Husam: 4 posts Acemeicn: 3 posts
show more
Archives