![]() ![]() Once the package is installed, to get more information look at /usr/share/doc/postgresql-doc-/tutorial/README. PostgreSQL documentation points to tutorial, which is included in the postgresql-doc package. To get an overview about Debian's PostgreSQL architecture, instructions for a quick start, and pointers to the programs and manpages, have a look at /usr/share/doc/postgresql-common/. See /usr/share/doc/postgresql-common/ section "Default clusters and upgrading" More info on the syntax can be found here : Now you can easily connect with $ psql -d mypgdatabase -h localhost -U mypguser ![]() $ psql -d mypgdatabase -h localhost -U mypguserĪdd line for auth : $ echo 'hostname:port:mypgdatabase:mypguser:mypgpassword' > ~/.pgpass Or, if the OS user name is not the same as the database user name: $ createuser -pwprompt mypguser #from regular shellĬonnect as user mypguser to new database # su - mypguser Switch to user postgres and create a new database user and a database: # su - postgres If your system uses sudo to get administrative rights: $ sudo -u postgres psqlĬreate a regular system user account using adduser (skip this step to use an existing account): # adduser mypguser #from regular shell Search Debian packages to find the list of possibilities:īoth the default database user and default database are called postgres. Please note that the procedural languages are installed separately (plpgsql comes by default). ![]() Phppgadmin - PostgreSQL web-based administration tool. Postgresql-doc - PostgreSQL documentation. # apt install postgresql postgresql-client Required packages: postgresql postgresql-client ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |