gistfile1.txt

$ pg_restore -l 2011110708_batch_api_production.dump.sql 
;
; Archive created at Mon Nov  7 08:00:02 2011
;     dbname: batch_api_production
;     TOC Entries: 217
;     Compression: -1
;     Dump Version: 1.12-0
;     Format: CUSTOM
;     Integer: 4 bytes
;     Offset: 8 bytes
;     Dumped from database version: 9.1.1
;     Dumped by pg_dump version: 9.1.0
;
;
; Selected TOC Entries:
;
2143; 1262 17065 DATABASE - batch_api_production batch
6; 2615 2200 SCHEMA - public postgres
2144; 0 0 COMMENT - SCHEMA public postgres
2145; 0 0 ACL - public postgres
210; 3079 11643 EXTENSION - plpgsql 
2146; 0 0 COMMENT - EXTENSION plpgsql 
222; 1255 19724 FUNCTION public crc32(text) batch
161; 1259 17066 TABLE public album_links batch
162; 1259 17069 SEQUENCE public album_links_id_seq batch
2147; 0 0 SEQUENCE OWNED BY public album_links_id_seq batch
2148; 0 0 SEQUENCE SET public album_links_id_seq batch
163; 1259 17071 TABLE public album_members batch
164; 1259 17074 SEQUENCE public album_members_id_seq batch
2149; 0 0 SEQUENCE OWNED BY public album_members_id_seq batch
2150; 0 0 SEQUENCE SET public album_members_id_seq batch
165; 1259 17076 TABLE public album_photo_comments batch
166; 1259 17082 SEQUENCE public album_photo_comments_id_seq batch
2151; 0 0 SEQUENCE OWNED BY public album_photo_comments_id_seq batch
2152; 0 0 SEQUENCE SET public album_photo_comments_id_seq batch
167; 1259 17084 TABLE public album_photo_likes batch
168; 1259 17087 SEQUENCE public album_photo_likes_id_seq batch
2153; 0 0 SEQUENCE OWNED BY public album_photo_likes_id_seq batch
2154; 0 0 SEQUENCE SET public album_photo_likes_id_seq batch
169; 1259 17089 TABLE public album_photos batch
170; 1259 17094 SEQUENCE public album_photos_id_seq batch
2155; 0 0 SEQUENCE OWNED BY public album_photos_id_seq batch
2156; 0 0 SEQUENCE SET public album_photos_id_seq batch
171; 1259 17096 TABLE public album_share_tweets batch
172; 1259 17099 SEQUENCE public album_share_tweets_id_seq batch
2157; 0 0 SEQUENCE OWNED BY public album_share_tweets_id_seq batch
2158; 0 0 SEQUENCE SET public album_share_tweets_id_seq batch
173; 1259 17101 TABLE public albums batch
174; 1259 17106 SEQUENCE public albums_id_seq batch
2159; 0 0 SEQUENCE OWNED BY public albums_id_seq batch
2160; 0 0 SEQUENCE SET public albums_id_seq batch
175; 1259 17108 TABLE public email_notification_settings batch
176; 1259 17114 SEQUENCE public email_notification_settings_id_seq batch
2161; 0 0 SEQUENCE OWNED BY public email_notification_settings_id_seq batch
2162; 0 0 SEQUENCE SET public email_notification_settings_id_seq batch
177; 1259 17116 TABLE public external_users batch
178; 1259 17120 SEQUENCE public external_users_id_seq batch
2163; 0 0 SEQUENCE OWNED BY public external_users_id_seq batch
2164; 0 0 SEQUENCE SET public external_users_id_seq batch
179; 1259 17122 TABLE public facebook_friends batch
180; 1259 17125 SEQUENCE public facebook_friends_id_seq batch
2165; 0 0 SEQUENCE OWNED BY public facebook_friends_id_seq batch
2166; 0 0 SEQUENCE SET public facebook_friends_id_seq batch
209; 1259 17383 TABLE public facebook_links batch
208; 1259 17381 SEQUENCE public facebook_links_id_seq batch
2167; 0 0 SEQUENCE OWNED BY public facebook_links_id_seq batch
2168; 0 0 SEQUENCE SET public facebook_links_id_seq batch
207; 1259 17370 TABLE public facebook_wall_posts batch
206; 1259 17368 SEQUENCE public facebook_wall_posts_id_seq batch
2169; 0 0 SEQUENCE OWNED BY public facebook_wall_posts_id_seq batch
2170; 0 0 SEQUENCE SET public facebook_wall_posts_id_seq batch
181; 1259 17135 TABLE public oauths batch
182; 1259 17141 SEQUENCE public oauths_id_seq batch
2171; 0 0 SEQUENCE OWNED BY public oauths_id_seq batch
2172; 0 0 SEQUENCE SET public oauths_id_seq batch
183; 1259 17143 TABLE public photo_exifs batch
184; 1259 17149 SEQUENCE public photo_exifs_id_seq batch
2173; 0 0 SEQUENCE OWNED BY public photo_exifs_id_seq batch
2174; 0 0 SEQUENCE SET public photo_exifs_id_seq batch
185; 1259 17151 TABLE public photo_metadata batch
186; 1259 17160 SEQUENCE public photo_metadata_id_seq batch
2175; 0 0 SEQUENCE OWNED BY public photo_metadata_id_seq batch
2176; 0 0 SEQUENCE SET public photo_metadata_id_seq batch
187; 1259 17162 TABLE public photo_tags batch
188; 1259 17167 SEQUENCE public photo_tags_id_seq batch
2177; 0 0 SEQUENCE OWNED BY public photo_tags_id_seq batch
2178; 0 0 SEQUENCE SET public photo_tags_id_seq batch
189; 1259 17169 TABLE public photos batch
190; 1259 17180 SEQUENCE public photos_id_seq batch
2179; 0 0 SEQUENCE OWNED BY public photos_id_seq batch
2180; 0 0 SEQUENCE SET public photos_id_seq batch
191; 1259 17182 TABLE public roles batch
192; 1259 17185 SEQUENCE public roles_id_seq batch
2181; 0 0 SEQUENCE OWNED BY public roles_id_seq batch
2182; 0 0 SEQUENCE SET public roles_id_seq batch
193; 1259 17187 TABLE public schema_migrations batch
194; 1259 17190 TABLE public social_connections batch
195; 1259 17196 SEQUENCE public social_connections_id_seq batch
2183; 0 0 SEQUENCE OWNED BY public social_connections_id_seq batch
2184; 0 0 SEQUENCE SET public social_connections_id_seq batch
196; 1259 17198 TABLE public user_avatars batch
197; 1259 17204 SEQUENCE public user_avatars_id_seq batch
2185; 0 0 SEQUENCE OWNED BY public user_avatars_id_seq batch
2186; 0 0 SEQUENCE SET public user_avatars_id_seq batch
198; 1259 17206 TABLE public user_devices batch
199; 1259 17219 SEQUENCE public user_devices_id_seq batch
2187; 0 0 SEQUENCE OWNED BY public user_devices_id_seq batch
2188; 0 0 SEQUENCE SET public user_devices_id_seq batch
200; 1259 17221 TABLE public user_roles batch
201; 1259 17224 SEQUENCE public user_roles_id_seq batch
2189; 0 0 SEQUENCE OWNED BY public user_roles_id_seq batch
2190; 0 0 SEQUENCE SET public user_roles_id_seq batch
202; 1259 17226 TABLE public user_sessions batch
203; 1259 17229 SEQUENCE public user_sessions_id_seq batch
2191; 0 0 SEQUENCE OWNED BY public user_sessions_id_seq batch
2192; 0 0 SEQUENCE SET public user_sessions_id_seq batch
204; 1259 17231 TABLE public users batch
205; 1259 17238 SEQUENCE public users_id_seq batch
2193; 0 0 SEQUENCE OWNED BY public users_id_seq batch
2194; 0 0 SEQUENCE SET public users_id_seq batch
1979; 2604 17240 DEFAULT public id batch
1980; 2604 17241 DEFAULT public id batch
1981; 2604 17242 DEFAULT public id batch
1983; 2604 17243 DEFAULT public id batch
1986; 2604 17244 DEFAULT public id batch
1987; 2604 17245 DEFAULT public id batch
1990; 2604 17246 DEFAULT public id batch
1994; 2604 17247 DEFAULT public id batch
1996; 2604 17248 DEFAULT public id batch
1997; 2604 17249 DEFAULT public id batch
2029; 2604 17386 DEFAULT public id batch
2028; 2604 17373 DEFAULT public id batch
1998; 2604 17251 DEFAULT public id batch
1999; 2604 17252 DEFAULT public id batch
2003; 2604 17253 DEFAULT public id batch
2006; 2604 17254 DEFAULT public id batch
2012; 2604 17255 DEFAULT public id batch
2013; 2604 17256 DEFAULT public id batch
2014; 2604 17257 DEFAULT public id batch
2015; 2604 17258 DEFAULT public id batch
2023; 2604 17259 DEFAULT public id batch
2024; 2604 17260 DEFAULT public id batch
2025; 2604 17261 DEFAULT public id batch
2027; 2604 17262 DEFAULT public id batch
2116; 0 17066 TABLE DATA public album_links batch
2117; 0 17071 TABLE DATA public album_members batch
2118; 0 17076 TABLE DATA public album_photo_comments batch
2119; 0 17084 TABLE DATA public album_photo_likes batch
2120; 0 17089 TABLE DATA public album_photos batch
2121; 0 17096 TABLE DATA public album_share_tweets batch
2122; 0 17101 TABLE DATA public albums batch
2123; 0 17108 TABLE DATA public email_notification_settings batch
2124; 0 17116 TABLE DATA public external_users batch
2125; 0 17122 TABLE DATA public facebook_friends batch
2140; 0 17383 TABLE DATA public facebook_links batch
2139; 0 17370 TABLE DATA public facebook_wall_posts batch
2126; 0 17135 TABLE DATA public oauths batch
2127; 0 17143 TABLE DATA public photo_exifs batch
2128; 0 17151 TABLE DATA public photo_metadata batch
2129; 0 17162 TABLE DATA public photo_tags batch
2130; 0 17169 TABLE DATA public photos batch
2131; 0 17182 TABLE DATA public roles batch
2132; 0 17187 TABLE DATA public schema_migrations batch
2133; 0 17190 TABLE DATA public social_connections batch
2134; 0 17198 TABLE DATA public user_avatars batch
2135; 0 17206 TABLE DATA public user_devices batch
2136; 0 17221 TABLE DATA public user_roles batch
2137; 0 17226 TABLE DATA public user_sessions batch
2138; 0 17231 TABLE DATA public users batch
2031; 2606 17264 CONSTRAINT public album_links_pkey batch
2035; 2606 17266 CONSTRAINT public album_members_pkey batch
2040; 2606 17268 CONSTRAINT public album_photo_comments_pkey batch
2044; 2606 17270 CONSTRAINT public album_photo_likes_pkey batch
2048; 2606 17272 CONSTRAINT public album_photos_pkey batch
2052; 2606 17274 CONSTRAINT public album_share_tweets_pkey batch
2056; 2606 17276 CONSTRAINT public albums_pkey batch
2060; 2606 17278 CONSTRAINT public email_notification_settings_pkey batch
2063; 2606 17280 CONSTRAINT public external_users_pkey batch
2067; 2606 17282 CONSTRAINT public facebook_friends_pkey batch
2112; 2606 17388 CONSTRAINT public facebook_links_pkey batch
2108; 2606 17378 CONSTRAINT public facebook_wall_posts_pkey batch
2071; 2606 17286 CONSTRAINT public oauths_pkey batch
2074; 2606 17288 CONSTRAINT public photo_exifs_pkey batch
2077; 2606 17290 CONSTRAINT public photo_metadata_pkey batch
2082; 2606 17292 CONSTRAINT public photo_tags_pkey batch
2086; 2606 17294 CONSTRAINT public photos_pkey batch
2088; 2606 17296 CONSTRAINT public roles_pkey batch
2092; 2606 17298 CONSTRAINT public social_connections_pkey batch
2094; 2606 17300 CONSTRAINT public user_avatars_pkey batch
2097; 2606 17302 CONSTRAINT public user_devices_pkey batch
2099; 2606 17304 CONSTRAINT public user_roles_pkey batch
2103; 2606 17306 CONSTRAINT public user_sessions_pkey batch
2106; 2606 17308 CONSTRAINT public users_pkey batch
2032; 1259 17309 INDEX public index_album_links_on_album_id batch
2033; 1259 17310 INDEX public index_album_links_on_token_and_album_id batch
2036; 1259 17311 INDEX public index_album_members_on_album_id batch
2037; 1259 17312 INDEX public index_album_members_on_type batch
2038; 1259 17313 INDEX public index_album_members_on_user_id_and_album_id batch
2041; 1259 17314 INDEX public index_album_photo_comments_on_album_id_and_photo_id batch
2042; 1259 17315 INDEX public index_album_photo_comments_on_uuid batch
2045; 1259 17316 INDEX public index_album_photo_likes_on_album_id_and_photo_id batch
2046; 1259 17317 INDEX public index_album_photo_likes_on_uuid batch
2049; 1259 17318 INDEX public index_album_photos_on_album_id_and_photo_id batch
2050; 1259 17319 INDEX public index_album_photos_on_photo_id batch
2053; 1259 17320 INDEX public index_album_share_tweets_on_album_id batch
2054; 1259 17392 INDEX public index_album_share_tweets_on_token batch
2057; 1259 17321 INDEX public index_albums_on_user_id batch
2058; 1259 17322 INDEX public index_albums_on_uuid batch
2061; 1259 17323 INDEX public index_email_notification_settings_on_user_id batch
2064; 1259 17324 INDEX public index_external_users_on_external_id_and_type batch
2065; 1259 17325 INDEX public index_external_users_on_user_id batch
2068; 1259 17326 INDEX public index_facebook_friends_on_user_id_and_friend_id batch
2113; 1259 17389 INDEX public index_facebook_links_on_album_id batch
2114; 1259 17391 INDEX public index_facebook_links_on_token batch
2115; 1259 17390 INDEX public index_facebook_links_on_user_id batch
2109; 1259 17379 INDEX public index_facebook_wall_posts_on_album_id batch
2110; 1259 17655 INDEX public index_facebook_wall_posts_on_token batch
2069; 1259 17328 INDEX public index_oauths_on_external_user_id_and_type batch
2072; 1259 17329 INDEX public index_photo_exifs_on_photo_id batch
2075; 1259 17330 INDEX public index_photo_metadata_on_photo_id batch
2078; 1259 17331 INDEX public index_photo_tags_on_album_id_and_photo_id batch
2079; 1259 17332 INDEX public index_photo_tags_on_photo_id batch
2080; 1259 17333 INDEX public index_photo_tags_on_uuid batch
2083; 1259 17334 INDEX public index_photos_on_user_id batch
2084; 1259 17335 INDEX public index_photos_on_uuid batch
2090; 1259 17336 INDEX public index_social_connections_on_user_id_and_source batch
2095; 1259 17337 INDEX public index_user_devices_on_user_id_and_udid batch
2100; 1259 17338 INDEX public index_user_sessions_on_oauth_token batch
2101; 1259 17339 INDEX public index_user_sessions_on_user_id batch
2104; 1259 17340 INDEX public index_users_on_uuid batch
2089; 1259 17341 INDEX public unique_schema_migrations batch