"TBNube" <[EMAIL PROTECTED]> writes: > I added the password but no change. > sqlobject.dburi="postgres://postgres:[EMAIL PROTECTED]:5432/ajaxdb" > I tried both to have the database (ajaxdb) pre-created and dropped. > In case anyone wonders I have started with a newly installed virgin > operating system many times.
try
sqlobject.dburi="postgres://postgres@/ajaxdb"
or
sqlobject.dburi="postgres://postgres:admin@/ajaxdb"
if the postgres user requires a password.
sometimes specifying the 'localhost' confuses it.
also, is the 'postgres' user the *database* user or the system user. ie,
did you do a 'createuser postgres'? the username specified in the dburi
must be a database user. on some systems, there might be both a
'postgres' system account and a 'postgres' database account, but it can
be confusing. i usually create a new database user for each application
just to keep things clear (it also allows you to set up tighter
permissions if that becomes important).
so the whole process for me would normally look like:
$ createuser ajaxdb
$ createdb ajaxdb
$ psql ajaxdb -U ajaxdb # just to test and make sure you can connect
then, i would use "postgres://ajaxdb@/ajaxdb" as the dburi
--
anders pearson : http://www.columbia.edu/~anders/
C C N M T L : http://www.ccnmtl.columbia.edu/
weblog : http://thraxil.org/
pgpGMHfFnyIFZ.pgp
Description: PGP signature
