Hello,

I recently set up a small Mandrake 10 box that I want
to use as a DB server....

I tried to log in to postgres through ssh and trough
webmin and I'm not sure what the default password is.

Can anyone help?

Thanks,

Yves

__________________________________________________ ____________________
Post your free ad now! http://personals.yahoo.ca

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

At 01:57 PM 7/15/04, Yves wrote:

Login as yourself, 'su' to root, then 'su' to postgres (there will be no
password prompt), then change the password.


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Thu, 15 Jul 2004 13:57:44 -0400 (EDT) Yves wrote:
Why don't you login as a normal user, become root, and then change the
password of the postgres user?

Felix

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

ok, here for the list.. sorry..

On Thu, 15 Jul 2004 14:31:26 -0400
Frank Bax <fbax (AT) sympatico (DOT) ca> wrote:

better: use sudo(8).
for example: sudo -u postgres psql foobar

no need to enter root password.

cu
JRL

--
visit my OpenBSD ports page: http://vgai.de/ports
--
If you don't remember something, it never existed...
If you aren't remembered, you never existed...

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

Thanks fo the replies,

I changed the password of the postgres account and
still cannot log in...

Should the root account be like an administrative
account having all rights and privileges within the
postgres server?

Thanks,

Yves


--- Julian Leyh <oenone (AT) oenone (DOT) de> wrote: > ok, here
for the list.. sorry..
__________________________________________________ ____________________
Post your free ad now! http://personals.yahoo.ca

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

At 07:26 AM 7/16/04, Yves wrote:

vipw

check to see if postgres user has a shell. If its something like /bin
false, change it to something like /bin/bash - or your favorite shell.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Thanks for the response,

It was set to /bin/bash already...

It was the webmin console that was a problem, I
'synced' it with the unix user and now it works fine.

Thanks for the help!

I'm quite new to postgres, I used MySQL a bit before,
I've heard it said that PostgreSQL was a very secure
server... I'm interested in checking it out.

Yves


--- Frank Bax <fbax (AT) sympatico (DOT) ca> wrote: > At 07:26 AM
7/16/04, Yves wrote:
__________________________________________________ ____________________
Post your free ad now! http://personals.yahoo.ca

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html