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
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
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
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
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