Home / Questions / 3217
Accepted
Diana Carolina Hernandez
Asked: 2020-01-28 06:22:46 +0800 CST 2020-01-28 06:22:46 +0800 CST

How to use postgresql for the first time?

  • 772

Yesterday I formatted the computer with Debian and I need to continue in my projects but I have not been able to use postgresql again, in the terminal I used:

caro@caro-pc:~$ sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev
caro@caro-pc:~$ psql --version
psql (PostgreSQL) 9.5.0

But I don't remember what other steps follow, since if I do the following:

caro@caro-pc:~$ sudo-i -u postgres
postgres@caro-pc:~$ psql -V

I get: 

psql (PostgreSQL) 9.5.0

But if I do, for example: 

postgres@caro-pc:~$ psql -l

I get: 

psql: no se pudo conectar con el servidor: No existe el fichero o el directorio
¿Está el servidor en ejecución localmente y aceptando conexiones en el socket de dominio Unix «/var/run/postgresql/.s.PGSQL.5432»?

Please can you help me? Do I have to edit any configuration files?

postgresql

2 Answers

  1. Best Answer

    Well, in case the option -Vis just a flag to display the version, no connection to the server is needed:

    postgres@caro-pc:~$ psql -V
psql (PostgreSQL) 9.5.0

    The flag -lshows you the list of available databases, so you necessarily need to have a connection to the server.

    What you can do is make sure the service is up:

    $ ps aux | grep postgres

    If you don't get results you just need to raise the service:

    $ sudo service postgresql start

    Update

    For security reasons, Postgres does not allow remote connections. If you want to enable them you have to do the following:

    • In the config file pg_hba.conf, add (example network):

      host all all 10.10.29.0/24 trust

    • In the configuration file postgresql.conf, you have to use:

      listen_addresses='*'

    • Restart the service:

      $ sudo service postgresql restart
    • 5

  2. I recommend you use the web interface: http://phppgadmin.sourceforge.net/doku.php

    • 1