Personal tools

HPCLab:Specific PostgreSQL configuration

From hpcwiki

Revision as of 20:40, 21 April 2018 by Hfrancot (Talk | contribs)

Jump to: navigation, search

PostgreSQL 9.4

  • Main guide: http://www.sfentona.net/?p=2756
    • Update: CentOS version is now pgdg-centos94-9.4-3.noarch.rpm (correct the download)
  • The initdb process (create the pgdata structure in the file system) yielded:
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    ./postgres -D /media/hpclab-data/pgdata
or
   ./pg_ctl -D /media/hpclab-data/pgdata -l logfile start