Thread: problem with postgres and mandrake 8.2

problem with postgres and mandrake 8.2

From
"renaud diez"
Date:
I have stupid problem after installation....
I can't access my postgres db after installation,  when asking me the login and the password, i set 'postgres' (i'm on root) and leave password to blank : don't work !
I try my system log & pass, same problem ...
Is there some changes on default login and password ?
What must i do ?
 
Renaud from belgium

Re: problem with postgres and mandrake 8.2

From
Michael Loftis
Date:
Default user is pgsql.

You can also access it by:

# su - pgsql
$ psql
...

Best luck.

renaud diez wrote:

> I have stupid problem after installation....
>
> I can't access my postgres db after installation,  when asking me the
> login and the password, i set 'postgres' (i'm on root) and leave
> password to blank : don't work !
>
> I try my system log & pass, same problem ...
>
> Is there some changes on default login and password ?
>
> What must i do ?
>
>
>
> Renaud from belgium
>



Re: problem with postgres and mandrake 8.2

From
Peter Eisentraut
Date:
renaud diez writes:

> I have stupid problem after installation....

What did you install and how?

> I can't access my postgres db after installation,  when asking me the login and the password, i set 'postgres' (i'm
onroot) and leave password to blank : don't work ! 

The default installation doesn't require a password.

--
Peter Eisentraut   peter_e@gmx.net


Re: problem with postgres and mandrake 8.2

From
Lamar Owen
Date:
On Monday 15 April 2002 01:18 pm, Peter Eisentraut wrote:
> > I can't access my postgres db after installation,  when asking me the
> > login and the password, i set 'postgres' (i'm on root) and leave password
> > to blank : don't work !

> The default installation doesn't require a password.

The default postgres Unix user in the RPMs cannot be logged into.  You must su
to it from root -- then you can change the Unix user 'postgres' password.

The database superuser does not equal the postgres unix user.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11