It can be used to start, stop, restart and reload the system. To customize the behavior check the /etc/postgresql///pg_ctl.confĭebian installs SysV-init compatible (standard) start-up script /etc/init.d/postgresql. Use the pg_ctlcluster whenever you need the pg_ctl. Debian has made a Perl-wrapper for the pg_ctl called /usr/bin/pg_ctlcluster. Pg_ctl is a PostgreSQL command line control program that can be used to control the database. Use pg_lsclusters command to check installed clusters and obtain some basic information such as: version (major version), name, port, status (online or down), owner, data directory and log file. 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 kommentar(er)
