[postgis-users] The correct way to restore is?

DrYSG ygutfreund at draper.com
Tue Jan 3 11:07:41 PST 2012


Here is a little look at the database I am trying to restore:

C:\Program Files (x86)\PostgreSQL\9.1\bin\pg_restore.exe --host localhost
--port 5432 --username "postgres" --dbname "GPL" --no-password  --list
"\\csdlnet\services\FS5-Projects\EGPL\FalconGPL\gpl_database_backups\12-28-2011\12-28-2011.backup"
;
; Archive created at Wed Dec 28 11:02:07 2011
;     dbname: m3_db
;     TOC Entries: 1871
;     Compression: -1
;     Dump Version: 1.12-0
;     Format: CUSTOM
;     Integer: 4 bytes
;     Offset: 8 bytes
;     Dumped from database version: 9.0.5
;     Dumped by pg_dump version: 9.0.5
;
;
; Selected TOC Entries:
;
3320; 1262 17333 DATABASE - m3_db root
3321; 1262 17333 COMMENT - m3_db root
6; 2615 2200 SCHEMA - public postgres
3322; 0 0 COMMENT - SCHEMA public postgres
3323; 0 0 ACL - public postgres
1720; 2612 11574 PROCEDURAL LANGUAGE - plpgsql root
1579; 0 0 SHELL TYPE public box2d root
191; 1255 18105 FUNCTION public box2d_in(cstring) root
192; 1255 18106 FUNCTION public box2d_out(box2d) root
1578; 1247 18104 TYPE public box2d root
3324; 0 0 COMMENT public TYPE box2d root
1583; 0 0 SHELL TYPE public box3d root
193; 1255 18109 FUNCTION public box3d_in(cstring) root
194; 1255 18110 FUNCTION public box3d_out(box3d) root
1582; 1247 18108 TYPE public box3d root
3325; 0 0 COMMENT public TYPE box3d root
1586; 0 0 SHELL TYPE public box3d_extent postgres
195; 1255 18113 FUNCTION public box3d_extent_in(cstring) postgres
196; 1255 18114 FUNCTION public box3d_extent_out(box3d_extent) postgres
1585; 1247 18112 TYPE public box3d_extent postgres
3326; 0 0 COMMENT public TYPE box3d_extent postgres
1589; 0 0 SHELL TYPE public chip root
-- 
View this message in context: http://old.nabble.com/The-correct-way-to-restore-is--tp33073199p33074128.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list