1、Pycharm 连接pg数据库
psycopg2.ProgrammingError: invalid dsn: missing "=" after "schooldb" in connection info string
解决方法:
修改前:
self.conn=psycopg2.connect('schooldb.db',user='user8523',password='admin',host="127.0.0.1",port="5432")
修改后:
conn_string="dbname=schooldb user=user8523 password=admin host=127.0.0.1 port=5432"
self.conn=psycopg2.connect(conn_string)
注意点:pg数据库在python的连接与sqlite不同,各项之前没有逗号隔开
2、java spring boot 连接pg数据库
- 添加依赖 pom.xml
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.22</version>
</dependency>
- application.properties
server.port=8080
# 数据库的地址以及端口号
spring.datasource.url=jdbc:postgresql://localhost:5432/schooldb
# 账号(默认为postgres)
spring.datasource.username=postgres
# 密码
spring.datasource.password=admin
spring.datasource.driverClassName=org.postgresql.Driver
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.properties.hibernate.hbm2ddl.auto=update