FAQ

Search Discussions

151 discussions - 795 posts

  • Hi all, I've upgrade from 9.1.4 to 9.2.4, and got some very weird issue. My server got connections with RES (column from top utility) with too much memory: top - 19:50:58 up 384 days, 23:55, 2 users, ...
    Daniel Cristian CruzDaniel Cristian Cruz
    Apr 20, 2013 at 11:00 pm
    Apr 25, 2013 at 2:24 am
  • Hi Group, I'm using PG 9.1.9 with a client application using various versions of the pgsqlODBC driver on Windows. Cursors are used heavily, as well as some pretty heavy trigger queries on db writes ...
    Joshua BerryJoshua Berry
    Apr 10, 2013 at 9:34 pm
    Apr 12, 2013 at 11:12 am
  • It currently takes up to 24h for us to run a large set of UPDATE statements on a database, which are of the form: UPDATE table SET field1 = constant1, field2 = constant2, ... WHERE id = constid ...
    Yang ZhangYang Zhang
    Apr 27, 2013 at 12:15 am
    Apr 28, 2013 at 4:31 am
  • I can't understand what is going on with my PostgreSQL server. For some reason after I GRANT my role 'carlos' to the 'dba' group role, I lose the ability to login. I've reset the password over and ...
    Carlos MennensCarlos Mennens
    Apr 15, 2013 at 2:30 pm
    Apr 18, 2013 at 1:40 pm
  • Hello all Pretty sure this should be simple - how can I select a timestamp from a database? The timestamp is stored in the db like this: 2013/04/08 13:54:41 GMT+1 How can I select based on that ...
    Richard HarleyRichard Harley
    Apr 8, 2013 at 1:05 pm
    Apr 8, 2013 at 11:16 pm
  • I would like some assistance in understanding of template1 database.- I want to know the tables of tempate1- I want to know when there is any insertion/updation in template1 theoretically.- If i want ...
    S HS H
    Apr 23, 2013 at 2:48 am
    Apr 25, 2013 at 2:21 am
  • I'm running into a strange issue whereby my postgres processes are slowly creeping to 100% CPU utilization. I'm running postgresql-server-9.2.3, FreeBSD 8.3-RELEASE-p6, and using the ...
    David NoelDavid Noel
    Apr 2, 2013 at 10:35 pm
    Apr 4, 2013 at 11:25 pm
  • List, SQL seems to be behaving in a case-sensitive manner: universe=# select 1; ?column? ---------- 1 (1 row) universe=# SELECT 1; ERROR: syntax error at or near "SELECT 1" LINE 1: SELECT 1; ^ I ...
    Lee HachadoorianLee Hachadoorian
    Apr 16, 2013 at 9:46 pm
    Apr 17, 2013 at 1:22 am
  • Hello ppl, I have a database where the previous owner use US date format in date fields: 2009-02-18 Is there a way how to convert the fields in European format 18-02-2009. I mean existing date in ...
    CondorCondor
    Apr 10, 2013 at 1:04 pm
    Apr 12, 2013 at 1:23 pm
  • Hi all, I need a tool which allows me to do a task before every SELECT on a table. Specifically,the behavior I would get with a BEFORE SELECT trigger. Please advice me on this. Regards, Atri -- ...
    Atri SharmaAtri Sharma
    Apr 18, 2013 at 7:55 am
    Apr 18, 2013 at 2:38 pm
  • I would appreciate some advice from the experts on this list about the best backup strategy for my database. The setup: Size: might be about 200Gb The server uses a Tivoli backup client with daily ...
    Johann SpiesJohann Spies
    Apr 8, 2013 at 1:15 pm
    Apr 16, 2013 at 11:50 am
  • Howdy, I'm having a couple of problems that I believe are related to AWS and I'm wondering if anyone's seen them / overcome them. Brief background, I'm running PG 9.2.4 in a VPC on Amazon Linux. I'm ...
    David KerrDavid Kerr
    Apr 8, 2013 at 7:59 pm
    Apr 9, 2013 at 2:20 am
  • Is it possible to downgrade PostgreSQL by a major version? If I want to upgrade a PG database from 8.x to 9.x, I have to dump the db, install the new binaries and import the dump file. This works ...
    Pete WallPete Wall
    Apr 5, 2013 at 10:33 pm
    Apr 8, 2013 at 3:35 pm
  • Hello, I have one query in my postgresql 9.2.3 that took 137 ms to me executed and looking a way what I can do to optimize it. I have one table generated numbers from 1 to 1 000 000 and I need to get ...
    CondorCondor
    Apr 4, 2013 at 9:32 pm
    Apr 6, 2013 at 7:16 pm
  • Hi all! I track Twitter followers in my database. I have the following table: # \d persona_followers Table "public.persona_followers" Column | Type | Modifiers ...
    François BeausoleilFrançois Beausoleil
    Apr 17, 2013 at 2:51 am
    Apr 24, 2013 at 4:39 pm
  • We have a report in our system that is pulled many times each week, but needs to be based off data from Sunday at noon. So every Sunday at noon, we back up our main database and restore it into a new ...
    Moshe JacobsonMoshe Jacobson
    Apr 22, 2013 at 3:59 pm
    Apr 23, 2013 at 2:33 am
  • I get Godaddy's page saying it's free --- --- Eduardo Morras <<span class="m_body_email_addr" title="7a600079c29d668390fecd756c7fd555" emorrasg@yahoo.es</span
    Eduardo MorrasEduardo Morras
    Apr 18, 2013 at 8:31 am
    Apr 18, 2013 at 7:59 pm
  • Hi. I was promoting PostgreSQL to an AIX/Oracle shop yesterday, they are looking to switch to open source to cut their licensing costs, and was asked how large a database does PostgreSQL support? Is ...
    Aleksey TsalolikhinAleksey Tsalolikhin
    Apr 17, 2013 at 1:24 pm
    Apr 17, 2013 at 7:53 pm
  • Hi PostgreSQL friends, I have two databases in the same cluster that are almost identical. One is a copy of the other as we are developing some new features in the copy. My problem is that the exact ...
    Moshe JacobsonMoshe Jacobson
    Apr 16, 2013 at 7:07 pm
    Apr 17, 2013 at 3:32 pm
  • Any hints with this question I had posted to SO? http://stackoverflow.com/questions/15965785/why-is-postgresql-9-1-not-using-index-for-simple-equality-select Pasted here as well. Thanks. My table ...
    Yang ZhangYang Zhang
    Apr 12, 2013 at 8:04 am
    Apr 12, 2013 at 5:42 pm
  • hello sir/mam This is Govind Kumar Sah, a 3rd year student of UIET,PU Chandigarh and am pursuing B E in CSE trade. I am new in this community and am already read about this community and i liked it ...
    Govind kumar sahGovind kumar sah
    Apr 7, 2013 at 1:56 pm
    Apr 8, 2013 at 6:42 pm
  • Hey! So, Packt approached me a few months ago and asked me to put together a very basic series of short step-by-step instructions on backing up PostgreSQL. The title is "Instant PostgreSQL Backup and ...
    Shaun ThomasShaun Thomas
    Apr 3, 2013 at 2:09 pm
    Apr 3, 2013 at 11:32 pm
  • Hi, had a bit of weird result for a query: SELECT id FROM spectrum_match WHERE search_id in (788,694,693,685) AND rescored IS NOT NULL and dynamic_rank = true ORDER BY ID; returns (among some 127K ...
    Lutz FischerLutz Fischer
    Apr 29, 2013 at 5:52 pm
    Apr 30, 2013 at 2:21 pm
  • Hi, I am in the process of converting some TEXT data which I try to identify by regular expression. What I don't understand is: Why does the following return a substring ? select substring ('junk ...
    Karsten HilbertKarsten Hilbert
    Apr 25, 2013 at 2:11 pm
    Apr 28, 2013 at 5:29 pm
  • ... or not (I'm not quite sure) Hello, I have the following tables: CREATE TABLE orders (info text, ....); CREATE TABLE keywords (phrase text, .....); And I need to find all the ORDERS rows, which ...
    Rafał PietrakRafał Pietrak
    Apr 22, 2013 at 1:15 pm
    Apr 23, 2013 at 1:31 pm
  • Hi, I'm having a problem on a standby server (streaming replication) where a table seems to exist but is not queryable. Essentially a select statement (and drop/insert/etc) fails but \d and pg_tables ...
    Dale FukamiDale Fukami
    Apr 16, 2013 at 8:29 pm
    Apr 17, 2013 at 7:07 pm
  • Hi, I'm running a server using postgres 8.3 and i was adviced to update it... what i have to do in order to update it and don't stop the service? Also, will clients running postgres 8.3 be able to ...
    JpuiJpui
    Apr 11, 2013 at 8:29 am
    Apr 11, 2013 at 8:06 pm
  • is it possible to created materialized view in postgresql 8.3 if yes please provide some sample.
    Zahid QuadriZahid Quadri
    Apr 8, 2013 at 7:17 am
    Apr 10, 2013 at 2:44 pm
  • Hello I have a setup with one master and two slaves which are used by a closed source application. The database is asked the same query, a stored procedure, with different parameters about 4 million ...
    Christian HammersChristian Hammers
    Apr 9, 2013 at 9:41 am
    Apr 9, 2013 at 6:45 pm
  • First I need to say that I'm asking this question on behalf of "a friend", who asked me what I thought on the subject -- I host all the databases important to me and my livelihood, on physical ...
    David BorehamDavid Boreham
    Apr 7, 2013 at 1:51 am
    Apr 8, 2013 at 5:00 pm
  • We're running on EBS volumes on EC2. We're interested in leveraging EBS snapshotting for backups. However, does this mean we'd need to ensure our pg_xlog is on the same EBS volume as our data? (I ...
    Yang ZhangYang Zhang
    Apr 27, 2013 at 1:44 am
    Apr 30, 2013 at 5:38 pm
  • Hi All, I've come upon some very strange behaviour with an UPDATE query which causes Postgres to consume all the disk space on the server for no apparent reason. Basically, I'm trying to run an ...
    Rowan CollinsRowan Collins
    Apr 26, 2013 at 2:40 pm
    Apr 29, 2013 at 5:54 pm
  • I have two tables with countries and persons living in those countries: create table countries ( code char(2) not null primary key, eu boolean not null ); insert into countries values ('AR', false), ...
    CR LenderCR Lender
    Apr 26, 2013 at 9:01 am
    Apr 28, 2013 at 10:14 pm
  • We are going to be upgrading our postgres version from 8.3.4 to 9.2.4 in the near future. Can anyone give me a short list of "gotchas" concerning problems we might step into? We have a number of ...
    Paul TillesPaul Tilles
    Apr 3, 2013 at 5:14 pm
    Apr 19, 2013 at 2:27 pm
  • Hi Firstly let me mention I am a noob to postgres,DB and sql anyway, I have a column with First names and need to list names that have non-alphanumeric characters in them like + or * and the list ...
    Baboo, IsaBaboo, Isa
    Apr 12, 2013 at 6:26 am
    Apr 12, 2013 at 7:17 am
  • hi,, please suggest if there is any way which i can find which tables need indexes in postgresql.
    Zahid QuadriZahid Quadri
    Apr 10, 2013 at 11:49 am
    Apr 10, 2013 at 2:34 pm
  • Im planning to publish my postgresql server to a few untrusted clients. I dont want them to modify any runtime setting, like work_mem or something risky to my server. In general I assume the ...
    Fabio Rueda CarrascosaFabio Rueda Carrascosa
    Apr 9, 2013 at 3:28 pm
    Apr 9, 2013 at 4:20 pm
  • Hi, Sorry for this newbie-question, I am trying for quite some time now to get the following trigger-function to work properly: CREATE OR REPLACE FUNCTION update_synced_column() RETURNS trigger AS ...
    Clemens EissererClemens Eisserer
    Apr 5, 2013 at 7:59 pm
    Apr 7, 2013 at 2:49 pm
  • Hey all, We have a very robust Oracle and SQL Server presence at work but we're looking to farm out some of the load to PostgreSQL to limit costs. I'm curious if there are any DBAs out there who have ...
    Roy AndersonRoy Anderson
    Apr 4, 2013 at 2:16 pm
    Apr 6, 2013 at 2:59 am
  • Hi, I recently stumbled upon a really cool feature in DB2: distinct types. DB2 lets you define your own types (just as Postgres) but with the added benefit that you can mark them such that they are ...
    Thomas KellererThomas Kellerer
    Apr 21, 2013 at 11:17 am
    Apr 29, 2013 at 7:01 am
  • Hi all, I have a Postgresql 9.2 instance running on a CentOS6.3 box.Yesterday i setup a hot standby by using pgbasebackup. Today i got the below alert from standby box : [1] (from line 412,723) ...
    Adarsh SharmaAdarsh Sharma
    Apr 25, 2013 at 12:05 am
    Apr 26, 2013 at 4:22 am
  • Hi, I have a UDF (written in C) that returns SETOF RECORD of an anonymous record type (defined via OUT parameters). I'm trying to use array_agg() to transform its output to an array: pg_dev=# SELECT ...
    Stephen ScheckStephen Scheck
    Apr 24, 2013 at 7:48 pm
    Apr 25, 2013 at 1:25 pm
  • Hello, I would like to have one or more session-scoped global variables that are useable in a similar way to sequence generators, via analogies to setval()+currval(). Here's a (simplified) scenario ...
    Darren DuncanDarren Duncan
    Apr 24, 2013 at 11:18 pm
    Apr 25, 2013 at 11:48 am
  • I would like to run the COPY command as a user other than "postgres". I find it a bit of a pain (or at least requiring an extra step or two) to have the postgres user own the files that I am creating ...
    Kirk WythersKirk Wythers
    Apr 23, 2013 at 8:16 pm
    Apr 24, 2013 at 3:14 pm
  • Hi, I used omnipitr to launch a base backup, but I fumbled a couple of things, so I Ctrl+C'd *once* the console where I had omnipitr-backup-master running. omnipitr-backup-master correctly launched ...
    François BeausoleilFrançois Beausoleil
    Apr 23, 2013 at 7:09 pm
    Apr 24, 2013 at 1:31 pm
  • Hi all We are running postgres 9.1 on CentOS 5. We can’t start up postgres . It complains about memory allocation . Please help FATAL: shmat(id=3342337) failed: Cannot allocate memory # - Memory - ...
    Khangelani GamaKhangelani Gama
    Apr 24, 2013 at 5:53 am
    Apr 24, 2013 at 6:45 am
  • Hi All - I have created a dump of a big table into 5 split files. What is the procedure to restore them using pg_dump. I am getting the following error pg_restore: [custom archiver] could not read ...
    Akp geekAkp geek
    Apr 22, 2013 at 7:35 pm
    Apr 22, 2013 at 11:34 pm
  • Hello, I use a PG database on a HPC system (cluster). My processes get a dataset from the database and change the row, each process is independend. My table shows something like: id, status, data id ...
    Philipp KrausPhilipp Kraus
    Apr 16, 2013 at 2:50 pm
    Apr 19, 2013 at 12:41 pm
  • Hi There, I'm having a bit of an issue finding a C function to fetch the configured server port from a C module. We have written a C module to allow for remote clients to call a function to run ...
    Mike RoestMike Roest
    Apr 17, 2013 at 7:08 pm
    Apr 17, 2013 at 8:45 pm
  • Hi all, I'm having issues with slow queries using postgres, and I'm finding some of the issues difficult to reproduce. My application logs slow queries for me, but often, when I go back to run ...
    Ramsey GurleyRamsey Gurley
    Apr 8, 2013 at 10:08 pm
    Apr 9, 2013 at 4:52 pm
Group Navigation
period‹ prev | Apr 2013 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions151
posts795
users226
websitepostgresql.org
irc#postgresql

226 users for April 2013

Adrian Klaver: 52 posts Tom Lane: 50 posts John R Pierce: 26 posts Merlin Moncure: 23 posts Jeff Janes: 16 posts Kevin Grittner: 16 posts Yang Zhang: 16 posts François Beausoleil: 13 posts Jasen Betts: 13 posts Shaun Thomas: 13 posts Andres Freund: 12 posts Daniel Cristian Cruz: 12 posts Gavin Flower: 12 posts Misa Simic: 9 posts Rafał Pietrak: 9 posts Ascot Moss: 8 posts Atri Sharma: 8 posts David Noel: 8 posts Igor Neyman: 8 posts Moshe Jacobson: 8 posts
show more
Archives