![]() From now on, you can connect to PostgreSQL by simply psql.Ceate a new database with the same name as OS account by CREATE DATABASE.Remove the default database created by DROP DATABASE postgres.Change password by ALTER USER PASSWORD 'new_password_here'.Connect to the database by psql template1, where template1 is the template database shipped with PostgreSQL.Start the database by pg_ctl -D /temp/yunpengn/postgresql/data -l /temp/yunpengn/postgresql/server.log start.Initialize the database by initdb -D /temp/yunpengn/postgresql/data.Add PostgreSQL binaries into your path by echo 'export PATH="/temp/yunpengn/postgresql/bin:$PATH"' > ~/.bash_profile & source ~/.bash_profile. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |