[GENERAL] Utilities for managing streaming replication servers?

Hi, I wondered if there were any software packages floating around to manage servers using streaming replication with Pg? ie. To handle failing over and adjusting the config to promote a slave; and performing the steps of syncing and restarting to bring up a new slave. Cheers, Toby -- Sent

Re: [GENERAL] autovacuum issue after upgrade to 9.0.1

On Tue, Mar 15, 2011 at 02:38:37PM -0400, George Woodring wrote: > We recently upgraded from 8.3.something to 9.0.1. With 9.0.1, we have a > huge spike in vacuums every 8 days only on one of our DB servers. Is the one affected DB server part of a group of servers you would expect to behave simil

Re: [GENERAL] constraint partition issue

writes: > CREATE TABLE summary_total > ( > counter bigint DEFAULT 0, > destgeo_id integer DEFAULT 1, > direction integer DEFAULT 1, > mlapp_id integer DEFAULT 1 > ) > CREATE TABLE summary_daily_data > ( > ) > INHERITS (summary_total) > CREATE TABLE summ_dly_1505500 > ( > ) > INHERITS (su

[GENERAL] constraint partition issue

Please help me understanding this execution plan : I have a table and 3 levels of partitions . All the tables on second level have date constraints. Execution plan shows that all partitions are checked by the optimizer, Nothing is excluded. My test example worked fine but this one does not. Tha

Re: [GENERAL] Trigger Function return values

On Tuesday, March 22, 2011 3:12:56 pm Andy Chambers wrote: > Hi, > > How is the return value of a trigger function defined in plpgsql used? I > can't find > anything in the documentation but some of the examples return NULL, and > others return > something like NEW. > > It seems that if the retu

Re: [GENERAL] Trigger Function return values

On Mar 22, 2011, at 4:12 PM, Andy Chambers wrote: > How is the return value of a trigger function defined in plpgsql used? I > can't find > anything in the documentation but some of the examples return NULL, and > others return > something like NEW.

Re: [GENERAL] Weird problems with C extension and bytea as input type

On Tue, 22 Mar 2011 16:14:47 -0500, Merlin Moncure wrote about Re: [GENERAL] Weird problems with C extension and bytea as input type: [snip] >>> On Tue, Mar 22, 2011 at 8:22 AM, Adrian Schreyer >>> wrote: [snip] bytea *b = PG_GETARG_BYTEA_P(0); char *ism; ism = function(b); >>

[GENERAL] Trigger Function return values

Hi, How is the return value of a trigger function defined in plpgsql used? I can't find anything in the documentation but some of the examples return NULL, and others return something like NEW. It seems that if the return statement is omitted, an error occurs when the trigger is fired.

Re: [GENERAL] postgres conferences missing videos?

Dne 22.3.2011 20:29, Susan Cassidy napsal(a): > Personally, I vastly prefer written information to video. I can read far > faster than someone can read/explain something to me. Plus, it is easier to > refer back to. > > Susan > 100% true. But it's also true that slides (and that's all we ha

Re: [GENERAL] postgres conferences missing videos?

On 22/03/2011 19:29, Susan Cassidy wrote: Personally, I vastly prefer written information to video. I can read far faster than someone can read/explain something to me. Plus, it is easier to refer back to. +100 However, I fully appreciate that if it's difficult to find the (wo)manpower to o

Re: [GENERAL] Weird problems with C extension and bytea as input type

On Tue, Mar 22, 2011 at 11:57 AM, Adrian Schreyer wrote: > On Tue, Mar 22, 2011 at 16:07, Merlin Moncure wrote: >> On Tue, Mar 22, 2011 at 8:22 AM, Adrian Schreyer wrote: >>> Hi, >>> >>> I have a weird problem with my custom functions (written in C,C++) >>> that use bytea as input type (cstring

Re: [GENERAL] Install issues

Alex, 22.03.2011 17:33: Using Windows 7 64 bit. Tried to install 8.4 and 9.0and it fails right near the end when it tries to create or read the conf file. If I transfer my postgres 8.4 file over the upgrade takes but the postgres service doesn't exist so no communication occurs. Is there anyw

Re: [GENERAL] Install issues

On 03/22/11 9:33 AM, Alex wrote: Using Windows 7 64 bit. Tried to install 8.4 and 9.0and it fails right near the end when it tries to create or read the conf file. If I transfer my postgres 8.4 file over the upgrade takes but the postgres service doesn't exist so no communication occurs. Is t

[GENERAL] Install issues

Using Windows 7 64 bit. Tried to install 8.4 and 9.0and it fails right near the end when it tries to create or read the conf file. If I transfer my postgres 8.4 file over the upgrade takes but the postgres service doesn't exist so no communication occurs. Is there anyway to just install the po

Re: [GENERAL] Weird problems with C extension and bytea as input type

On Tue, Mar 22, 2011 at 16:07, Merlin Moncure wrote: > On Tue, Mar 22, 2011 at 8:22 AM, Adrian Schreyer wrote: >> Hi, >> >> I have a weird problem with my custom functions (written in C,C++) >> that use bytea as input type (cstring works fine). The functions will >> work as expected if they are t

Re: [GENERAL] share directory on windows

Sorry, my fault, I copied the dictionary files to my local windows installation, but was connected to our linux installation. Connecting to the right server resolves the problem :) Viliam On 22.3.2011 16:03, Tom Lane wrote: =?UTF-8?B?VmlsaWFtIMSOdXJpbmE=?= writes: I wanted to install text se

Re: [GENERAL] Weird problems with C extension and bytea as input type

On Tue, Mar 22, 2011 at 16:07, Merlin Moncure wrote: > On Tue, Mar 22, 2011 at 8:22 AM, Adrian Schreyer wrote: >> Hi, >> >> I have a weird problem with my custom functions (written in C,C++) >> that use bytea as input type (cstring works fine). The functions will >> work as expected if they are t

Re: [GENERAL] postgres conferences missing videos?

On 03/22/11 12:29 PM, Susan Cassidy wrote: Personally, I vastly prefer written information to video. I can read far faster than someone can read/explain something to me. Plus, it is easier to refer back to. this++ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

Re: [GENERAL] postgres conferences missing videos?

Personally, I vastly prefer written information to video. I can read far faster than someone can read/explain something to me. Plus, it is easier to refer back to. Susan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.po

Re: [GENERAL] postgres conferences missing videos?

On Mon, 21 Mar 2011 19:21:46 -0500, Jon Nelson wrote: > ts all quite time consuming. > > Somebody ought to talk to the folks that run PyCon - the videos there > are excellent and typically available within hours or less. Perhaps > they have some useful insight or advice? > The problem is not

Re: [GENERAL] error messages during restore

Tom Lane wrote: Geoffrey Myers writes: So we are in the process of converting our databases from SQL_ASCII to UTF8. If a particular row won't import because of the encoding issue we get an error like: pg_restore: [archiver (db)] Error from TOC entry 5317; 0 1266711 TABLE DATA logs postgres

Re: [GENERAL] Weird problems with C extension and bytea as input type

On Tue, Mar 22, 2011 at 8:22 AM, Adrian Schreyer wrote: > Hi, > > I have a weird problem with my custom functions (written in C,C++) > that use bytea as input type (cstring works fine). The functions will > work as expected if they are the only function that uses the bytea > column in a query; as

Re: [GENERAL] share directory on windows

=?UTF-8?B?VmlsaWFtIMSOdXJpbmE=?= writes: > I wanted to install text search dictionaries on Windows 8.4 installation with > the following command: > CREATE TEXT SEARCH DICTIONARY skspell > (template=ispell, dictfile = slovak_utf8, afffile=slovak_utf8, > stopwords=slovak_utf8); > but got t

[GENERAL] Weird problems with C extension and bytea as input type

Hi, I have a weird problem with my custom functions (written in C,C++) that use bytea as input type (cstring works fine). The functions will work as expected if they are the only function that uses the bytea column in a query; as soon as there is a second function using the same column, the C func

Re: [GENERAL] Primary key vs unique index

Thanks for the help. I think we're only going to support pg 8.4 onwards. I'll turn off the application's manual vacuuming and just let autovac do its thing. -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Monday, March 21, 2011 9:13 PM To: Voils, Steven M

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 09:09:35PM +0100, Aljoša Mohorović wrote: > never said that it's not so just that i'm surprised/disappointed that > it's so low priority. If you are disappointed that something has been made a low priority by someone else, then perhaps you should consider making it a high

Re: [GENERAL] postgres conferences missing videos?

> On 03/21/11 5:04 PM, Tomas Vondra wrote: >> So just put there a tripod, a reasonable HD cam for $300 and you'll get >> a decent video of the session. >> > > you definitely want a sound patch from a lapel mic or the room PA, and > not be using on-camera sound. Yes, that's definitely true. We're u

[GENERAL] share directory on windows

Hello, I wanted to install text search dictionaries on Windows 8.4 installation with the following command: CREATE TEXT SEARCH DICTIONARY skspell (template=ispell, dictfile = slovak_utf8, afffile=slovak_utf8, stopwords=slovak_utf8); but got this error: ERROR: could not open dictionary fi

Re: [GENERAL] query taking much longer since Postgres 8.4 upgrade

On 22 Mar 2011, at 24:20, F. BROUARD / SQLpro wrote: > Try this : > > 1) rewrite your query as is : Indeed, a join is probably more efficient than a big IN-list. Good point ;) > > select course_id AS EXTERNAL_COURSE_KEY, > user_id AS EXTERNAL_PERSON_KEY, > 'Student' AS ROLE, >