Re: [HACKERS] Database file copy

2011-01-14 Thread Srini Raghavan
continue to use the existing vacuum freeze syntax? I did try it and it works. Thank you, Srini   From: Robert Haas To: Tom Lane Cc: Kevin Grittner ; Alvaro Herrera ; Bruce Momjian ; pgsql-hackers ; Srini Raghavan Sent: Fri, January 14, 2011 3:36:02 PM Subject

Re: [HACKERS] Database file copy

2010-12-23 Thread Srini Raghavan
Thank you, that is a great point.   Based on your suggesstion, I wrote the following query:   select * from pg_class where relisshared=true order by relname   The above query returns 27 rows. I evaluated the impact on the following:   pg_auth_members - We create roles and memberships on each deplo

Re: [HACKERS] Database file copy

2010-12-23 Thread Srini Raghavan
Thank you very much for reviewing, appreciate the feedback.  As pointed out by you, it is always best to test it out with the latest version, so, I tested the same approach with postgres 9.0.2 on windows just now, and it works! I forgot to mention earlier that in addition to setting vacuum_fre

[HACKERS] Database file copy

2010-12-22 Thread Srini Raghavan
Hello, [Tried the general forum, didn't hear from anyone so far, trying this forum now, please review, thanks] We are looking to distribute postgres databases to our customers along with our application. We are currently evaluating postgres version 8.4.4. The database can be of size 25 gb (c