Skip to content
This repository has been archived by the owner. It is now read-only.

Problems connecting to localhost pgsql in nomatim #2813

Closed
openstreetmap-trac opened this issue Jul 23, 2021 · 3 comments
Closed

Problems connecting to localhost pgsql in nomatim #2813

openstreetmap-trac opened this issue Jul 23, 2021 · 3 comments

Comments

@openstreetmap-trac
Copy link

@openstreetmap-trac openstreetmap-trac commented Jul 23, 2021

Reporter: h4ck3rm1k3
[Submitted to the original trac issue database at 12.07pm, Sunday, 21st March 2010]

I have problems connecting to the database using DB
This works :
psql -h localhost gisdb gis

I installed pear install MDB2_Driver_pgsql.

Now I am reworking the code for using the PDO.

@openstreetmap-trac
Copy link
Author

@openstreetmap-trac openstreetmap-trac commented Jul 23, 2021

Author: h4ck3rm1k3
[Added to the original trac issue at 5.47pm, Sunday, 21st March 2010]

It works now! patch for website so far.

New test results with new patch:
php ./util.update.php --index
Rank: 0, total to do: 0
Rank: 1, total to do: 0
Rank: 2, total to do: 0
Rank: 3, total to do: 0
Rank: 4, total to do: 2
480458: 1, 2 remaining (17:35:28)
480459: 1, 1 remaining (17:35:28)
Finished Rank: 4 in 1 2 per second
Rank: 5, total to do: 0
Rank: 6, total to do: 0
Rank: 7, total to do: 0
Rank: 8, total to do: 3
480458: 3, 3 remaining (17:35:29)
Rank: 9, total to do: 0
Rank: 10, total to do: 45
480458: 36, 45 remaining (17:35:29)
479458: 3, 9 remaining (17:35:29)
481458: 6, 6 remaining (17:35:29)
Rank: 11, total to do: 0
Rank: 12, total to do: 18
480458: 17, 18 remaining (17:35:29)
481458: 1, 1 remaining (17:35:29)
Rank: 13, total to do: 0
Rank: 14, total to do: 0
Rank: 15, total to do: 0
Rank: 16, total to do: 8
480459: 3, 8 remaining (17:35:29)
481460: 1, 5 remaining (17:35:29)
481458: 1, 4 remaining (17:35:29)
481459: 1, 3 remaining (17:35:30)
480458: 2, 2 remaining (17:35:30)
Finished Rank: 16 in 1 8 per second
Rank: 17, total to do: 30
480459: 9, 30 remaining (17:35:30)
480460: 5, 21 remaining (17:35:30)
479458: 1, 16 remaining (17:35:30)
479459: 2, 15 remaining (17:35:30)
480457: 1, 13 remaining (17:35:30)
480458: 10, 12 remaining (17:35:30)
481458: 2, 2 remaining (17:35:31)
Finished Rank: 17 in 1 30 per second
Rank: 18, total to do: 1006
481458: 113, 1006 remaining (17:35:31)
481459: 1, 893 remaining (17:35:32)
479458: 96, 892 remaining (17:35:32)
480460: 44, 796 remaining (17:35:34)
480458: 649, 752 remaining (17:35:35)
480457: 86, 103 remaining (17:35:45)
479459: 9, 17 remaining (17:35:47)
479460: 8, 8 remaining (17:35:47)
Finished Rank: 18 in 16 62.875 per second
Rank: 19, total to do: 0
Rank: 20, total to do: 98
479458: 5, 98 remaining (17:35:47)
481458: 24, 93 remaining (17:35:47)
479459: 2, 69 remaining (17:35:48)
480457: 39, 67 remaining (17:35:48)
480458: 28, 28 remaining (17:35:49)
Finished Rank: 20 in 2 49 per second
Rank: 21, total to do: 15
479458: 10, 15 remaining (17:35:49)
480459: 3, 5 remaining (17:35:49)
480460: 1, 2 remaining (17:35:49)
481460: 1, 1 remaining (17:35:49)
Rank: 22, total to do: 42
480459: 3, 42 remaining (17:35:49)
481458: 16, 39 remaining (17:35:50)
479459: 1, 23 remaining (17:35:50)
480458: 22, 22 remaining (17:35:50)
Finished Rank: 22 in 1 42 per second
Rank: 23, total to do: 0
Rank: 24, total to do: 0
Rank: 25, total to do: 1
480458: 1, 1 remaining (17:35:50)
Rank: 26, total to do: 377
479458: 4, 377 remaining (17:35:50)
479459: 6, 373 remaining (17:35:50)
479460: 2, 367 remaining (17:35:51)
480457: 2, 365 remaining (17:35:51)
480458: 49, 363 remaining (17:35:51)
480459: 159, 314 remaining (17:35:52)
480460: 25, 155 remaining (17:35:55)
481458: 121, 130 remaining (17:35:56)
481459: 8, 9 remaining (17:35:58)
481460: 1, 1 remaining (17:35:59)
Finished Rank: 26 in 9 41.8888888889 per second
Rank: 27, total to do: 6
481458: 6, 6 remaining (17:35:59)
Rank: 28, total to do: 0
Rank: 29, total to do: 0
Rank: 30, total to do: 1010
481457: 7, 1010 remaining (17:35:59)
479459: 53, 1003 remaining (17:36:00)
481460: 3, 950 remaining (17:36:01)
479460: 32, 947 remaining (17:36:01)
481458: 119, 915 remaining (17:36:02)
480459: 108, 796 remaining (17:36:04)
481459: 42, 688 remaining (17:36:07)
479458: 75, 646 remaining (17:36:08)
480460: 99, 571 remaining (17:36:10)
480458: 366, 472 remaining (17:36:12)
480457: 106, 106 remaining (17:36:19)
Finished Rank: 30 in 22 45.9090909091 per second

@openstreetmap-trac
Copy link
Author

@openstreetmap-trac openstreetmap-trac commented Jul 23, 2021

Author: twain
[Added to the original trac issue at 7.03pm, Sunday, 21st March 2010]

$oDB =& DB::connect('pgsql://gis@/localhost/gisdb', false);

should have been

$oDB =& DB::connect('pgsql://gis@localhost/gisdb', false);

@openstreetmap-trac
Copy link
Author

@openstreetmap-trac openstreetmap-trac commented Jul 23, 2021

Author: h4ck3rm1k3
[Added to the original trac issue at 7.44am, Monday, 22nd March 2010]

Thanks, thats great.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant