Re: [ADMIN] Replication solution

2009-11-19 Thread Palaniappan Thiyagarajan
Thanks for the information. From: Julio Leyva [mailto:jcle...@hotmail.com] Sent: Thursday, November 19, 2009 10:53 AM To: kevin.gritt...@wicourts.gov; Palaniappan Thiyagarajan; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Replication solution check this http://symmetricds.codehaus.org/ I jus

Re: [ADMIN] Just wanted to say thanks for a great tool

2009-11-19 Thread Brian Modra
I also would like to thank the PostgreSQL developers. I've been using it for the last 3 years as the database for a vehicle tracking system. It never fails, its easy to use, and its efficient. I'm also using it for my open source project "The Karoo Project" as the database. Brian 2009/11/19 Campbe

Re: [ADMIN] Practice of backups

2009-11-19 Thread Michael Graziano
On Nov 19, 2009, at 1:58 PM, Jesper Krogh wrote: Michael Graziano wrote: None that I know of from within the database environment, but you can grab a copy of the data directory off the filesystem. Note that this requires stopping the DB server though, as a backup grabbed while the DB is ru

[ADMIN] Just wanted to say thanks for a great tool

2009-11-19 Thread Campbell, Lance
My department at the University of Illinois has been using PostgreSQL for seven years. We generate around 2 to 4 million pages of dynamic web content each month through a single PostgreSQL database. Two weeks ago we upgraded from PostgreSQL 8.2 to 8.4. It is running great. As a software archite

Re: [ADMIN] Can i write a time-trigger?

2009-11-19 Thread Guillaume Lelarge
Le jeudi 19 novembre 2009 à 07:01:57, Shruthi A a écrit : > Wow! Thanks a lot! That was a great deal of help! :-) > > On Wed, Nov 18, 2009 at 8:41 PM, Jure Kobal wrote: > > > -- While running the pgagent daemon, what dbname should i specify? Is > > > it postgres or pgadmin (as the example in >

Re: [ADMIN] Replication solution

2009-11-19 Thread Devrim GÜNDÜZ
On Thu, 2009-11-19 at 18:25 +, Palaniappan Thiyagarajan wrote: > > I am looking for Postgres replication solution for 8.3.x DB. > > Any open source software available for replication? http://wiki.postgresql.org/wiki/Replication%2C_Clustering% 2C_and_Connection_Pooling > Anybody has good st

Re: [ADMIN] Practice of backups

2009-11-19 Thread Jesper Krogh
Michael Graziano wrote: > On Nov 18, 2009, at 2:45 AM, Julius Tuskenis wrote: > >> The question is what user should do backups. Is it good practice to >> use superuser for that? > > If you're doing your backup with pg_dump (on an individual DB) you need > a DB user who has read access to everythi

Re: [ADMIN] Replication solution

2009-11-19 Thread Joshua D. Drake
On Thu, 2009-11-19 at 18:53 +, Julio Leyva wrote: > check this > http://symmetricds.codehaus.org/ > > I just began playing with that one > > > > Date: Thu, 19 Nov 2009 12:39:04 -0600 > > From: kevin.gritt...@wicourts.gov > > To: pthiyagara...@cashedge.com; pgsql-admin@postgresql.org > > Sub

Re: [ADMIN] Replication solution

2009-11-19 Thread Julio Leyva
check this http://symmetricds.codehaus.org/ I just began playing with that one > Date: Thu, 19 Nov 2009 12:39:04 -0600 > From: kevin.gritt...@wicourts.gov > To: pthiyagara...@cashedge.com; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Replication solution > > Palaniappan Thiyagarajan wro

Re: [ADMIN] Replication solution

2009-11-19 Thread Kevin Grittner
Palaniappan Thiyagarajan wrote: > I am looking for Postgres replication solution for 8.3.x DB. > > Any open source software available for replication? > > Anybody has good step by step doc for warm standby setup? > > Any other suggestion to achieve replication is appreciated. You might wan

[ADMIN] Replication solution

2009-11-19 Thread Palaniappan Thiyagarajan
Friends, I am looking for Postgres replication solution for 8.3.x DB. Any open source software available for replication? Anybody has good step by step doc for warm standby setup? Any other suggestion to achieve replication is appreciated. Thanks Palani -- Sent via pgsql-admin mailing list

Re: [ADMIN] Practice of backups

2009-11-19 Thread Michael Graziano
On Nov 18, 2009, at 2:45 AM, Julius Tuskenis wrote: The question is what user should do backups. Is it good practice to use superuser for that? If you're doing your backup with pg_dump (on an individual DB) you need a DB user who has read access to everything in that DB. If you're doing you