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.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users