[ADMIN] Public key for wxBase-2.8.12-1.el5.i386.rpm is not installed for pg_admin3

2012-10-30 Thread jkells
I am trying to install pgadmin3_91.i386 0:1.16.0-1.rhel5 on a centos 5.7 Currently installed license keys are: RPM-GPG-KEY-beta RPM-GPG-KEY-EPEL RPM-GPG-KEY-PGDG RPM-GPG-KEY-CentOS-5 RPM-GPG-KEY-linux-ink RPM-GPG-KEY-PGDG-91 Postgresql version installed is 9.1, not the default 8.4

[ADMIN] Meta data information on tables

2012-01-20 Thread jkells
I am running PostgreSQL 8.4.7 (64 bit) on a Ubuntu 10.10 64 bit system. I am trying to generate a report listing all our tables, their column attributes (type, constraints etc.) and comments (if any) for each of them. I'm having a hard time finding this in the catalog areas. I can find some

Re: [ADMIN] bad block problem

2011-12-08 Thread jkells
On Thu, 08 Dec 2011 09:02:15 +0800, Craig Ringer wrote: On 12/08/2011 08:20 AM, Walter Hurry wrote: On Wed, 07 Dec 2011 22:20:30 +, jkells wrote: I am relying on identifying and correcting a bad block. Well, good luck with that. Most of the time you can't. Just check your disk, replace

[ADMIN] bad block problem

2011-12-07 Thread jkells
It appears that I have a bad block/disk sector etc., which is preventing me from retrieving the rows from this table. All other tables within this database is fine. In preparation for zeroing out the bad block I tried to do a cold backup/ copy cp -r * ../data2/ and received the following

Re: [ADMIN] bad block problem

2011-12-07 Thread jkells
On Wed, 07 Dec 2011 22:09:23 +, Walter Hurry wrote: On Wed, 07 Dec 2011 21:22:05 +, jkells wrote: I do not have a recent backup of this database/table Any help would be appreciated. Here's some help: Next time you establish a database, set up and test the backup regime. We