Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
create connection by using data environment to postgresql
- Thread starter mikeklih
- Start date
Hi,
In the /var/lib/pgsql/data directory, for my RedHat Linux 7.3, make sure that the pg_hda.conf file is set to trust, instead of password for example. You should be able to connect directly to the database server like:
psql template1 postgres
This assume that the postmaster service is running.
You should setup a password for the postgres user. After doing so, you should edit the /var/lib/pgsql/data/pg_dba.conf file and make access to the databases server more restrictive, maybe by requiring passwords to access postgres, so a user would need a password to talk to the database server by issuing psql commands.
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
In the /var/lib/pgsql/data directory, for my RedHat Linux 7.3, make sure that the pg_hda.conf file is set to trust, instead of password for example. You should be able to connect directly to the database server like:
psql template1 postgres
This assume that the postmaster service is running.
You should setup a password for the postgres user. After doing so, you should edit the /var/lib/pgsql/data/pg_dba.conf file and make access to the databases server more restrictive, maybe by requiring passwords to access postgres, so a user would need a password to talk to the database server by issuing psql commands.
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
- Status
Similar threads
- Locked
- Question
- Locked
- Question