Hi there,
what options do exist to replicate from a master by schema?
What I'm really after is this scenario:
Say, I have 100 databases out in the field. All of them have the same schema
and are autonomous masters. Now, at a central location, I want to replicate
from all masters to a central sla
In a bourne-type shell you could use:
$ nohup [your_cmd] >[your_log_file] 2>&1 &
Then you should be able to safely disconnect your terminal.
Cheers,
-ar
On Thu, Sep 29, 2011 at 11:08 AM, bricklen wrote:
> On Wed, Sep 28, 2011 at 12:54 PM, Robert Burgholzer
> wrote:
> > If anyone has any sugg
Hi all,
I am running custom applications on a Linux platform which essentially have
Perl and Postgres as prerequisites. In the past, we used an arcane Linux
distro which left me with no other option than to build Perl + 50 odd CPAN
modules + Postgres myself. I prefixed the stack under a common pat
Thx, Tom. OpenSUSE's most recent postgres 9.1 is 9.1.6. Yet, 9.1.1 is what
was part of the opensuse12.1 snapshot of RPMs on top of which some of our
engineers develop proprietary apps. It worked well for them to freeze an
RPM repo because it can happen (and did happen!) that upgrading an
individual
CST - - 50ef37b5.3b1: WARNING: invalid value for
parameter "search_path": "beverlyhills, public"
2013-01-10 15:50:45.125 CST - - 50ef37b5.3b1: DETAIL: schema
"beverlyhills" does not exist
...
-ar
On Wed, Jan 9, 2013 at 3:59 PM, Kevin Grittner wrote:
> Armi
Not sure this is the right list to vent about this but here you go:
I) select regexp_replace('BEFORE.AFTER','(.*)\..*','\1','g') "Substring"
II) select regexp_replace('BEFORE.AFTER','(.*)\\..*','\\1','g') "Substring"
Executing (II) against pg 8.4.4 or 9.0.4 yields 'BEFORE', but in order for
9.1.7
Thx for clarification, Craig. Your Perl snippet comes in handy, too.
-ar
On Apr 10, 2013, at 8:08 PM, Craig James wrote:
> On Wed, Apr 10, 2013 at 4:59 PM, Armin Resch wrote:
>> Not sure this is the right list to vent about this but here you go:
>>
>> I) select regexp_
ure ...
-ar
On Fri, Apr 12, 2013 at 5:16 AM, Albe Laurenz wrote:
> Armin Resch wrote:
> > Not sure this is the right list to vent about this but here you go:
> >
> > I) select regexp_replace('BEFORE.AFTER','(.*)\..*','\1','g') "Su
