[GENERAL] Connecting to Postgres using Rekall
I'm using 9.3 and postgresql-8.0.1-6. I started Rekall which opens the database connection wizard. As the RDBMsS Server Type I pick the only one available:the Rekal PgSQL Driver (Shouldn't there be drivers for other DB's in the type list also?) The comment from the Rekal PgSQL driver dialog: 'This driver connects to PostgrSQL databases (version 7.x).' Is this a typo? This version is postgresql-8.0.1-6. When I use the Yast 'Edit an existing system user module' to change the password for the user postgres it's not permanent. It defaults back to some unknown six character password. Does Anyone know what it is? When I try to connect to the PostgreSQL server I get this message:FATAL: Ident authentication failed for user "postgres". Anyone know why this is happening? Thanks, Jerome ps I understand that Rekall doesn't create databases. I don't understand why it should be so difficult to use Rekall to open a postgresql database and just start using it. I tried to use Rekall and PostgreSQl in 9.1,9.2 and 9.3. In the process I've spoken to people on the Rekall mailing list and the PostgreSQL list and the Suse list. I did make some progress setting this up in 9.2 but it never worked quite right. I got the database in OpenOffice going in minutes and in a half hour I had created 8 tables (from templets). Why is that so easy and this so hard? I read the help document but it doesn't talk about what to do if things aren't working; it only talks about what to do if things are working. Why doesn't Yast change the password for postgresql to what I want it to be? Why does the user postgres have a default password anyway? Why is it so hard to find out what that password is? Why should I have to authenticate myself on a pristine setup? I'm the first one to use it, why am I locked out from the very beginning?? Why is all this apparently acceptable to the people who use this software productively? What am I missing? I really would like to be able to use Rekall and PostgreSQL but for me it's like being at sea searching for a hidden channel into a safe harbor. It all looks like shoreline to me. Please excuse my frustration and thanks for listening. I tried to resist but after a few hours of getting absolutely nowhere it's very difficult. Jerome ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] SPAM: Re: [SLE] SPAM: AMD Dual core "clock speed"
On Sunday 15 October 2006 10:57, Susemail wrote: > On Saturday 14 October 2006 07:19, Anders Johansson wrote: > > On Thu, 2006-10-12 at 18:28 -1000, Susemail wrote: > > > With respect to the AMD Athlon(tm) 64 X2 Dual Core Processor 4800+ are > > > they taking two cpu's (cores) running at 1 Ghz - summing their clock > > > speeds and calling it a 2.4 Ghz processor? > > > > No, your processors are running in "dynamic" mode, which means they > > adapt their frequency to how you use the system. If you run something > > CPU intensive, they will (or should) go to max speed. > > > > If you want them running at max speed always, set this in YaST's > > powersave module (change from Dynamic to Performance I think it's > > called) > > It is called Performance. I had set it to that some months ago when I > bought the machine. I'm going to load the linux_frequency_driver-1.60.01 > now from AMD to see if that helps. > > Jerome > > > On the command line you can use "powersave -f", to make a temporary > > change to max CPU power This worked: Clock: 2411 MHz. My current kernel (linux-2.6.13-15.12) comes with cpu-freq documentation so I assume the driver is already loaded. Now on to the Nvidia driver. Thanks, Jerome ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] [SLE] Can't boot boot iso
On Saturday 28 October 2006 07:11, pelibali wrote: > Hi, > > On Sat, 28 Oct 2006 00:33:26 -1000 > > Susemail <.> wrote: > > I reboot my laptop with openSUSE-10.2-Beta1-i386-mini.iso in the cd drive > > but it boots to the grub menu every time. The laptop will boot the 10.0 > > cd Is there something else I need to do? (Make the iso bootable?) > > Please check the contents of your self-burned CD and in case you see a > single .iso file on it, then it was not burned correctly. If you see > folders/files then still could confirm that its intact e.g. with md5sum. > I do see files and folders and the md5sum is correct. Jerome > Pelibali ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] postgresql vs mysql
On Thursday 22 February 2007 05:10, Rich Shepard wrote: > On Thu, 22 Feb 2007, Tim Tassonis wrote: > > I do still think it is a bit of an oddity, the concept of the null > > column. From my experience, it creates more problems than it actually > > solves and generally forces you to code more rather than less in order to > > achieve your goals. > > Tim, > >Long ago, a lot of database applications used 99, or 999, or -1 to > indicate an unknown value. However, those don't fit well with a textual > field and they will certainly skew results if used in arithmetic > calculations in numeric fields. > >The concept of NULL representing an unknown value, and therefore one > that cannot be compared with any other value including other NULLs, is no > different from the concept of zero which was not in mathematics for the > longest time until some insightful Arab Indian, the Arabs learned of zero from the Indians. > mathematician saw the need for a > representation of 'nothing' in arithmetic and higher mathematics. > >There was probably resistance to that idea, too, as folks tried to wrap > their minds around the idea that 'nothing' could be validly represented by > a symbol and it was actually necessary to advance beyond what the Greeks > and Romans -- and everyone else -- could do. Now, one would be thought a > bit strange to question the validity of zero. > >NULL solves as many intransigent problems with digital data storage and > manipulation in databases as zero did in the realm of counting. > > HTH, > > Rich ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] [SLE] Install source
On Sunday 20 August 2006 03:46, Anders Johansson wrote: > On Sunday 20 August 2006 15:29, Chris Herrnberger wrote: > > Hay my main bitch with a smile is that since 5.2 I could point yast to > > any directory on my machine, remote or local and include the directory as > > a yast source, however more typically used on my own machine. Now I have > > to create a yast repository, and go to all that work, just to include an > > existing directory on my laptop say for example the latest KDE just to > > ensure that all dependencies are addressed. Used to be as simple as point > > an click (and since 5.2) Now its a half hour exercise. > > YaST1 could do that, and for a long time YaST2 couldn't. But in the later > releases, you have the possibility to add a "local directory" as an > installation source in YaST, and it will take it even if it isn't in > repository format (IOW it's just a directory of rpms) > > From the command line, it's "rug mount /path/to/dir " and it gets > added as an installation source Is it possible to use Yast in 10.1 in the same way as 10.0? Thanks, Jerome ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] No Database Drivers
I'm trying to get sql-ledger up and running. (I sent some earlier email's but I can't tell if they were received because I'm note receiving any posts from this list in my mailbox even though I am subscribed. I sent an email to the listmaster but it was returned.) So I deleted /sql-ledger and ran setup.pl again: Even though http://localhost/index.html.en works now, http://localhost/sql-ledger/admin.pl now gives this error: Error! No Database Drivers available! How do I correct this error? Thanks, Jerome ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] IDENT and pg_hda.conf
Is this good advice? IDENT Authentication failed for user "postgres" This error has everything to do with the way distros set up access rights for postgres. They are way too restrictive and leave you wondering what to do next. Do yourself a favour and change authentication type in pg_hba.conf to local all trust until you have figured out what all this stuff in pg_hba.conf does. Read about the different authentication settings and change them as you see fit. It is all described in detail in pg_hba.conf In any case I don't have a pg_hba.conf file: :~> locate pg_hba.conf /usr/share/postgresql/pg_hba.conf.sample :~> Should I have one? If I should, where does it belong? Thanks, Jerome ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
