FAQ

PostgreSQL > pgsql-general > November 2012

Search Discussions

187 discussions - 944 posts

  • Hello everyone, I'm seeking help in diagnosing / figuring out the issue that we have with our DB server: Under some (relatively non-heavy) load: 300...400 TPS, every 10-30 seconds server drops into ...
    VladVlad
    Nov 14, 2012 at 9:14 pm
    Nov 25, 2012 at 11:07 pm
  • I tried this and I get an error that 'psql: FATAL: role "postgres" does not exist' -----Original Message----- From: <span class="m_body_email_addr" title="63d2823e5298e02f79737df2eb726a85" ...
    Kevin BurtonKevin Burton
    Nov 1, 2012 at 1:01 am
    Nov 3, 2012 at 5:19 am
  • We upgraded to 9.1 from 8.4 over the summer a few months ago, to new DB servers with more disk space and memory. Unexpectedly, the DB servers have steadily increased their disk space usage since ...
    ListsLists
    Nov 6, 2012 at 3:01 am
    Nov 13, 2012 at 6:31 pm
  • Hi, Does anyone know whether PostgreSQL has complete functional test cases? And where can I find them? Currently, I only find some test cases in "PG_SOURCE/src/tests", but it seems that they are ...
    Tianyin XuTianyin Xu
    Nov 6, 2012 at 7:45 am
    Nov 9, 2012 at 1:02 pm
  • hi, I've try to restore Postgres to a specific time but failed. The recovery.conf as bellow restore_command='cp /t/xlog/%f %p' recovery_target_time='2012-11-22 5:01:09 CST' ...
    WdWd
    Nov 22, 2012 at 11:28 am
    Nov 28, 2012 at 5:26 am
  • Hello, I wish to return the SELECT statement. Ho can I achieve this? DO $$ DECLARE v_some_id int=14; BEGIN /* more queries here... */ SELECT 'this is text'; END $$ LANGUAGE plpgsql; Best, Peter Kroon
    Peter KroonPeter Kroon
    Nov 23, 2012 at 10:37 am
    Nov 26, 2012 at 7:57 pm
  • Is there any practical difference between defining a column as a varchar(n)vs. a varchar vs. a text field? I've always been under the impression that if I am wanting to index a varchar column, it is ...
    Moshe JacobsonMoshe Jacobson
    Nov 5, 2012 at 8:46 pm
    Nov 19, 2012 at 1:10 am
  • I've a bunch of databases that cannot be dropped in any case. I was wondering if it is possible to revoke "drop database" permission for all users, in order that even superuser, if he wishes to drop ...
    Edson RichterEdson Richter
    Nov 9, 2012 at 11:20 am
    Dec 2, 2012 at 10:32 am
  • Hi, I'm looking for some general info on the behavior of CLUSTER. I add large amounts of data to an existing table something like this: BEGIN; DROP INDEX IF EXISTS xgen1011_si_sn; COMMIT; BEGIN ...
    Schnabel, Robert D.Schnabel, Robert D.
    Nov 29, 2012 at 4:11 pm
    Nov 29, 2012 at 7:55 pm
  • Is a temp table created to memory(ram) or disk? I've converted some msssq
    Peter KroonPeter Kroon
    Nov 23, 2012 at 9:11 am
    Nov 28, 2012 at 11:23 pm
  • For now. If it really works, then by definition it does not /need/ to be that long, as the truncated version is not blowing things up. Part ORM fault, part Postgres. We really should be throwing ...
    Greg Sabino MullaneGreg Sabino Mullane
    Nov 18, 2012 at 3:49 am
    Nov 23, 2012 at 4:34 pm
  • Hi, was wondering if there is anyone wanted to share some experiences gained and some knowledge on pl/Java. Have looked into it for a couple of days now and am getting the impression it is not ...
    Thomas HillThomas Hill
    Nov 19, 2012 at 8:02 am
    Nov 21, 2012 at 2:08 am
  • Hi. I've been struggling with understanding all the necessary pieces for streaming replication. So I put down the pieces as I did understand them, and would appreciate if you guys could point out any ...
    Pawel VeselovPawel Veselov
    Nov 10, 2012 at 1:31 am
    Nov 14, 2012 at 2:31 pm
  • Hi, I am running a PostgreSQL server on FreeBSD. The system has 32GB memory. Usually I use top to examine the memory usage of the system. After a while, a part, approximately 5GB, vanish from top, so ...
    Frank BroniewskiFrank Broniewski
    Nov 5, 2012 at 10:23 am
    Nov 9, 2012 at 10:17 am
  • This is probably a question for the authors of a book I have been reading but it may be faster to get an answer here. I was trying to follow along in a book 'Seven Databases in Seven Weeks' and ...
    Kevin BurtonKevin Burton
    Nov 1, 2012 at 3:33 pm
    Nov 2, 2012 at 9:51 pm
  • turn the vol down a bit: http://www.youtube.com/watch?v=1PoFIohBSM4 the answer is d)
    Ray StellRay Stell
    Nov 29, 2012 at 1:48 pm
    Nov 30, 2012 at 5:34 am
  • Hi, The following SQL join command runs the PostgreSQL server out of memory. The server runs on a box with Red Hat Enterprise Linux Server release 6.3 (Santiago) and PostgreSQL 8.3.21. select wm_nfsp ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    Nov 8, 2012 at 10:21 am
    Nov 14, 2012 at 2:44 pm
  • I had a 9.0.8 hot standby setup, one master, two slaves, working great. Then, I tried to re-initialize by making a base backup, the way I've done it many times before, but for some reason I can't get ...
    Ian HardingIan Harding
    Nov 6, 2012 at 3:40 am
    Nov 6, 2012 at 4:58 pm
  • I've installed Npgsql via Application stack builder without a problem(I guess, no error messages seen). http://npgsql.projects.pgfoundry.org/docs/manual/UserManual.html The projectpage tells me I ...
    Peter KroonPeter Kroon
    Nov 23, 2012 at 6:13 pm
    Nov 26, 2012 at 9:05 pm
  • I want to process all the records in a table through a C-language (well, C++) function (i.e. one function call per row of the table) in such a way that the function hangs onto its internal state ...
    MattMatt
    Nov 19, 2012 at 12:41 pm
    Nov 21, 2012 at 4:20 am
  • Hi I am using 9.1.6, and I've set up a partitioned table as described in the manual, with partitions based on a timestamptz column called 'time'. The exclusion constraints work nicely when I select ...
    Thomas MunroThomas Munro
    Nov 6, 2012 at 7:41 am
    Nov 18, 2012 at 2:35 am
  • Hey guys, I don't notice any errors, which just makes this even more strange. But after weeks of operating normally, our 10pm manual vacuum job generated transaction logs basically equivalent to 3/4 ...
    Shaun ThomasShaun Thomas
    Nov 1, 2012 at 2:04 pm
    Nov 3, 2012 at 4:46 pm
  • Greetings, I'm looking to obtain the name of a column that is passed to a function, similar to xmlforest. Suggestions? Regards, Rhys
    Rhys A.D. StewartRhys A.D. Stewart
    Nov 20, 2012 at 7:36 pm
    Nov 22, 2012 at 6:59 pm
  • Hi Sorry for my English. I'm running pgsql8.4 server on debian,the client is the python library(psycopg2) on the same mechine. The client connect server via 127.0.0.1:5432. The psycopg2 connect ...
    Dongkuo MaDongkuo Ma
    Nov 2, 2012 at 2:24 am
    Nov 2, 2012 at 3:48 am
  • Hello, In Postgresql 9.2 this function pg_listening_channels() returns the channels that the current session/connection listens to. How (if it's even possible) can I get listening channels for all ...
    Igor NeymanIgor Neyman
    Nov 27, 2012 at 8:58 pm
    Dec 1, 2012 at 4:58 pm
  • Hi All , When am trying to query a table temp_table1(sms_type varchar(20),sms_info varchar(100),sms_id integer) Query :: select sms_type,count(*) from temp_table1 group by 1 order by 2 desc; Then i ...
    Ranjeet DhumalRanjeet Dhumal
    Nov 21, 2012 at 11:23 am
    Nov 22, 2012 at 6:35 am
  • Hi, suppose for a moment I want to write a psql script that loads some data into a database. I don't want to write an absolute path into my script, but merely know where the data file will be ...
    Matthew VernonMatthew Vernon
    Nov 20, 2012 at 6:48 pm
    Nov 23, 2012 at 10:31 am
  • Hi all, Can you please tell me , how to set up replication in win7, without slony tool.. -- Best Regards, Vishalakshi.N
    Vishalakshi NavaneethakrishnanVishalakshi Navaneethakrishnan
    Nov 2, 2012 at 7:33 am
    Nov 21, 2012 at 9:31 am
  • Hi, How can I list all schema names inside a PostgreSQL database through SQL, especially thoese without any objects created inside it. Regards, Xiaobo Gu
    Xiaobo GuXiaobo Gu
    Nov 15, 2012 at 12:31 pm
    Nov 19, 2012 at 5:05 am
  • Hi, I installed PostgresSQL-8.3 on my linux machine. The cluster directory is /usr/local/data and I created three databases named db1, db2, and db3. db1 is in the default tablespace 'pg_default'. db2 ...
    Wang, HaoWang, Hao
    Nov 14, 2012 at 7:50 am
    Nov 15, 2012 at 9:54 am
  • Greetings all, having a permission issue with writing a file using plpython to a local folder, changed permissions to everyone read and write and even changed the owner to postgres. but no joy, any ...
    Rhys A.D. StewartRhys A.D. Stewart
    Nov 14, 2012 at 4:45 pm
    Nov 15, 2012 at 1:21 am
  • I am trying to make a trigger that updates a row once and only once per transaction (even if this trigger gets fired multiple times). The general idea is that for a user we have a version number ...
    Mike LewisMike Lewis
    Nov 6, 2012 at 10:55 pm
    Nov 8, 2012 at 10:21 am
  • Hi, I'm wondering which type of SSDs would be better for use with PostgreSQL. Background: At the moment, SSD drives fall into two categories.. Those that use internal-compression on the SandForce ...
    Toby CorkindaleToby Corkindale
    Nov 14, 2012 at 7:11 am
    Dec 11, 2012 at 5:51 pm
  • Hi, In the absence of query caching AND NOT WANTING TO FORCE THE APPLICATION TO DO SO EXPLICITLY, I'm looking for ideas as to how I should "future-safe" the design of some custom user base types and ...
    Bexley HallBexley Hall
    Nov 24, 2012 at 11:04 pm
    Nov 25, 2012 at 8:12 pm
  • I am facing problem i.e. connections after execution completed are residing in pg_stat_activity and pg_stat_database. but when i am trying to kill them manually using pg_terminate_backend (All IDLE ...
    HarryHarry
    Nov 16, 2012 at 6:34 am
    Nov 20, 2012 at 1:45 pm
  • Hi, Postgresql, I want to understand how the query optimizers affect the output of the window functions. For example, set "cpu_tuple_cost = 50" in postgresql.conf and start the server, I apply the ...
    Tianyin XuTianyin Xu
    Nov 14, 2012 at 8:12 am
    Nov 14, 2012 at 11:04 pm
  • Hi all： I made partition tables: postgres=# create table ptest(id integer, name varchar(20)); CREATE TABLE postgres=# create table ctest01(CHECK(id<5000000)) inherits (ptest); CREATE TABLE postgres=# ...
    高健高健
    Nov 12, 2012 at 2:39 am
    Nov 12, 2012 at 2:20 pm
  • I have streaming replication configured over SSL, and there seems to be a problem with SSL renegotiation. This is from the primary's log: 2012-11-06 00:13:10.990 ...
    Albe LaurenzAlbe Laurenz
    Nov 6, 2012 at 9:48 am
    Nov 8, 2012 at 1:22 pm
  • Can anyone suggest how I could verify that the files created by pg_dump are "okay"? They are being created for backup purposes, and the last thing I want to do is find out that the backups themselves ...
    GaryGary
    Nov 7, 2012 at 1:40 pm
    Nov 7, 2012 at 10:31 pm
  • I'd like to create a function : returning true if the length of the text arg is greater than 0 ; false otherwise ; and also returning false when arg is NULL, then i wrote : CREATE FUNCTION ...
    Yvon ThoravalYvon Thoraval
    Nov 7, 2012 at 5:33 am
    Nov 7, 2012 at 7:57 am
  • Hi all, I read somewhere that the following query gives a quick estimate of the # of rows in a table regardless of the table's size (which would matter in a simple SELECT count(*)?): SELECT (CASE ...
    Thalis KalfigkopoulosThalis Kalfigkopoulos
    Nov 5, 2012 at 10:03 pm
    Nov 6, 2012 at 12:46 am
  • Hi I have an unused computer which I am considering turning into a server to run my Postgresql database. Is this even possible to do? If so, can someone suggest an open source server that is ...
    Bob PawleyBob Pawley
    Nov 3, 2012 at 11:08 pm
    Nov 4, 2012 at 4:43 pm
  • In a query plan, I noticed the following: Join Filter: (((all_permissions.role_recursive AND (alternatives: SubPlan 5 or hashed SubPlan 6)) OR (permitted_e.id = deployed_e.id)) AND (NOT (SubPlan ...
    Christophe PettusChristophe Pettus
    Nov 28, 2012 at 9:07 pm
    Nov 28, 2012 at 10:50 pm
  • Hi,First sorry for my bad English :D.I'm new in PostgreSQL and database .Now i'm researching about statistic correlation .I want to make a example with the table -assume that I have tbl_test table ...
    Classical_89Classical_89
    Nov 26, 2012 at 9:52 am
    Nov 27, 2012 at 8:31 pm
  • Hi All , Am facing one problem related to pg_toast table , its grown very huge upto 31GB , even am vacuuming(not full) it daily , my fsm parameters are default, can anyone tell how to decrease the ...
    Ranjeet DhumalRanjeet Dhumal
    Nov 26, 2012 at 6:36 am
    Nov 26, 2012 at 10:31 am
  • While converting a mysql database into postgres, I stumbled over the following problem: As the value for "filesize" suggests, this is a very large BYTEA (formerly: LONGBLOB) entry with about 300 MB ...
    Stefan FroehlichStefan Froehlich
    Nov 25, 2012 at 5:19 pm
    Nov 25, 2012 at 8:11 pm
  • Hello, I'm analysing a way to avoid one of the password attack vectors for web services, which goes like this: 1. acquire passwords database (assuming passwords are hashed) 2. run cracking software ...
    Rafal PietrakRafal Pietrak
    Nov 24, 2012 at 9:15 am
    Nov 24, 2012 at 2:48 pm
  • Hello, How do I declare a variable after BEGIN? I want to declare it in the if statement. DROP FUNCTION IF EXISTS tmp_test(integer); CREATE FUNCTION tmp_test( p_id integer ) RETURNS text AS $$ ...
    Peter KroonPeter Kroon
    Nov 21, 2012 at 11:42 am
    Nov 21, 2012 at 12:11 pm
  • Hello, We are running 9.2 w/ streaming replication. The slave is used for heavy tsearch based data mining. Apparently depending on the business of the master the slave queries fail with different ...
    T. E. LawrenceT. E. Lawrence
    Nov 17, 2012 at 2:08 pm
    Nov 20, 2012 at 10:25 pm
  • Hi, I'm having a hard time figuring out how to use split_part with a carriage return (hex 0a) as the delimiter. Would someone please offer me a clue? Thanks! Jeff Ross
    Jeff RossJeff Ross
    Nov 19, 2012 at 7:49 pm
    Nov 19, 2012 at 9:09 pm
Nov 2012
1234
Group Navigation
period‹ prev | Nov 2012 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions187
posts944
users232
websitepostgresql.org
irc#postgresql

232 users for November 2012

Tom Lane: 47 posts Jeff Janes: 37 posts Merlin Moncure: 36 posts Albe Laurenz: 33 posts Craig Ringer: 32 posts Adrian Klaver: 30 posts Peter Kroon: 28 posts Kevin Grittner: 27 posts Kevin Burton: 23 posts Vlad Marchenko: 22 posts Chris Angelico: 20 posts Pavel Stehule: 20 posts Shaun Thomas: 18 posts David Johnston: 14 posts Tianyin Xu: 14 posts Lists: 13 posts Scott Marlowe: 13 posts Bruce Momjian: 12 posts Jasen Betts: 12 posts John R Pierce: 12 posts
show more
Archives