Difference between revisions of "HPCLab:Specific PostgreSQL configuration"
From hpcwiki
(Created page with "=== 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)") |
(→PostgreSQL 9.4) |
||
| Line 3: | Line 3: | ||
* Main guide: http://www.sfentona.net/?p=2756 | * Main guide: http://www.sfentona.net/?p=2756 | ||
** Update: CentOS version is now pgdg-centos94-9.4-3.noarch.rpm (correct the download) | ** 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 | ||
Revision as of 20:40, 21 April 2018
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
