[GENERAL] Upgrading hot standbys

Greetings, I'm in the process of upgrading PG 9.1.3 to 9.4.1 in the near future. I have several machines which each house unique databases. Each of those are replicated to a standby server with matching configurations. A total of 10 servers, 5 masters, 5 slaves. Everything runs on Ubuntu.

[GENERAL] question on writing a function

Greetings all, I *think* there¹s a way to accomplish what I want, but it is eluding me at this time. Any help or pointers will be greatly appreciated. What I am trying to accomplish is that when a member deactivates their account through the UI, my trigger will call a function that deletes or ar

Re: [GENERAL] odd intermittent query hanging issue

Thanks Steve, Answers are inserted below: On 5/18/12 11:09 AM, "Steve Crawford" wrote: >On 05/18/2012 09:17 AM, Aaron Burnett wrote: >> Greetings, >> >> I run a handful of queries overnight when traffic is at it's lowest on >>our >> system. One

[GENERAL] odd intermittent query hanging issue

Greetings, I run a handful of queries overnight when traffic is at it's lowest on our system. One particular query will run perfectly fine (around 5 seconds) for several weeks, then suddenly decide to hang indefinitely and never finish. It needs to be killed manually after several hours (I've int

Re: [GENERAL] Pg 9.1.3 pg_crypto question

Thanks, Tom. That was exactly it. Best Regards On 4/10/12 2:50 PM, "Tom Lane" wrote: >Aaron Burnett writes: >> 9.1.3 is just not decrypting nor throwing errors. > >> 9.1.3# select decrypt_iv(decode('rkMRWpnnbjaFoHyLmCD/bg==', 'base64'

[GENERAL] Pg 9.1.3 pg_crypto question

Hi, Finally upgrading from 8.2.5 to 9.1.3 (got the latest release as of 3/12/2012) OS: Ubuntu 11.10 The only issue I am encountering is in the pg_crypto/decrypt_iv/decode No errors in the log, but here's what I am seeing on both 8.2.5 and 9.1.3, I am hoping someone can help me out here: 8.2.5#

[GENERAL] Some insight on the proper SQL would be appreciated

Greetings, I hope this is the proper list for this, but I am a loss on how to achieve one particular set of results. I have a table which is a list of users who entered a contest. They can enter as many times as they want, but only 5 will count. So some users have one entry, some have as many as

Re: [GENERAL] Updating column on row update

this is how I do it if this helps: column_name timestamp without time zone NOT NULL DEFAULT ('now'::text)::timestamp(6) without time zone -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of Thom Brown Sent: Sun 11/22/2009 2:50 PM To: PGSQL Mailing List Subject: [G

Re: [GENERAL] question on viewing dependencies

Thanks Tom, It was not supressed for notice, so I changed it to 'debug1' and it gave me the answers I was looking for. On 2/22/09 6:07 PM, "Tom Lane" wrote: > Aaron Burnett writes: >> Hopefully a quick answer. Went to drop a table: > >> drop table t

[GENERAL] question on viewing dependencies

Hi, postgresql version 8.25 running on RHEL4 Hopefully a quick answer. Went to drop a table: drop table table_foo; ERROR: cannot drop table table_foo because other objects depend on it HINT: Use DROP ... CASCADE to drop the dependent objects too. Wanted to see what the dependencies were: BE

[GENERAL] getting elapsed query times

Hi, I think I am experiencing the "forest through the trees" type of scenario here. In a nightly cron I have a shell script that executes a couple of things for our data warehouse. I call it like this from the cron: /home/postgres/DB1/sys/createDB1.sh >> /home/postgres/DB1/logs/createDB1.log 2

Re: [GENERAL] large inserts and fsync

--Original Message- From: Greg Smith [mailto:[EMAIL PROTECTED] Sent: Sat 9/6/2008 4:45 AM To: Tom Lane Cc: Aaron Burnett; Sam Mason; pgsql-general@postgresql.org Subject: Re: [GENERAL] large inserts and fsync On Fri, 5 Sep 2008, Tom Lane wrote: > The trouble with turning fsync off is that a

Re: [GENERAL] large inserts and fsync

Yes, the developer already made sure of that and I verified. On 9/5/08 11:10 AM, "Sam Mason" <[EMAIL PROTECTED]> wrote: > On Fri, Sep 05, 2008 at 09:16:41AM -0400, Aaron Burnett wrote: >> For an upcoming release there is a 16 million row insert that on our test >>

[GENERAL] large inserts and fsync

Forgive me if this is a many-times rehashed topic. I¹m very new to postgresql, most of my background is in Oracle. Running postgres 8.2.5 with one master and three slaves (using slony) For an upcoming release there is a 16 million row insert that on our test cluster takes about 2.5 hours to comp

Re: [GENERAL] Assistance with SQL

Thank you. I was making it way too over-complicated. Works perfectly On 9/1/08 3:39 AM, "hubert depesz lubaczewski" <[EMAIL PROTECTED]> wrote: > On Sun, Aug 31, 2008 at 11:31:32PM -0400, Aaron Burnett wrote: >> table1 has 25 columns >> table2 is a subset of

[GENERAL] Assistance with SQL

Hi, I¹m hoping someone can help me out on this one. Two tables table1 has 25 columns table2 is a subset of table1 (create table2 as select id,field1,field2,field3,field4,field5,field6 from table1) with just 7 columns There is a primary key on ID table2 was exported to a CSV, truncated, then th