[GENERAL] pg_operator corrupted... Any ideas?
Hi all: This is the third time I am writing to the list asking for help; the two first ones nobody bothered to answer (admittedly, they were questions answered in the documentation, but nobody even bothered to say "RTFM"), so let's see if this time I've got a bit more of luck... I have a database where the pg_operator table became corrupted. No matter what I do in it, it says cannot find attribute 8 of relation pg_operator. In other occasions, when one of the pg_* tables went bad, I tried to dig into it and fix it manually, but this time it's different because I can't even issue any SQL commands; no matter what I do, it gives me the same error. I have even tried to copy the pg_operator table from another database by hand, with no success. Any ideas? (BTW, I tried searching the mailing list archives at http://www.postgresql.org, and it said: "An error occured! connectDB() -- connect() failed: Operation timed out Is the postmaster running (with -i) at'pgsql.tht.net' and accepting connections on TCP/IP port '5432'?"). Paulo Jan. DDnet.
[GENERAL] Postgresql equivalent for nvl
Hi guys Sorry for hitting the button soon but whats the postgresql equivalent for Oracle's nvl(). I tried using ifnull() but then postgresql is cribbing that the function doesnt exist.. Thanx for the help Anand
RE: [GENERAL] entity-relationship diagram software
Try: http://www.htc.honeywell.com/DoME It is not strictly ERD but a VERY reasonable CASE with above other things Coad-Yourdon OOA that can be easily extended to ERD denotations. The best choice (because of licencing) is precompiled version. Regards, Andrzej Mazurkiewicz www.mazurkiewicz.org -Original Message- From: Robert B. Easter [SMTP:[EMAIL PROTECTED]] Sent: 8 maja 2000 05:28 To: [EMAIL PROTECTED] Subject: [GENERAL] entity-relationship diagram software Does anyone know of any good package for Linux for assisting with database design? I'd like to find a program that can be used to create/manipulate entity-relationship diagrams. It would be nice bonus if one could also output the postgresql sql schemas from it. -- Robert B. Easter [EMAIL PROTECTED]
RE: [GENERAL] entity-relationship diagram software
On Mon, 08 May 2000, Andrzej Mazurkiewicz wrote: Try: http://www.htc.honeywell.com/DoME It is not strictly ERD but a VERY reasonable CASE with above other things Coad-Yourdon OOA that can be easily extended to ERD denotations. The best choice (because of licencing) is precompiled version. I installed the binary. When I run it, it complains that it can't find splash.so: couldn't open splash.so: No such file or directory. The program Seg Faults a lot. Is there some installation step that maybe I have missed? I'm running Slackware 7.0.
[GENERAL] Recovering data from binary files?
Hi all: Well, after my earlier post regarding pg_operator being corrupted, I received a mail from one of the Postgres developers (I think) talking about one of the system indexes (pg_attribute_relid_attnum_index) being corrupted, so I gave it a try and copied said file from the template1 database to the one I have to recover... and now it gives me another error: "cannot find attribute 1 of relation pg_user". Like before, I can't even do a \d to see the existing tables in the database, much less insert/update anything in the pg_* tables to fix it, and after struggling the whole morning with it, I have pretty much given up on that path. I am trying now to: 1) Re-create the database in another machine. 2) Copy the binary files that contain the tables (minus the pg_* ones) to the other server, in the place where the new database has been created ($PGDATA/base/$dbname). 3) Try to access the tables from there using psql. The problem now is that, although I can view the tables correctly, they all come up as empty. All the SELECTs I try on them return nothing. And the strange thing is that pg_class.reltuples says that said table has 5478 tuples, which is correct. Any other ideas? Is there any other way to access the binary files and extract the information in them to text? My manager is starting to talk about migrating to SQL Server, and frankly, at this point I'm finding less and less arguments to counter him... Paulo Jan. DDnet.
RE: [GENERAL] Recovering data from binary files?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paulo Jan Sent: Tuesday, May 09, 2000 12:00 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [GENERAL] Recovering data from binary files? Hi all: Well, after my earlier post regarding pg_operator being corrupted, I received a mail from one of the Postgres developers (I think) talking about one of the system indexes (pg_attribute_relid_attnum_index) being corrupted, so I gave it a try and copied said file from the template1 database to the one I have to recover... and now it gives me another error: "cannot find attribute 1 of relation pg_user". Like before, I can't even do a \d to see the existing tables in the database, much less insert/update anything in the pg_* tables to fix it, and after struggling the whole morning with it, I have pretty much given up on that path. I am trying now to: 1) Re-create the database in another machine. 2) Copy the binary files that contain the tables (minus the pg_* ones) to the other server, in the place where the new database has been created ($PGDATA/base/$dbname). Oh it seems almost same as pg_upgrade. However you should probably copy pg_log and pg_variable to $PGDATA as pg_upgrade does. In addtion if postmaster is running,you should shutdown before processing 2). Regards. Hiroshi Inoue [EMAIL PROTECTED] 3) Try to access the tables from there using psql. The problem now is that, although I can view the tables correctly, they all come up as empty. All the SELECTs I try on them return nothing. And the strange thing is that pg_class.reltuples says that said table has 5478 tuples, which is correct. Any other ideas? Is there any other way to access the binary files and extract the information in them to text? My manager is starting to talk about migrating to SQL Server, and frankly, at this point I'm finding less and less arguments to counter him... Paulo Jan. DDnet.
[GENERAL] Miracle
Oh it seems almost same as pg_upgrade. However you should probably copy pg_log and pg_variable to $PGDATA as pg_upgrade does. In addtion if postmaster is running,you should shutdown before processing 2). Regards. Well. It worked!!! The database was succesfully recovered. Thanks a lot. Paulo Jan. DDnet.
[GENERAL] SSL
In the pgsql-hackers list, its been stated that SSL can be used on the client/backend connection. Where is this documented if I want to try it? Or, can anyone just tell me know? -- Robert B. Easter [EMAIL PROTECTED]
[GENERAL] NOTICE from vacuum
I am getting the following NOTICE from vacuum: NOTICE: Index tag_surveys_d_field_survey__key: NUMBER OF INDEX' TUPLES (6475) IS NOT THE SAME AS HEAP' (6474) How does such a thing come about? Do I just drop the index and remake it? Is the index or the heap correct? Thanks for your help. Cheers, Brook
