From: | James Hall <James(dot)Hall(at)RadioShack(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | RE: Postgres not finding tables |
Date: | 2000-11-03 16:54:05 |
Message-ID: | DD6FD0C9668DD311AA040008C7566E8A0480E3D5@ntmailc.tandy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the advice, but no luck. I tried dumping and restoring each
database, when that didn't work I tried dumping and restoring the entire
database and still the same results... any other thoughts (please!)?
-Jim
James> Hello All, I have 2 identical machines running redhat 5.2 and
James> postgres 6.5. One machine is a replica of the other
(backup).
James> Recently I noticed that postgres gives the error:
"Couldn't find
James> any tables, sequences or indices!"
James> whenever I tried '\d' or '\d*' on one of the
machines. BUT the
James> database DOES contain tables because I can execute
'select * from
James> testtable;' and postgres will display the table info.
James> The tables are there, but for some reason postgres
can't see them
James> correctly.
James> Has anyone seen this before, if so any help is
greatly appreciated!
>I have seen this where I copied the files in
>/var/lib/pgsql/data/base/mydb to
>another machine. If you use pg_dump/psql -e to move the data
>it works. Both
>my machines are running RH6.2, but I think one was PG 7.0 and
>the other was
>7.0.2.
From | Date | Subject | |
---|---|---|---|
Next Message | mgainty | 2000-11-03 16:58:05 | Re: young guy wanting (Postgres DBA) ammo |
Previous Message | Isaac | 2000-11-03 16:09:15 | structuring database for multilingual content |