basic postgresql tips
Start and stop postgresql </p>
Service postgres start
Add to the chkconfig
Chkconfig –level 3 postgres on
to create a first user in kubuntu/ubuntu linux, type the following:
~$ sudo su postgres -c createuser *USERNAME*
Then create a db:
~$ sudo su postgres -c createdb *DBNAME*
Then create a password for the user by connecting using psql:
~$ sudo su postgres -c psql *DBNAME*
Then alter the password:
=#ALTER USER *username* WITH PASSWORD ‘*password*‘;
=#\q</div>