[ADMIN] 100% failover + replication solution

ossible to apply WAL logs to the slaves continously as soon as they are created on MASTER. I checked other tools available and thougth this would be best approach if it works. Awaiting reply soon.Regards,Moiz Kothari <> ---(end of broadcast)

Re: [ADMIN] 100% failover + replication solution

Shoaib,It sure does, i saw PGCLUSTER, but 3 reasons for having a postgres specific solution.1) If pgcluster stops further development, it would be lot more hassel when upgrading to a different version of postgres. 2) Postgres specific solution would help alot going ahead in future. 3) Also architec

Re: [ADMIN] 100% failover + replication solution

Hi Oliver,I din't quite understand that.. Do you mean have application populate data across to all the DB machines?Can you elaborate on that please...Regards,Moiz Kothari On 10/30/06, Mensinger, Oliver <[EMAIL PROTECTED]> wrote: Moiz,it depends on your application (must use JDBC), but y

Re: [ADMIN] 100% failover + replication solution

M FULL process as a maintanence activity. Thanks,-Shoaib MirEnterpriseDB (www.enterprisedb.com) On 10/30/06, Moiz Kothari < [EMAIL PROTECTED]> wrote: Shoaib, It sure does, i saw PGCLUSTER, but 3 reasons for having a postgres specific solution.1) If pgcluster stops further development, it

Re: [ADMIN] 100% failover + replication solution

wrote: Hi Moiz,This might help you :) --> http://developer.postgresql.org/pgdocs/postgres/warm-standby.html Thanks,---Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 10/30/06, Andrew Sullivan < [EMAIL PROTECTED]> wrote:On Mon, Oct 30, 2006 at 06:41:54PM +0530, Moiz Kothari wrote:

Re: [ADMIN] 100% failover + replication solution

Shoaib,I see you are with enterprise DB, does enterpriseDB support clustering? if it does then probably i can think in terms of it to be an option to go for.I need to come to a decision soon on it as we have to decide on what Database to go for. Thanks for all your help.Regards,Moiz Kothari On 10

Re: [ADMIN] 100% failover + replication solution

und in the PostgreSQL /bin folder.Thank you,-Shoaib Mir EnterpriseDB ( www.enterprisedb.com)On 10/31/06, Moiz Kothari < [EMAIL PROTECTED]> wrote: Shoaib,This sounds really like what i need, but again 8.2 is in beta. Just one question, i dunno if i am thinking in right direction,

[ADMIN] Script for hotbackup

with me.Regards,Moiz Kothari

Re: [ADMIN] Script for hotbackup

Hi Jeff,This is what i really wanted, thanks for replying back so quick... I wanted to automate the PITR backup, so that we have DB backup for a PITR.Thanks a tons.Regards,Moiz Kothari On 11/8/06, Jeff Frost <[EMAIL PROTECTED]> wrote: On Wed, 8 Nov 2006, Moiz Kothari wrote:> Guys,&

Re: [ADMIN] Where are DB's?

Hi Francisco,       In linux when you install postgres, it is mainly stored in "/usr/local/pgsql/" . And the "data" directory inside this contains data.   Regards MoizFrancisco Jose Bernabe Pellicer <[EMAIL PROTECTED]> wrote: What folder in Linux is used to store Postgres Databases?Cheers,-- __

[ADMIN] Question on Fragmentations

Hi All, What are the reasons of data getting fragmented in postgres? Do we have any page which explains different scenarios of data getting fragmented? Regards, Moiz Kothari

Re: [ADMIN] when inserting to table, text type parameter become NULL (after big assignment to this parameter)

It worked fine for me too. Regards, Moiz Kothari On 10/16/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "Sofer, Yuval" <[EMAIL PROTECTED]> writes: > > I am trying to get server parameters (pg_settings) using a cursor and > > insert them to one column table.

Re: [ADMIN] Is there a way to kill a connection from the pg_stat_activitly list?

Hi, Please do not use kill, it sometimes resets all the connection on your db, you might want to use pkill -f to kill the connection you want to. Regards, Moiz Kothari On 10/16/07, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > > On 10/16/07, Jessica Richard <[EMAIL PR