Search Discussions

60 discussions - 210 posts

  • We currently use postgres 8.1.x and run the following query periodically to check for XID wraparound proximity. select datname, age(datfrozenxid) from pg_database What is the equivalent check in 8.4 ...
    Anj AduAnj Adu
    Aug 11, 2009 at 9:48 pm
    Oct 13, 2009 at 10:26 pm
  • Hi, Could someone confirm that the ability to share the Linux system /etc/passwd (or shadow) file with PostgreSQL is definitely defunct? I've searched the archives and, as far as I can tell, this ...
    Eamonn MartinEamonn Martin
    Aug 7, 2009 at 2:35 pm
    Feb 23, 2010 at 9:07 pm
  • Greetings, We're seeing numerous "LOG: out of file descriptors: Too many open files in system; release and retry" entries as well as quite a few "LOG: could not open temporary statistics file ...
    Jonatan Evald BuusJonatan Evald Buus
    Aug 12, 2009 at 5:01 pm
    Aug 13, 2009 at 3:00 pm
  • Hi, I have a basic and quick question related to "archive_timeout" command in PITR. I've set "archive_timeout" to 1800 seconds (30 minutes) in "postgresql.conf", which means WAL archives are ...
    Aug 3, 2009 at 11:07 am
    Aug 11, 2009 at 6:48 pm
  • Hi, my database is hit with constant inserts to 6 main tables (200 inserts per minute to one of the tables, less to the others), some updates, but then the selects: - large retrievals of randomly ...
    Brian ModraBrian Modra
    Aug 3, 2009 at 4:24 pm
    Aug 4, 2009 at 7:14 pm
  • This may be a silly question but I don't see any place where the documentation explicitly addresses whether or not you can designate a particular column as a primary key after the table is created. I ...
    Carol WalterCarol Walter
    Aug 25, 2009 at 9:50 pm
    Aug 26, 2009 at 6:37 pm
  • Hi all; due to operator error at one of my client sites we're trying to restore a deleted db. We did a restore with a pgdump that went fine but the dump is 3weeks old. they do have WAL segments and ...
    Kevin KempterKevin Kempter
    Aug 11, 2009 at 3:05 pm
    Aug 11, 2009 at 5:36 pm
  • Is there a Postgres utility that allows data contained in a CSV file to be loaded into the database?
    Mike angeloMike angelo
    Aug 6, 2009 at 9:27 pm
    Aug 7, 2009 at 5:31 am
  • Hi all, I'm getting duplicated rows in some of my tables when I try to restore data from a dump file generated with 'pg_dumpall'. I use: pg_dumpall -c -U postgres mybackup.sql to dump all the data, ...
    Pablo Alonso-Villaverde RozaPablo Alonso-Villaverde Roza
    Aug 24, 2009 at 10:54 am
    Aug 27, 2009 at 7:06 am
  • Dear all, I face this problem from last few days. here is test2 table with only one column id erp_test= \d test2 Table "public.test2" Column | Type | Modifiers --------+---------+----------- id | ...
    Kumar AnandKumar Anand
    Aug 20, 2009 at 9:53 am
    Aug 21, 2009 at 5:47 pm
  • Hi all; we have a large table that gets a lot of churn throughout the day. performance has dropped off a cliff. A vacuum verbose on the table showed us this: INFO: "action_rollup_notifier": found 0 ...
    Kevin KempterKevin Kempter
    Aug 18, 2009 at 7:19 pm
    Aug 18, 2009 at 8:47 pm
  • All, Do not use PG that often and have it installed on several PCs. Have it turned off normally so have to go to: Start + All Programs + System Tools + Administrative Tools + Services find PG in the ...
    Aug 14, 2009 at 2:50 pm
    Aug 17, 2009 at 3:26 pm
  • Hello List, postgres 8.2 is not doing too much but eating up all my memory: http://pastebin.com/m4cf22ee2 The postgresql.conf is at the very bottom of the pastebin. I guess this is a configuration ...
    Ml mlMl ml
    Aug 14, 2009 at 1:04 pm
    Aug 14, 2009 at 8:06 pm
  • I am setting up a test environment to simulate a very high load. We have a server farm which is receiving data (cold be thousands of simultaneous users posting data). I currently have max_connections ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Aug 11, 2009 at 5:42 am
    Aug 11, 2009 at 4:40 pm
  • Dear List, This is my first post, I hope I am asking it on the correct list. I changed the password for user postgres and I completely forgot about the previous one. The main problem is that now the ...
    Aug 20, 2009 at 11:10 am
    Aug 26, 2009 at 7:43 pm
  • We have a two node cluster and we are planning on adding a third. Question is, we want the third machine to be more robust, thus we want more memory, hence we would like to run 64bit. Will this be a ...
    Aug 21, 2009 at 5:48 pm
    Aug 24, 2009 at 2:35 pm
  • Hello, for dropping all functions within the current schema I use this SQL query: SELECT DISTINCT 'DROP FUNCTION ' || p.oid::regprocedure::text || ' CASCADE;' FROM pg_catalog.pg_proc p LEFT JOIN ...
    Jan-Peter SeifertJan-Peter Seifert
    Aug 20, 2009 at 10:38 am
    Aug 21, 2009 at 8:09 am
  • Hi guys A bit of a long first story, hope someone is able to help... We have got a Ubuntu 8.04 server running Postfix, which reads its mailing list subscription files, aliases, virtual, domains, etc ...
    Dick VisserDick Visser
    Aug 19, 2009 at 7:33 pm
    Aug 19, 2009 at 8:09 pm
  • I'm running a vacuum full on a table due to excessive updates/deletes. It's been running for more than an hour (it's about 3Gig in size) 2 questions: 1) is there any way to gain some visibility per ...
    Kevin KempterKevin Kempter
    Aug 18, 2009 at 9:51 pm
    Aug 18, 2009 at 10:49 pm
  • Hello, I'm working on a warm standby system, and we would like to stick with the RHEL5 distributed version of postgres, which is still 8.1. I can setup the system to a point where it's adequate for ...
    James bardinJames bardin
    Aug 18, 2009 at 3:27 pm
    Aug 18, 2009 at 6:02 pm
  • We are testing 8.4 and noticed that the performance of select max(indexed_col) from parent_Table is the same (slow) as postgres 8.1.x ( our current version). The child tables are huge and the ...
    Anj AduAnj Adu
    Aug 18, 2009 at 1:30 pm
    Aug 18, 2009 at 1:42 pm
  • I am having a problem with postgreql.conf becoming corrupted. We are using version 8.2.9 in embedded systems running Fedora Core 7. Basically, the postgres server holds the data that our embedded ...
    Jason K. ErgleJason K. Ergle
    Aug 31, 2009 at 3:01 pm
    Sep 1, 2009 at 3:25 am
  • Hi all, I've got a strange problem with creating a new database: br@ovh1:~$ createdb -E utf8 test createdb: database creation failed: ERROR: encoding UTF8 does not match server's locale en_US.utf8 ...
    Bartłomiej RomańskiBartłomiej Romański
    Aug 17, 2009 at 6:32 pm
    Aug 17, 2009 at 8:55 pm
  • There exist any way to change the name of my stored procedures schemas but the code used inside of them??? for example: I have this stored procedure: CREATE OR REPLACE FUNCTION schema1.example(double ...
    Mainor Alonso Morales GonzálezMainor Alonso Morales González
    Aug 6, 2009 at 9:09 pm
    Aug 6, 2009 at 10:06 pm
  • Dear PostgreSQL admins. I have just restored a DB from 8.3.5 to 8.4.0 and I just received the error: ERROR: column "reltriggers" does not exist at character 41 STATEMENT: SELECT relhasindex, relkind, ...
    Kenneth MarshallKenneth Marshall
    Aug 5, 2009 at 11:29 pm
    Aug 5, 2009 at 11:46 pm
  • Hi All, I recently upgraded my box to the latest version. The previous one was a bit outdated. Apparently we have some bad structure formatting in our db design, cause the latest version broke our ...
    Aras AngeloAras Angelo
    Aug 4, 2009 at 7:03 pm
    Aug 4, 2009 at 7:23 pm
  • Greetings all- Running postgresql under debian, my standard apt-get upgrade upgraded me from 8.3 to 8.4. As a result, I no longer have access to the databases that were created under 8.3. Typically I ...
    Andrew PerrinAndrew Perrin
    Aug 3, 2009 at 2:57 pm
    Aug 4, 2009 at 4:54 pm
  • Hi, I'm new to PostgreSQL, and currently facing an issue with PostgreSQL 7.4 database. I'm getting the following error when tried to create a table. Please let me know the steps (with queries) that I ...
    Venkateswara Rao BondadaVenkateswara Rao Bondada
    Aug 3, 2009 at 12:56 pm
    Aug 4, 2009 at 8:14 am
  • Hello. I’m having a problem starting server on mac os x. ------------- bash-3.2$ /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data server starting bash-3.2$ LOG: could not open configuration ...
    Aug 31, 2009 at 9:46 am
    Sep 21, 2009 at 6:36 am
  • Greetings, I have a little question - which chunk size is more better in performance purpose? Please advise folks. system configuration is: Software RAID 1+0 (4 x SAS 15k HDD) CentOS 32bit PostgreSQL ...
    Sergey SmirnovSergey Smirnov
    Aug 29, 2009 at 10:03 pm
    Aug 30, 2009 at 10:45 am
  • Dear all, i want to create partitions table : *create table advertisements_otomotif (CHECK (select * from advertisements where category_id in (select id from categories where name='Otomotif'))) ...
    Idris khanafiIdris khanafi
    Aug 26, 2009 at 9:20 am
    Aug 27, 2009 at 2:37 pm
  • Hello, I have a working warm standby system, running 8.4 (thanks for urging me to upgrade from the rehdat provided release). One of the new requirements is going to be for (a non-DBA) admin to easily ...
    James bardinJames bardin
    Aug 21, 2009 at 2:46 pm
    Aug 24, 2009 at 3:34 pm
  • Hello, The new option to define a background color for each server in PgAdmin 1.10 is very cool (to distinguish test servers from production servers). It would be very nice to have a reminder of this ...
    PESTY BenoitPESTY Benoit
    Aug 21, 2009 at 9:39 am
    Aug 21, 2009 at 10:29 pm
  • When recover a database using a continuous archive backup, i detected some duplicated keys. This there isn't in the production database. I use postgres-8.3.5. anyone know why this happens? Regards, ...
    Ygor DeganiYgor Degani
    Aug 19, 2009 at 2:39 pm
    Aug 20, 2009 at 5:10 pm
  • Dick VisserDick Visser
    Aug 20, 2009 at 2:35 pm
    Aug 20, 2009 at 2:39 pm
  • Hi all; we've been fighting this query for a few days now. we bumped up the statistict target for the a.id , c.url_hits_id and the b.id columns below to 250 and ran an analyze on the relevant tables. ...
    Kevin KempterKevin Kempter
    Aug 19, 2009 at 2:56 pm
    Aug 20, 2009 at 1:59 pm
  • Im trying to alter a column type from character varying(8) to int. All the values in the column are numbers but im getting this message column "xxxxxx" cannot be cast to type integer Dropping and ...
    Aras AngeloAras Angelo
    Aug 20, 2009 at 12:44 am
    Aug 20, 2009 at 2:44 am
  • We have a partitioned table structure where the partitions are created on a daily basis. One of the inserts into the daily partition failed (crashed) ..the partition was empty after the crash. We did ...
    Anj AduAnj Adu
    Aug 18, 2009 at 5:44 pm
    Aug 19, 2009 at 4:32 pm
  • Hi All; I know part of the function name "get_registration_auth" (this part of its name) while its name might be "voipdb_get_registration_auth_gnugk", how can I search for the functions that its name ...
    Bilal ghayyadBilal ghayyad
    Aug 18, 2009 at 9:20 am
    Aug 18, 2009 at 2:00 pm
  • Hi We are certifying a postgres 8.4 version on a 64 bit platform. We also need to support 32 bit. Can we dump the schema from the 64 bit install and import that with a 32 bit install ?
    Anj AduAnj Adu
    Aug 17, 2009 at 9:26 pm
    Aug 17, 2009 at 9:29 pm
  • Hello. Let's say in a commercial environment where you install the database in a customer's server and their IT people have admin/root access to this server. How can we make sure that they don't get ...
    Aug 14, 2009 at 5:15 am
    Aug 14, 2009 at 11:30 pm
  • Postgresql 8.2 When I do a full vacuum of our database I get the following: NOTICE: relation "pg_class" TID 23/39: DeleteTransactionInProgress 4060299835 --- can't shrink relation NOTICE: relation ...
    Campbell, LanceCampbell, Lance
    Aug 14, 2009 at 4:06 pm
    Aug 14, 2009 at 4:53 pm
  • Hi All Version 8.1 I am new to postgres and trying to find a way to get the actual space usage of a table. The table size is 28GB but I have deleted a lot of rows which is not getting reflected. I ...
    Anantha V PadmanabanAnantha V Padmanaban
    Aug 11, 2009 at 7:50 am
    Aug 13, 2009 at 6:14 pm
  • Hi all; we want to insert a single backslash into a bytea column (running postgres v 8.3.5) this works to insert 2 backslashes (but we only want one): insert into test_bytea_tab (id, bytea_test_col) ...
    Kevin KempterKevin Kempter
    Aug 11, 2009 at 8:13 pm
    Aug 11, 2009 at 11:50 pm
  • Hello all, when I do "netstat -an" I get the following lines: tcp 0 0* LISTEN tcp 0 0 ESTABLISHED tcp 0 0 ...
    Frank BroniewskiFrank Broniewski
    Aug 7, 2009 at 10:55 am
    Aug 7, 2009 at 2:48 pm
  • Hi all, Where postgresql saves the next OID to be used in any record? I need to read it and use in a temporary field (unique) until the user put the correct value, I don't want to use sequences ...
    Nelson GonzagaNelson Gonzaga
    Aug 5, 2009 at 11:13 am
    Aug 5, 2009 at 3:08 pm
  • Hi folks, were running Postgres 8.2.5 and Linux Redhat. I run a cron script to start our server using pg_ctl after I copy the data cluster over from a replicated server. To test the start success / ...
    Mark StebenMark Steben
    Aug 3, 2009 at 3:33 pm
    Aug 3, 2009 at 3:50 pm
  • Hi all; I'm moving a db install from one server to another. the source box had 2 tablespaces and I see this in the pg_tblspc dir: lrwxrwxrwx 1 postgres postgres 20 2009-08-10 19:23 17261 - ...
    Kevin KempterKevin Kempter
    Aug 30, 2009 at 3:53 am
    Aug 30, 2009 at 3:53 am
  • Hi, Is it possible to use a map in pg_ident.conf with PAM authentication? Cheers --Mike
    Michael BryantMichael Bryant
    Aug 28, 2009 at 4:52 pm
    Aug 28, 2009 at 4:52 pm
  • Efficient Frontier is looking for dynamic individuals who want to be part of building solutions that change the economics of online marketing. As part of Efficient Frontier's world-class team, you ...
    Aug 28, 2009 at 7:28 am
    Aug 28, 2009 at 7:28 am
Group Navigation
period‹ prev | Aug 2009 | next ›
Group Overview
grouppgsql-admin @

89 users for August 2009

Scott Marlowe: 17 posts Alvaro Herrera: 15 posts Tom Lane: 15 posts Kevin Grittner: 11 posts Kevin Kempter: 8 posts Kenneth Marshall: 7 posts Anj Adu: 6 posts Benjamin Krajmalnik: 5 posts Emanuel Calvo Franco: 5 posts Plugge, Joe R.: 5 posts Gnanam: 4 posts James bardin: 4 posts Jan-Peter Seifert: 4 posts Jonatan Evald Buus: 4 posts Bricklen: 3 posts Devrim Gündüz: 3 posts OldManRiver: 3 posts Pablo Alonso-Villaverde Roza: 3 posts Steve Crawford: 3 posts Andy Shellam: 2 posts
show more