Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- import pprint
- import sys
- def main():
- #Variable conexion
- cadenaConexion="host=localhost dbname=test1 user=postgres
- password=admin"
- print("Cadena conexion a la BDn ->%s"%(cadenaConexion))
- obj=psycopg2.connect(cadenaConexion)
- objCursor=obj.cursor()
- objCursor.execute("INSERT INTO tbltext(num, data) VALUES(%s,%s)",
- (26,"Enrique Cortez"))
- obj.commit()
- objCursor.execute("SELECT * FROM tblTest")
- registros=objCursor.fetchall()
- pprint.pprint(registros)
- #objCursor.close()
- #obj.close()
- main()
- ===== RESTART: C:UsersAngelDocumentsDjango pruebaspostgreSQL1_.py
- =====
- Cadena conexion a la BD
- ->host=localhost dbname=test1 user=postgres password=admin
- Traceback (most recent call last):
- File "C:UsersAngelDocumentsDjango pruebaspostgreSQL1_.py", line 20, in
- <module>
- main()
- File "C:UsersAngelDocumentsDjango pruebaspostgreSQL1_.py", line 10, in
- main
- obj=psycopg2.connect(cadenaConexion)
- File "C:Python27libsite-packagespsycopg2__init__.py", line 164, in
- connect
- conn = _connect(dsn, connection_factory=connection_factory, async=async)
- OperationalError: FATAL: la autentificación password falló para el
- usuario «postgres»
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement