Re: [ADMIN] visualizing database schema - png/jpeg?

Schema Spy works for me. Bob Lunney --- On Wed, 5/18/11, neubyr wrote: > From: neubyr > Subject: [ADMIN] visualizing database schema - png/jpeg? > To: pgsql-admin@postgresql.org > Date: Wednesday, May 18, 2011, 3:09 PM > Anyone knows of tools that can > generate PNG/JPEG image from pgsql > dat

[ADMIN] remove .backup files from pg_xlog

Hello. I'm running 8.4 and with a backup procedure of pg_start_backup() copy base backup pg_stop_backup() The backup script failed and the pg_stop_backup command were killed so now the pg_xlog/ directory has some extra xx.backup files and in the archive_status/ directory I have the corre

[ADMIN] patching the OS of a 9.0.4 db with hot standby

I want to do OS patching on prod and hot standby. What is the advised procedure for maintenance on the two systems? I would think patching the standby should come first in case it blows something up. Oracle has a defer switch you can throw on prod to tell it to relax on log shipping to the standb

Re: [ADMIN] visualizing database schema - png/jpeg?

On Thu, May 19, 2011 at 5:01 AM, Bob Lunney wrote: > Schema Spy works for me. > > Bob Lunney > > --- On Wed, 5/18/11, neubyr wrote: > >> From: neubyr >> Subject: [ADMIN] visualizing database schema - png/jpeg? >> To: pgsql-admin@postgresql.org >> Date: Wednesday, May 18, 2011, 3:09 PM >> Anyone