Changes between Initial Version and Version 1 of Ticket #84, comment 3
- Timestamp:
- May 24, 2018 4:00:39 PM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #84, comment 3
initial v1 12 12 }}} 13 13 14 {{{ !sql14 {{{#!sql 15 15 ALTER USER user_name WITH PASSWORD 'new_password'; 16 16 }}} … … 30 30 Created a "custom-format" dump of the database . Include binary blobs (-b) and verbose (-v) output. Used admin account. The psql version is the one from my computer 9.6.3 31 31 32 {{{ 32 {{{#!sh 33 33 F: 34 34 cd F:/base … … 37 37 Do a fresh install of PostGIS in a new database (on the 9.6 server). 38 38 39 {{{ 39 {{{#!sh 40 40 createdb -h 1.100.1.6 -p 5434 -U postgres dbeel 41 41 psql -h 1.100.1.6 -p 5434 -U postgres dbeel … … 46 46 >> You may also want to install legacy.sql if you have functions that use deprecated PostGIS functions. 47 47 > for me it is : 48 {{{ 48 {{{#!sh 49 49 psql -h 1.100.1.6 -p 5434 -U postgres -c 'psql -h 1.100.1.6 -p 5434 -U postgres -f "C:\Program Files\PostgreSQL\9.6\share\contrib\postgis-2.4\legacy.sql" dbeel 50 50 }}} 51 51 52 52 I'm getting a lot of return like 53 {{{ 53 {{{#!sh 54 54 psql:C:/Program Files/PostgreSQL/9.6/share/contrib/postgis-2.4/legacy.sql:1585: NOTICE: le type de retour geometry est seulement un shell 55 55 }}} … … 65 65 66 66 Create an upgrade.bat file with contents something like this and save in same folder as your database backup: 67 {{{ 67 {{{#!sh 68 68 set PGPORT=5434 69 69 set PGHOST=w3
