Trigger Function and backup

Hello every one,

I am new to databases. I am using Postgres 8.2 (Migrating to 8.3.7 in few days) on windows platform.

I had tried using Slony-I for replication and was not able to create a cluster.

After struggling for some time i decide to implement a way around to take differential backup. As the tables getting changed were very less.

Here is what i intend to do:

- Write a trigger for each of the tables in concern
- Some how write a function which can copy / execute the same query in another temp Db on the same physical system (I have no idea how to do that)
- Take a backup of temp DB which will be the differential backup of DB (We need to clear temp db after backup)

Am i going in the right direction?
Is there any way i can implement it.
Any help will be really of great help

Regards
Nishkarsh

I'd rather fix my Slony, see http://pgsnake.blogspot.com/2007/09/setting-up-slony-i-with-pgadmin.html
and http://developer.pgadmin.org/~hiroshi/Slony-I/ and http://www.hagander.net/talks/Slony%20on%20Windows.pdf

Hi pabloj,

I think i will need some help to do it.

I am using Postgres 8.3.7, on Windows.

I was following the Slony-I example in the help for pgAdmin III (it is exactly same as one in the link you sent). I am able to perform the steps from 1-7. Step 8 : create Slony-I cluster i am getting a msg in the interface

"Slony-I creation script no available; only join possible"

On doing some research i found some scripts to be copied (I was not able to find very clear instruction) or give slony-I path. i tried all that but was not able to move ahead.

Can u plz guide me through

Regards
Nishkarsh

Google knows, see
http://archives.postgresql.org/pgad...11/msg00072.php but I agree that it should be better documented

Hi Pabloj,

I had already tried using some things i found on line they did not worked.

I am having a windows XP System and there is no win32 folder..

I tried by copying the file to system32, windows, program files and c:\, it did not worked

I found another input on line that give the Slony-I path in pgAdmin III options. Tried that also. Did not work

Any other idea?

Regards
Nishkarsh

Set the slony path in PgAdmin (File-> Options) and put sql files there (see here )

Hi pabloj,

i had copied the the sql from share folder to share folder in in 8.3 directory. Also give the path in File-> Options. Is there any thing wrong i am doing??

Is there any help/tutorial for windows available any where...

Regards
Nishkarsh

Hi Nishkarsh,

i also have same error when create the Slony-I cluster, please give me what is the solution.

"Slony-I creation scripts not available; only joining possible"


I fallowed some solutions like

 Xxid.sql, slony1_funcs.sql, slony1_base.sql file copy and rename as a Xxid.v84.sql, slony1_funcs.v84.sql, slony1_base.v84.sql

 All this script copy in to C:\WINDOWS\system32 folder


 In pgadmin option’s specified correct patch like “C:\Program Files\PostgreSQL\8.4\share”

But the problem persists.

Could you help me?
Are there any solution?

Thanks in advance for your support