![]() Consult the PostgreSQL online manual for these settings. In a production environment, you should also set up TLS-secured communication, and you should consider setting up data replication or snapshot-based backups. Create an empty database for JetPatch, and a user with full access to it:.Restart the PostgreSQL service by typing " service postgresql-12 restart ” (or the version that is installed).Modify the nf (also in //pgsqldata/ ) file to allow connections from all hosts by uncommenting the following and adding an * instead of localhost:.Modify the pg_hba.conf file in //pgsqldata/ to define what authentication method should be used from all networks to the PostgreSQL server and modify the localhost authentication method (change from indent to md5 and change from localhost to accept all incoming requests):. ![]() usr/pgsql-12/bin/postgresql-12-setup initdb
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |