Обсуждение: 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

Hi Jerome,
You need to edit the pg_hba.conf file which controls the hosts Postgres will allow to connect.
By default it's set to only allow connections from local host.

pg_hba.conf is located in the data directory of where you installed PG.

You can also tell a host to be TRUSTED, i.e no password needed, if you have not defined any databases yet you might
want
to set it to TRUST so you can connect to template1, then from there you can create a new database.

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


--
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com

Hello.
This is a newbie question: what is the difference between using = and := in
plpgsql function ?
I tried with both and in both cases my function works...
Thanks.

Zlatko

On May 9, 2005, at 18:00, Zlatko Matic wrote:

> This is a newbie question: what is the difference between using = and
> := in plpgsql function ?

In pl/pgsql,

:= is assignment
= is a logical comparison for equality

Some languages, such as perl, use = for assignment and == for logical
comparison.

x = 1
is a boolean result

x := 1
gives x the value of 1

Quick example:

    x := 2; -- gives x the value of 2

    IF (x = 1) THEN -- x = 1 is false
        x := 3;  -- skipped
    END IF;
    RETURN X; -- returns 2

Again:
    x := 1; -- gives x the value of 1

    IF (x = 1) THEN -- x = 1 is true
        x := 3;  -- perform assignment
    END IF;
    RETURN x; -- returns 3

Hope this helps.

Michael Glaesemann
grzm myrealbox com

Michael Glaesemann <grzm@myrealbox.com> writes:
> On May 9, 2005, at 18:00, Zlatko Matic wrote:
>> This is a newbie question: what is the difference between using = and
>> := in plpgsql function ?

> In pl/pgsql,

> := is assignment
> = is a logical comparison for equality

It looks like the code will in fact allow you to spell an assignment
statement either way ... but I recommend following Michael's advice
for clarity.

            regards, tom lane

thanks.
----- Original Message -----
From: "Michael Glaesemann" <grzm@myrealbox.com>
To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, May 09, 2005 11:30 AM
Subject: Re: [GENERAL] = or := ?


>
>
> On May 9, 2005, at 18:00, Zlatko Matic wrote:
>
>> This is a newbie question: what is the difference between using = and
>> := in plpgsql function ?
>
> In pl/pgsql,
>
> := is assignment
> = is a logical comparison for equality
>
> Some languages, such as perl, use = for assignment and == for logical
> comparison.
>
> x = 1
> is a boolean result
>
> x := 1
> gives x the value of 1
>
> Quick example:
>
> x := 2; -- gives x the value of 2
>
> IF (x = 1) THEN -- x = 1 is false
> x := 3;  -- skipped
> END IF;
> RETURN X; -- returns 2
>
> Again:
> x := 1; -- gives x the value of 1
>
> IF (x = 1) THEN -- x = 1 is true
> x := 3;  -- perform assignment
> END IF;
> RETURN x; -- returns 3
>
> Hope this helps.
>
> Michael Glaesemann
> grzm myrealbox com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>