Hi All,
i created a user in pgadmin, specified a password
of course. the user is created, but the password is encypted somehow., i cannot
log in anymore!!!
please help me, what is the problem
Best Regards,
Iván HorváthChief Programmer
Alcatel NSDPMS 2000 Product Team
H-1116, BudapestKondo
HIGH QUALITY SCREW THREAD INSERTS
Dear esteemed customer,
RoseCoil Company has been a dependable supplier of high quality screw thread
inserts for over 15 years, and we are pleased to introduce our products to you.
We are looking for professional Agent who has interesting about our pro
Ivan,
I
tunnel my pgAdmin connection through an SSH connection to provide security for
pgAdmin logins. You can use the standard SSH port forwarding feature to
have your pgAdmin connect to PostgreSQL. I believe there is now
documentation on how to use SSH port forwarding with pgAdmin.
Hi Dave,
ok thank you!
but nevertheless the encryption of the user
password is not a bad idea, so what encyption method is used by
pgadmin?
i mean i create a user with pgadmin, specify a
password for the user
if i check the pg_shadow table i see a long text in
the pasword field.
if i w
pgAdmin doesn't use encryption itself, that tickbox
just makes it use the ENCRYPTED keyword in CREATE/ALTER USER sql statements in
PostgreSQL 7.2+. Check out the PostgreSQL 7.2 documentation for details on using
the encrypted passwords.
BTW.
PostgreSQL uses MD5.
Regards, Dave.
Hi,
Under
Tools -> Options, on the PostgreSQL tab, uncheck the box labelled 'Use
Encrypted Passwords', and then alter the password for your
user.
Regards, Dave.
-Original Message-From: Ivan Horvath
[mailto:[EMAIL PROTECTED]] Sent: 13 March 2002
10:53To: [EMAIL PROTECTE
I have
just written a doc about the encrypted passwords which will be in the helpfile
for the next release of pgAdmin, and can be found at http://www.pgadmin.org/pgadmin2.php?ContentID=19";>http://www.pgadmin.org/pgadmin2.php?ContentID=19.
SSH
connections are slightly different to the en