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
local all all trust
host all all 127.0.0.1/32 md5
then restart postgresql service

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. :)

Comments

Post a Comment

Popular posts from this blog

Changing postgres password and warning

ORIGINAL from https://serverfault.com/questions/110154/whats-the-default-superuser-username-password-for-postgres-after-a-new-install CAUTION  The answer about changing the UNIX password for "postgres" through "$ sudo passwd postgres" is not preferred, and can even be  DANGEROUS ! This is why: By default, the UNIX account "postgres" is locked, which means it cannot be logged in using a password. If you use "sudo passwd postgres", the account is immediately unlocked. Worse, if you set the password to something weak, like "postgres", then you are exposed to a great security danger. For example, there are a number of bots out there trying the username/password combo "postgres/postgres" to log into your UNIX system. What you should do is follow  Chris James 's answer: sudo -u postgres psql postgres # \password postgres Enter new password: To explain it a little bit. There are usually two default ways to login to...
Read more

yoh, Sort dict

have a problem with sorting dict by value!!! found something interesting on http://code.activestate.com/recipes/304440/ by Nick Coghlan let's see >>d = {'a':0,'b':1,'c':2} >>d #will get {'a':0,'c':2,'b':1} some solution from Nick >>from operator import itemgetter >>print sorted(d.items(),key=itemgetter(1)) #we get [('a':0),('b':1),('c':2)] # >>>>> a list of tuples it might be useful in the future!!!:) thank nick and activestate
Read more