Re: [GENERAL] Re: [HACKERS] You're on SecurityFocus.com forthe cleartext passwords.
Stephan Richter wrote: > > At 07:08 PM 5/7/00 -0400, Robert B. Easter wrote: > >My understanding is that what you get from crypt(pw, salt) = > > > > $1$$ That's for DES crypt (and without the $$) - Hannu
[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
[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] 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.
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] 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] 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.
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]
[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
[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.