No. Here it's the master pushing change to the slave, rather than the slave
pulling it (as you'd normally expect), hence the inner fragility of the
model. Moreover, replication is about having "exactly the same thing" in
two places, while this could be an audit log he keeps in its
historical comple
Isn't that basically what replication is supposed to do?
RobR, quite possibly revealing his ignorance about replication.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Thomaz Luiz Santos
Sent: Thursday, April 25, 2013 10:22 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] DBLink
hello! pgAdmins :D
I am trying to use the dblink in a trigger, however when the
hello! pgAdmins :D
I am trying to use the dblink in a trigger, however when the computer
(source) that is running the triggers are not accessible by ethernet to the
target computer, the dblink returns me an error and the trigger is not
executed as planned, it is terminated and input records in the
Thanks, I solved it with your help.
Francesco Boccacci
>Messaggio originale
>Da: m...@joeconway.com
>Data: 02/08/2011 22.46
>A: "francescobocca...@libero.it"
>Cc:
>Ogg: Re: [ADMIN] dblink question about duplicate connection
>
>On 08/02/2011 05:36 AM,
On 08/02/2011 05:36 AM, francescobocca...@libero.it wrote:
> Somentimes happend that an error accours in insert data and when i try to run
> new insert posgresql return and error like duplicate connection.
> I would like to change my functions in this way:
> If 'conn_test' exist PERFORM dbl
Dear all,
i have a question about dblink connection.I use it in a trigger function :
CREATE OR REPLACE FUNCTION setuser()
RETURNS trigger AS
$BODY$
DECLARE
BEGIN
IF (TG_OP = 'INSERT') THEN
PERFORM dblink_connect('conn_test', 'dbname=database_test');
PERFORM dblink_exec(
On Mon, Apr 24, 2006 at 10:18:47 -0400,
Manish Gupta <[EMAIL PROTECTED]> wrote:
> Hello Tom,
>
> I have filed a bug (# 189764) with fedoraproject.
>
> I tried with unix sockets with same results. So, for the time being
> disabling SELinux seems to be the only solution.
You are usually better
Hello Tom,
I have filed a bug (# 189764) with fedoraproject.
I tried with unix sockets with same results. So, for the time being
disabling SELinux seems to be the only solution.
Thanks for all the help.
Manish
"Manish Gupta" <[EMAIL PROTECTED]> writes:
> I was able to solve this issue by
"Manish Gupta" <[EMAIL PROTECTED]> writes:
> I was able to solve this issue by disabling SELinux.
> Still, there has got to be a way to use dblink with SELinux.
Please file a bugzilla entry at bugzilla.redhat.com against the
selinux-policy-targeted component (or whichever policy you're using)
(NOT
t; <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
Subject: [ADMIN] dblink not working in FC5
Date: Wed, 19 Apr 2006 18:26:48 -0400
Recently, I upgraded one of my server from FC4 to FC5. This also upgraded
postgresql to 8.1.3. The upgrade was flawless. Unfortunately, I cannot get
dblink
"Manish Gupta" <[EMAIL PROTECTED]> writes:
> bulbulbo=# select dblink_connect('hostaddr=127.0.0.1 dbname=bulbulfo
> user=bulbul password=password');
> ERROR: could not establish connection
> DETAIL: could not connect to server: Permission denied
>Is the server running on host "127.0.0.1"
Recently, I upgraded one of my server from FC4 to FC5. This also upgraded
postgresql to 8.1.3. The upgrade was flawless. Unfortunately, I cannot get
dblink to work in this version of postgresql. I created two fresh databases
and tried... still no luck. I keep getting the following error:
bulb
JinNet Picker wrote:
What i need is, when ever a NEW record is inserted in
'MyDb1' , i want fire a Trigger or Rule to insert the
Same Record to MyDb2 database.
Anybody Got Idea how to do this?
See the dblink documentation for dblink_exec(), and see the Postgres
documentation for how to create tr
Hi,
I have Two databases names 'MyDb1' and 'MyDb2' in My
System.
I have installed Postgres 7.4 with dblink
What i need is, when ever a NEW record is inserted in
'MyDb1' , i want fire a Trigger or Rule to insert the
Same Record to MyDb2 database.
I am Using MAC OS 10.2
Anybody Got Idea how to d
15 matches
Mail list logo
