So what I have is a postgreSQL database and I was trying to connect to
it via a Python module (PyGreSQL) from the same machine. I created a
table under the user 'postgres' called postgres.
When I started up the machine and logged on, I was the root. When I
tried to do this:
psql -U postgres -d postgres
I got:
psql: FATAL: IDENT authentication failed for user "postgres"
so I figured out I had to switch user and be postgres instead of root
with:
su postgres
then, after issuing the same command:
psql -U postgres -d postgres
I had success.
By the way, the same goes if you're trying to access a table via a
Python module. If the database (or table) is for a certain user, you
must be logged in as that user before you can access it with pg or
pgdb.
Hope that helps someone...
Subscribe to:
Post Comments (Atom)
JMeter JSON Extractor
json response {"Key1":"Value1","Key2":"Value2","Key2":"Value2"} Name of t...
-
This process will common for all HP Printers like HP LJ P 1007, P1020,P1020 plus,1022,3050 MFP, M 5035 MFP,P 2015N and Configuring the HP ...
-
Required Steps: HP Smart Install is a service running on firmware which You can det ect and disable Smart Inst all using t he 1. Usi...
-
List file=new ArrayList (); file.add("/home/selenium-workspace/starauto/starEE.xml"); file.add("/home/selenium-workspace...
No comments:
Post a Comment