Monday, April 4, 2016

Using Postgres pgsql database without password

For developing reason you may need to install PostgreSQL database without password , this is useful when developing locally, but you have to change it for a production server:
 this when you install your server for the first time

initdb -U postgres -A password -E utf8 -W -D POSTGRESQL_ROOT\data

Now if you want the server to conncected to without paswword then  write it like this

initdb -U postgres   -E utf8  -D POSTGRESQL_ROOT\data

That's it

No comments:

Post a Comment