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

Status
Not open for further replies.

mikeklih

Programmer
Jul 21, 2002
2
MY
i am new in postgresql, can anyone tell me how to connect to postgresql database in linux server by using the data environment . i have installed the postgresql odbc driver but i have no idea how to use the data environment to connect to database.


 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top