How to start database server in PostgreSQL?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

Before you can have access to the database, you must be able to start the database server. The server program of the database is called Postgres. The Postgres program must know where to find the data it is supposed to use. This is done with the -D option. Thus, the simplest way to start the server is:

  1. /usr/local/etc/rc.d/010.pgsql.sh start
  2. /usr/local/etc/rc.d/PostgreSQL start

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Postgresql Interview Questions

    List some of the features of Postgresql ?

     Following are some of the features of Postgresql : Object-relational database Support and Extensibility for SQL fle..

    Postgresql Interview Questions

    What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?

     The SQL standard is defined by four levels of transaction isolation basically regarding three phenomena. The three phe..

    Postgresql Interview Questions

    Put some light on Multi-Version concurrency control?

     MVCC or better known as Multi-version concurrency control is used to avoid unwanted locking of the database. The time ..