Dear all,
I need some help to get postgres working under
windows.
I installed postgress using the .msi
I am able to start the pgadminiii and start the
database server with no problems.
Now I try to create a database as explained in the
documentation:
createdb mydb
The systems asks for a pas
Did you restart the service?
Did you change the postgresql.conf file to listen on tcp/ip all addresses?
listen_addresses = '*'
After that I made some changes to the pg_hba.conf file
and changed the method
hostall all 127.0.0.1/32 md5
INTO
hostall all
Tony,
I tried your suggestion but it is not helping me out.
Restarting the server is not helping either.
What I tried next is create the database in pgadminiii
and assign my userid as the owner.
But that is not working either. So I have run out of
options.
regards,
Danny
--- Tony Caduto <[EMA
Danny,
On May 30, 2005, at 10:13 AM, Danny Gaethofs wrote:
Now I try to create a database as explained in the
documentation:
createdb mydb
The systems asks for a password and when I enter the
password it comes back with:
could not connect to database template1: FATAL:
password authentication
John,
The command you gave createdb.exe -h 127.0.0.1 -U
postgres mydb is working.
The system gives me the result CREATE DATABASE.
Looking into pgadminiii shows the database is created.
Doing the same with my user account is not working.
Thanks anyway it is making me understand postgres
better.
Ah, I didn't catch the fact that you where not doing it as the super
user (postgres)
For another account to work you need to grant that account the createdb
right.
Look up in the docs about the grant command.
Glad to hear you have it working.
Tony Caduto
http://www.amsoftwaredesign.com
Home o