Re: [GENERAL] Trigger Function and backup
hello Arndt, Thanks for the input. I was successfully able to implement rubyrep, on a windows system (I used windows 7). Is there any way i can implement Master Slave replication by rubyrep. Regards Nishkarsh Arndt Lehmann-2 wrote: Hi Merlin, you could also consider giving rubyrep a try. Like Slony it is also an open source, trigger based, asynchronous replication solution. Focus of rubyrep is easy setup. Tutorial, screencast and other information are available on the project website: http://www.rubyrep.org Best Regards, Arndt Lehmann (Disclosure: I wrote rubyrep) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- View this message in context: http://www.nabble.com/Trigger-Function-and-backup-tp24030638p24217919.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Issue with WAL recovery in windows
Hello every one, I am running Postgres 8.2 on Windows. I was trying to use WAL for archive and recovery. I followed the instructions giving in following link. http://www.mkyong.com/database/postgresql-point-in-time-recovery-incremental-backup/ http://www.mkyong.com/database/postgresql-point-in-time-recovery-incremental-backup/ I am able to archive WAL. When i reverted back to the older copy of data directory, i was able to start the service but on opening pgAdmin III it is telling that the Server doesn't listen... any idea what has gone wrong? I had checked that the service is running regards Nishkarsh -- View this message in context: http://www.nabble.com/Issue-with-WAL-recovery-in-windows-tp24106493p24106493.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Trigger Function and backup
Hi Merlin, thanks for the detailed input. As per ur suggestion i will try to implement Slony-I. I think i will need some help to do it. I am useing Postgres 8.3.7, on Windows. I was following the Slony-I example in the help for pgAdmin III. 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 Merlin Moncure-2 wrote: On Mon, Jun 15, 2009 at 4:29 AM, Nishkarshnishkars...@rediffmail.com wrote: 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 Generating a full trigger based replication system on your own is IMNSHO crazy. Slony is the best solution to this problem (trigger replication with postgres) that I know of, and is probably better than any one person to come up with in a reasonable amount of time. Probably, your best course of action if you need to get things running right now is to give slony another go (why did you not succeed?). Hand written trigger replication is ok if you need to copy, say, a couple of tables or you have some other very specific requirement. In particular, copying an insert to a mirror database with trigger function wrapping dblink is a snap (updates are more problematic, but doable). Of course, you need to figure out how to deal with schema updates and other issues that plague replication systems such as volatile data in cascading triggers (just to name one). General purpose trigger replication is a huge project... It sounds to me that what you really want is the 'hot standby' feature that unfortunately missed the cut for 8.4. Hot standby is probably the easiest way to mirror a database for purposes of read only querying. There are no triggers to worry about, just a few .conf settings and some other setup to get going (more or less, it isn't finalized yet). So maybe, waiting for hot standby (or even, digging up a hot standby patch and trying to apply it vs. 8.4 if your adventurous) is the answer. Another possibility is to look at statement level replication, like pgpool. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- View this message in context: http://www.nabble.com/Trigger-Function-and-backup-tp24030638p24051851.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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%-| -- View this message in context: http://www.nabble.com/Trigger-Function-and-backup-tp24030638p24030638.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Behavior of NpgsqlDataReader in NpgSql 1 and NpgSql 2
Hello every one, I have a Vb 2005 application with postgres 8.2 as DB. I was trying to move from Pg 8.2 to 8.3.7, the installation went well. Once i tried running my application i got some errors. After doing some research i realized that. - NpgsqlDataReader in NpgSql 1 was capable to retain the records even eve after the connection is closed but it is not happening with NpgSql 2 After doing a bit of googleing i was not able to find any info on it. Can any one plz tel me that is it the case or i have to do some modification in the code. If that is the case then is there any other object which can be used the way i was using NpgsqlDataReader in NpgSql 1 Regards Nishkarsh -- View this message in context: http://www.nabble.com/Behavior-of-NpgsqlDataReader-in-NpgSql-1-and-NpgSql-2-tp23995183p23995183.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general