Things to to after install postgresql in linux
After you have done
>> sudo apt-get install postgresql
You're open to these things. You have to know that the system must have at least one db that named of you. You need to create that. You can, but it need to do this first
Edit pg_hba.conf
(locate on /etc/postgresql//main/pg_hba.conf
Add 2 lines
Login to postgresql
>> sudo -u postgres psql template1
psql> create user "" with password '';
psql> alter user "" with superuser;
psql>\q
>> createdb "" -E UTF8 -O ""
That's it. :)
>> sudo apt-get install postgresql
You're open to these things. You have to know that the system must have at least one db that named of you. You need to create that. You can, but it need to do this first
Edit pg_hba.conf
(locate on /etc/postgresql/
Add 2 lines
local all all trustthen restart postgresql service
host all all 127.0.0.1/32 md5
Login to postgresql
>> sudo -u postgres psql template1
psql> create user "
psql> alter user "
psql>\q
>> createdb "
That's it. :)
Comments
Post a Comment