Opened 8 years ago
Closed 8 years ago
#2960 closed defect (fixed)
db.login port parameter
| Reported by: | lucadelu | Owned by: | |
|---|---|---|---|
| Priority: | major | Milestone: | 7.2.0 |
| Component: | Database | Version: | svn-trunk |
| Keywords: | database, postgresql, db.login | Cc: | |
| CPU: | Unspecified | Platform: | Unspecified |
Description
It seems that PostgreSQL database library is not working correctly with port different from the standard 5432.
Following the steps I did
db.connect driver=pg database=grassdata
db.login driver=pg database=grassdata user=lucadelu port=5433 host=localhost
db.login -p
pg|grassdata|lucadelu|||
cat /home/lucadelu/.grass7/dblogin
pg|grassdata|lucadelu||localhost|5433
db.tables
DBMI-PostgreSQL driver error:
Connection failed.
could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
DBMI-PostgreSQL driver error:
Connection failed.
could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
ERROR: Unable to open database <grassdata>
Change History (6)
comment:1 by , 8 years ago
| Milestone: | 7.0.4 → 7.1.0 |
|---|
comment:2 by , 8 years ago
| Component: | Datasets → Database |
|---|
comment:3 by , 8 years ago
| Milestone: | 7.1.0 → 7.2.0 |
|---|
follow-up: 6 comment:5 by , 8 years ago
I imagine that this is the same issue as #3167 which was fixed. Could you see if you still have this issue ?
comment:6 by , 8 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Replying to mlennert:
I imagine that this is the same issue as #3167 which was fixed. Could you see if you still have this issue ?
Right, seems to be like that. I tested PG database cluster running on port 5433.
db.login dri=pg data=db port=5433 db.tables -p
Worked. Closing, feel free to re-open if needed.
Note:
See TracTickets
for help on using tickets.

Milestone renamed