Re: [ADMIN] Off-site storage for PITR logs

2010-03-15 Thread Nicos Panayides
Hi Simon, thanks for the suggestion. What kind of space savings should I expected from turning off full_page_writes? The servers have battery-backed write-caches for the disk controllers, so it should be safe to give this a try. Does turning off full_page_writes have any other effect on the da

Re: [ADMIN] Off-site storage for PITR logs

2010-03-15 Thread Simon Riggs
On Mon, 2010-03-15 at 11:27 +0200, Nicos Panayides wrote: > thanks for the suggestion. What kind of space savings should I expected > from turning off full_page_writes? Substantial, though you should measure it and see, since it is workload dependent. -- Simon Riggs www.2ndQuadrant

[ADMIN] 8.4.2 One Click Installer

2010-03-15 Thread Arnold, Sandra
I need to get a copy of the 8.4.2 Linux 64 bit One Click Installer instead of 8.4.3. The plan is to install the 8.4.2 and then test our Patching procedures when upgrading to 8.4.3. Thanks, Sandra Arnold Sr. Database Admin DOE/OSTI

Re: [ADMIN] Autovac vs manual with analyze

2010-03-15 Thread Scott Whitney
I've got about 44GB of data in a few hundred production databases. I'm using PG 8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I know. I wish it were, and it's slated here for q2, but I cannot even apply maintenance patches without a full testing cycle. My aut

[ADMIN] pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

2010-03-15 Thread Matt Janssen
When migrating our Postgres databases from 32 to 64-bit systems, including large binary objects, how well will this work? 32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb 64-bit server) pg_restore -d mydb backup.pg I'm hoping that PG's compressed custom archive format is

[ADMIN] Autovac versus manual vac with analyze

2010-03-15 Thread Scott Whitney
I've got about 44GB of data in a few hundred production databases. I'm using PG 8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I know. I wish it were, and it's slated here for q2, but I cannot even apply maintenance patches without a full testing cycle. My auto-v

[ADMIN] how to get notification in front end application when ever postgre DB table is modified, any tool, jar, api available?

2010-03-15 Thread seetharaman jayaraman
how to get notification in front end application when ever postgre DB table is modified, any tool, jar, api available? thanks & regards seetharaman. j

[ADMIN] Autovac vs manual with analyze

2010-03-15 Thread Scott Whitney
I've got about 44GB of data in a few hundred production databases. I'm using PG 8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I know. I wish it were, and it's slated here for q2, but I cannot even apply maintenance patches without a full testing cycle. My auto

Re: [ADMIN] pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

2010-03-15 Thread Tom Lane
"Matt Janssen" writes: > When migrating our Postgres databases from 32 to 64-bit systems, including > large binary objects, how well will this work? > 32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb > 64-bit server) pg_restore -d mydb backup.pg Should be fine; but remember that o

[ADMIN] Re: how to get notification in front end application when ever postgre DB table is modified, any tool, jar, api available?

2010-03-15 Thread Thomas Kellerer
seetharaman jayaraman wrote on 15.03.2010 10:13: how to get notification in front end application when ever postgre DB table is modified, any tool, jar, api available? thanks & regards seetharaman. j Have a look at listen/nofify http://www.postgresql.org/docs/current/static/sql-listen.html Th

[ADMIN] Mixing DBLink versions

2010-03-15 Thread David Jantzen
Hi All, Due to some historical idiosyncracies in our environment, we have a custom 8.3.7 database installation built from source. We'd like to install dblink into this, however there are some problems with doing so: 1) the 8.3.7 database was built on a CentOS 4 build box that has since gone aw

Re: [ADMIN] Autovac vs manual with analyze

2010-03-15 Thread Alvaro Herrera
Scott Whitney wrote: > So, my questions are: > > a) Is the manual vacuum needed for performance reasons, or is auto-vac > sufficient? > b) How do my settings look? > c) Is there a way that the clogs get cleared via autovac, would a full vac of > just template1/template0 (if that last is poss

Re: [ADMIN] Mixing DBLink versions

2010-03-15 Thread Tom Lane
David Jantzen writes: > Due to some historical idiosyncracies in our environment, we have a custom > 8.3.7 database installation built from source. We'd like to install dblink > into this, however there are some problems with doing so: > 1) the 8.3.7 database was built on a CentOS 4 build box

Re: [ADMIN] Mixing DBLink versions

2010-03-15 Thread David Jantzen
Thanks for the detailed response. We'll look at upgrading to 8.3.9 from an RPM. On Mar 15, 2010, at 6:01 PM, Tom Lane wrote: > David Jantzen writes: >> Due to some historical idiosyncracies in our environment, we have a custom >> 8.3.7 database installation built from source. We'd like to ins

Re: [ADMIN] Mixing DBLink versions

2010-03-15 Thread Devrim GÜNDÜZ
On Mon, 2010-03-15 at 19:25 -0700, David Jantzen wrote: > We'll look at upgrading to 8.3.9 from an RPM. FWIW 8.3.10 was released today. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, d