Re: [PERFORM] How to use a trigger to write rows to a remote server

Lane <[EMAIL PROTECTED]> wrote: "Michael Dengler" <[EMAIL PROTECTED]> writes: > I am trying to find out how to use a trigger function on a table to copy any > inserted row to a remote PG server. > ... > This is not replication, I'm not interested in a full blo

[PERFORM] How to use a trigger to write rows to a remote server

Hi All, I am trying to find out how to use a trigger function on a table to copy any inserted row to a remote PG server. ie: Row X is inserted into TableX in DB1 on server1TableX trigger function fires and contacts DB2 on server2 and inserts the row into TableY on server2. I've looked arou

Re: [PERFORM] WAL shipping and ever expanding pg_xlog

Doug Knight just informed me about the pg_standby module. Works like a charm! Thanks Mike On 6/13/07, Merlin Moncure <[EMAIL PROTECTED]> wrote: On 6/13/07, Michael Dengler <[EMAIL PROTECTED]> wrote: > OKit looks like the slave machine has run out of space and that ca

Re: [PERFORM] WAL shipping and ever expanding pg_xlog

machine has restored the particular segment? Thanks Mike On 6/13/07, Michael Dengler <[EMAIL PROTECTED]> wrote: Hi, I'm doing WAL shipping to do a warm standby system (8.2.4). The problem is that the pg_xlog dir on the master just gets bigger and bigger (never seems to trunca

[PERFORM] WAL shipping and ever expanding pg_xlog

Hi, I'm doing WAL shipping to do a warm standby system (8.2.4). The problem is that the pg_xlog dir on the master just gets bigger and bigger (never seems to truncate) and the corresponding archive directory on the slave also gets bigger and bigger. Is there a way to moderate this? Thanks Mike

Re: [PERFORM] how to output column names

Perfect! thanks for the help!. Mike On 4/19/07, Jon Sime <[EMAIL PROTECTED]> wrote: Michael Dengler wrote: > Hi, > > Is there a query I can perform (perhaps on a system table) to return all > of the column names (ONLY the column names) for a given DB? (I seem to > remem

[PERFORM] how to output column names

Hi, Is there a query I can perform (perhaps on a system table) to return all of the column names (ONLY the column names) for a given DB? (I seem to remember doing this before but cant remember how) Thanks Mike

Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3

L PROTECTED] *On Behalf Of *Michael Dengler *Sent:* Wednesday, April 11, 2007 12:25 PM *To:* Devrim GÜNDÜZ *Cc:* pgsql-performance; Guillaume Smet *Subject:* Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3 Hi, Thanks for the info. One more thingI am in rpm hell. When I try to # rpm -Uvh

Re: [PERFORM] Do I need to rebuild php-pgsql for 8.2.3

Hi, Thanks for the info. One more thingI am in rpm hell. When I try to # rpm -Uvh postgresql-libs-8.2.3-1PGDG.i686.rpm I get: error: Failed dependencies: libpq.so.3 is needed by (installed) perl-DBD-Pg-1.31-6.i386 libpq.so.3 is needed by (installed) postgresql-python-7.4.13-2.RH

[PERFORM] Do I need to rebuild php-pgsql for 8.2.3

Hi, I'm using RHEL4 and wondering if I need to upgrade the php and php-pgsql packages when upgrading from Postgres 7.4.1 to 8.2.3. Any Help? Thanks Mike

[PERFORM] What do the adminpack functions do? (8.2.3)

Hi, Ive looked through the README in the contrib/adminpack dir but it doesn't really say what these functions do and how to use them Any help? Thanks miguel

[PERFORM] How to enable jdbc???

Hi, In postgres 7.4.* I had to pass --with-java to the configure script for jdbc support. Does postgres 8.2* include it by default? If not, how do I enable it? Thanks Miguel ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?