Hii
I have installed postgresql-8.2.6 in /usr/local/postgresql/ directory.
I have also created the data dictionary in /var/lib/pgsql/data directory
using following commands:
/usr/local/postgresql/bin/initdb -D /var/lib/pgsql/data/
The owner of my var/lib/pgsql/data directory is globus and owner
arpit jain wrote:
Hii
I have installed postgresql-8.2.6 in /usr/local/postgresql/ directory.
I have also created the data dictionary in /var/lib/pgsql/data directory
using following commands:
What OS?
/usr/local/postgresql/bin/initdb -D /var/lib/pgsql/data/
The owner of my var/lib/pgsql/da
Hello,
I don't know how can I pass a md5 password to the password field ?
example :
connInfo = "host=localhost port=5432 dbname=db_stats user=postgres
password=secret";
pConn = PQconnectdb(connInfo);
I try to replace the string 'secret' by the content of /etc/shadow but
without succès.
Tha
How do you have your pg_hba.conf file setup ?
If on the shell as the postgres user, you can login into the
"db_stats" database without a password being asked for than you should
not need one.
Try out:
postgres$> psql db_stats
and see if you can login without asking for a PW.. check your
Hi Gus,
You should be able to, I'm not a C guru but on perl I can without any
issues.
Did you setup a password for the postgres user account in postgreSQL
itself ?
I found strange that you were trying out the password from /etc/shadow
file though.
> ALTER USER postgres WITH ENCRYPTED PASS
Hello Marcelo,
Thanks for your respons
I have a password and is what I need.
My pg_hba.conf have 'md5' :
hostall all 127.0.0.1/32 md5
My question are just how I can connect from the C api with an md5
password or it's not possible ?
Regards
Guy
Marcelo Martins a é
Gus ? :-)
No I need to put the md5 string into the connInfo, just that.
the other parts work fine
Guy
Marcelo Martins a écrit :
Hi Gus,
You should be able to, I'm not a C guru but on perl I can without any
issues.
Did you setup a password for the postgres user account in postgreSQL
itself ?
Guy Deleeuw <[EMAIL PROTECTED]> writes:
> No I need to put the md5 string into the connInfo, just that.
No, you need to put the plain text of the password into the connInfo.
Knowing the md5 doesn't prove you know the password.
regards, tom lane
--
Sent via pgsql-admin ma
Hello Tom
No, you need to put the plain text of the password into the connInfo.
Knowing the md5 doesn't prove you know the password.
regards, tom lane
I just try to cancel the easy way to "string" the binary and extract the
password from my app.
A solution are to p
