Re: [ADMIN] Mixing DBLink versions

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

Re: [ADMIN] Mixing DBLink versions

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

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] Autovac vs manual with analyze

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

[ADMIN] Mixing DBLink versions

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

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

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

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

"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] Autovac vs manual with analyze

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

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

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 versus manual vac with analyze

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] pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

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

Re: [ADMIN] Autovac vs manual with analyze

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] 8.4.2 One Click Installer

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] Off-site storage for PITR logs

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

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

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