dblink死活装不上，各位大虾进来看看

zhaopingzi

1. 
   
2. [postgres@VM sql]$ psql -f ./dblink.sql pgpool
   
3. CREATE EXTENSION
   
4. CREATE TABLE
   
5. INSERT 0 1
   
6. INSERT 0 1
   
7. INSERT 0 1
   
8. INSERT 0 1
   
9. INSERT 0 1
   
10. INSERT 0 1
    
11. INSERT 0 1
    
12. INSERT 0 1
    
13. INSERT 0 1
    
14. INSERT 0 1
    
15. position | colname
    
16. ----------+---------
    
17.         1 | f1
    
18.         2 | f2
    
19. (2 rows)
    
20. 
    
21.                   dblink_build_sql_insert                  
    
22. -----------------------------------------------------------
    
23. INSERT INTO foo(f1,f2,f3) VALUES('99','xyz','{a0,b0,c0}')
    
24. (1 row)
    
25. 
    
26. psql:./dblink.sql:25: ERROR:  invalid attribute number 4
    
27.                                 dblink_build_sql_update                                 
    
28. ----------------------------------------------------------------------------------------
    
29. UPDATE foo SET f1 = '99', f2 = 'xyz', f3 = '{a0,b0,c0}' WHERE f1 = '99' AND f2 = 'xyz'
    
30. (1 row)
    
31. 
    
32. psql:./dblink.sql:31: ERROR:  invalid attribute number 4
    
33.            dblink_build_sql_delete           
    
34. ---------------------------------------------
    
35. DELETE FROM foo WHERE f1 = '0' AND f2 = 'a'
    
36. (1 row)
    
37. 
    
38. psql:./dblink.sql:36: ERROR:  invalid attribute number 4
    
39. CREATE SCHEMA
    
40. CREATE TABLE
    
41. INSERT 0 1
    
42. position | colname
    
43. ----------+---------
    
44.         1 | f1
    
45.         2 | f2
    
46. (2 rows)
    
47. 
    
48.                         dblink_build_sql_insert                        
    
49. ------------------------------------------------------------------------
    
50. INSERT INTO "MySchema"."Foo"(f1,f2,f3) VALUES('99','xyz','{a0,b0,c0}')
    
51. (1 row)
    
52. 
    
53.                                        dblink_build_sql_update                                       
    
54. -----------------------------------------------------------------------------------------------------
    
55. UPDATE "MySchema"."Foo" SET f1 = '99', f2 = 'xyz', f3 = '{a0,b0,c0}' WHERE f1 = '99' AND f2 = 'xyz'
    
56. (1 row)
    
57. 
    
58.                  dblink_build_sql_delete                  
    
59. ----------------------------------------------------------
    
60. DELETE FROM "MySchema"."Foo" WHERE f1 = '0' AND f2 = 'a'
    
61. (1 row)
    
62. 
    
63. psql:./dblink.sql:61: ERROR:  could not establish connection
    
64. DETAIL:  FATAL:  database "contrib_regression" does not exist
    
65. 
    
66. psql:./dblink.sql:66: ERROR:  connection not available
    
67. psql:./dblink.sql:69: ERROR:  could not establish connection
    
68. DETAIL:  FATAL:  database "contrib_regression" does not exist
    
69. 
    
70. psql:./dblink.sql:74: ERROR:  connection not available
    
71. psql:./dblink.sql:77: ERROR:  connection not available
    
72. psql:./dblink.sql:80: ERROR:  connection not available
    
73. psql:./dblink.sql:83: ERROR:  connection not available
    
74. psql:./dblink.sql:86: ERROR:  connection not available
    
75. psql:./dblink.sql:89: ERROR:  connection not available
    
76. psql:./dblink.sql:93: ERROR:  connection not available
    
77. psql:./dblink.sql:96: ERROR:  connection not available
    
78. psql:./dblink.sql:100: ERROR:  connection not available
    
79. psql:./dblink.sql:104: ERROR:  connection not available
    
80. psql:./dblink.sql:107: ERROR:  connection not available
    
81. psql:./dblink.sql:110: ERROR:  connection not available
    
82. psql:./dblink.sql:114: ERROR:  connection not available
    
83. psql:./dblink.sql:118: ERROR:  connection not available
    
84. psql:./dblink.sql:121: ERROR:  connection not available
    
85. psql:./dblink.sql:126: ERROR:  connection not available
    
86. psql:./dblink.sql:130: ERROR:  could not establish connection
    
87. DETAIL:  FATAL:  database "contrib_regression" does not exist
    
88. 
    
89. psql:./dblink.sql:133: ERROR:  could not establish connection
    
90. DETAIL:  FATAL:  database "contrib_regression" does not exist
    
91. 
    
92. psql:./dblink.sql:137: ERROR:  connection not available
    
93. psql:./dblink.sql:141: ERROR:  connection not available
    
94. psql:./dblink.sql:145: ERROR:  connection not available
    
95. psql:./dblink.sql:148: ERROR:  connection not available
    
96. psql:./dblink.sql:153: ERROR:  connection not available
    
97. psql:./dblink.sql:156: ERROR:  connection not available
    
98. psql:./dblink.sql:159: ERROR:  connection not available
    
99. psql:./dblink.sql:164: ERROR:  connection not available
    
100. psql:./dblink.sql:167: ERROR:  connection not available
     
101. psql:./dblink.sql:176: ERROR:  could not establish connection
     
102. DETAIL:  missing "=" after "myconn" in connection info string
     
103. 
     
104. psql:./dblink.sql:179: ERROR:  could not establish connection
     
105. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
106. 
     
107. psql:./dblink.sql:184: ERROR:  could not establish connection
     
108. DETAIL:  missing "=" after "myconn" in connection info string
     
109. 
     
110. psql:./dblink.sql:189: ERROR:  could not establish connection
     
111. DETAIL:  missing "=" after "myconn" in connection info string
     
112. 
     
113. psql:./dblink.sql:193: ERROR:  could not establish connection
     
114. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
115. 
     
116. psql:./dblink.sql:196: ERROR:  could not establish connection
     
117. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
118. 
     
119. psql:./dblink.sql:201: ERROR:  could not establish connection
     
120. DETAIL:  missing "=" after "myconn2" in connection info string
     
121. 
     
122. psql:./dblink.sql:204: ERROR:  connection "myconn2" not available
     
123. psql:./dblink.sql:207: ERROR:  connection "myconn" not available
     
124. psql:./dblink.sql:210: ERROR:  could not establish connection
     
125. DETAIL:  missing "=" after "myconn" in connection info string
     
126. 
     
127. psql:./dblink.sql:213: ERROR:  could not establish connection
     
128. DETAIL:  missing "=" after "myconn" in connection info string
     
129. 
     
130. psql:./dblink.sql:216: ERROR:  connection "myconn" not available
     
131. psql:./dblink.sql:219: ERROR:  connection "myconn" not available
     
132. psql:./dblink.sql:222: ERROR:  could not establish connection
     
133. DETAIL:  missing "=" after "myconn" in connection info string
     
134. 
     
135. psql:./dblink.sql:225: ERROR:  could not establish connection
     
136. DETAIL:  missing "=" after "myconn" in connection info string
     
137. 
     
138. psql:./dblink.sql:228: ERROR:  connection "myconn" not available
     
139. psql:./dblink.sql:231: ERROR:  connection "myconn" not available
     
140. psql:./dblink.sql:234: ERROR:  connection "myconn" not available
     
141. psql:./dblink.sql:237: ERROR:  could not establish connection
     
142. DETAIL:  missing "=" after "myconn" in connection info string
     
143. 
     
144. psql:./dblink.sql:240: ERROR:  connection "myconn" not available
     
145. psql:./dblink.sql:243: ERROR:  could not establish connection
     
146. DETAIL:  missing "=" after "myconn" in connection info string
     
147. 
     
148. psql:./dblink.sql:246: ERROR:  could not establish connection
     
149. DETAIL:  missing "=" after "myconn" in connection info string
     
150. 
     
151. psql:./dblink.sql:249: ERROR:  connection "myconn" not available
     
152. psql:./dblink.sql:253: ERROR:  connection "myconn" not available
     
153. psql:./dblink.sql:256: ERROR:  connection "myconn" not available
     
154. psql:./dblink.sql:260: ERROR:  connection "myconn" not available
     
155. psql:./dblink.sql:264: ERROR:  connection "myconn" not available
     
156. psql:./dblink.sql:267: ERROR:  could not establish connection
     
157. DETAIL:  missing "=" after "myconn" in connection info string
     
158. 
     
159. psql:./dblink.sql:271: ERROR:  connection "myconn" not available
     
160. psql:./dblink.sql:274: ERROR:  connection "myconn" not available
     
161. psql:./dblink.sql:279: ERROR:  could not establish connection
     
162. DETAIL:  missing "=" after "myconn" in connection info string
     
163. 
     
164. psql:./dblink.sql:282: ERROR:  could not establish connection
     
165. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
166. 
     
167. psql:./dblink.sql:286: ERROR:  could not establish connection
     
168. DETAIL:  missing "=" after "myconn" in connection info string
     
169. 
     
170. psql:./dblink.sql:290: ERROR:  could not establish connection
     
171. DETAIL:  missing "=" after "myconn" in connection info string
     
172. 
     
173. psql:./dblink.sql:293: ERROR:  could not establish connection
     
174. DETAIL:  missing "=" after "myconn" in connection info string
     
175. 
     
176. psql:./dblink.sql:298: ERROR:  could not establish connection
     
177. DETAIL:  missing "=" after "myconn" in connection info string
     
178. 
     
179. psql:./dblink.sql:301: ERROR:  could not establish connection
     
180. DETAIL:  missing "=" after "myconn" in connection info string
     
181. 
     
182. psql:./dblink.sql:306: ERROR:  could not establish connection
     
183. DETAIL:  missing "=" after "myconn" in connection info string
     
184. 
     
185. psql:./dblink.sql:309: ERROR:  connection "myconn" not available
     
186. psql:./dblink.sql:313: ERROR:  connection "myconn" not available
     
187. psql:./dblink.sql:316: ERROR:  could not establish connection
     
188. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
189. 
     
190. psql:./dblink.sql:318: ERROR:  connection "dtest1" not available
     
191. psql:./dblink.sql:320: ERROR:  could not establish connection
     
192. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
193. 
     
194. psql:./dblink.sql:322: ERROR:  connection "dtest2" not available
     
195. psql:./dblink.sql:324: ERROR:  could not establish connection
     
196. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
197. 
     
198. psql:./dblink.sql:326: ERROR:  connection "dtest3" not available
     
199. psql:./dblink.sql:334: ERROR:  connection "dtest1" not available
     
200. CREATE FUNCTION
     
201. unnest
     
202. --------
     
203. (0 rows)
     
204. 
     
205. psql:./dblink.sql:345: ERROR:  connection "dtest1" not available
     
206. psql:./dblink.sql:347: ERROR:  connection "dtest1" not available
     
207. psql:./dblink.sql:348: ERROR:  connection "dtest2" not available
     
208. psql:./dblink.sql:349: ERROR:  connection "dtest3" not available
     
209. psql:./dblink.sql:351: ERROR:  relation "result" does not exist
     
210. LINE 1: SELECT * from result;
     
211.                       ^
     
212. psql:./dblink.sql:353: ERROR:  could not establish connection
     
213. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
214. 
     
215. psql:./dblink.sql:355: ERROR:  connection "dtest1" not available
     
216. psql:./dblink.sql:357: ERROR:  connection "dtest1" not available
     
217. psql:./dblink.sql:358: ERROR:  connection "dtest1" not available
     
218. psql:./dblink.sql:359: ERROR:  connection "dtest1" not available
     
219. CREATE ROLE
     
220. CREATE SERVER
     
221. psql:./dblink.sql:366: ERROR:  invalid option "server"
     
222. HINT:  Valid options in this context are: user, password
     
223. CREATE USER MAPPING
     
224. GRANT
     
225. GRANT
     
226. You are now connected to database "pgpool" as user "dblink_regression_test".
     
227. psql:./dblink.sql:375: ERROR:  password is required
     
228. DETAIL:  Non-superusers must provide a password in the connection string.
     
229. psql:./dblink.sql:377: ERROR:  could not establish connection
     
230. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
231. 
     
232. psql:./dblink.sql:378: ERROR:  password is required
     
233. DETAIL:  Non-superusers must provide a password in the connection string.
     
234. You are now connected to database "pgpool" as user "postgres".
     
235. REVOKE
     
236. REVOKE
     
237. DROP ROLE
     
238. DROP USER MAPPING
     
239. DROP SERVER
     
240. psql:./dblink.sql:388: ERROR:  could not establish connection
     
241. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
242. 
     
243. psql:./dblink.sql:391: ERROR:  connection not available
     
244. psql:./dblink.sql:393: ERROR:  connection not available
     
245. psql:./dblink.sql:395: ERROR:  connection not available
     
246. psql:./dblink.sql:396: ERROR:  connection not available
     
247. notify_name | is_self_notify | extra
     
248. -------------+----------------+-------
     
249. (0 rows)
     
250. 
     
251. notify_name | be_pid | extra
     
252. -------------+--------+-------
     
253. (0 rows)
     
254. 
     
255. psql:./dblink.sql:402: ERROR:  connection not available
     
256. CREATE TABLE
     
257. INSERT 0 1
     
258. ALTER TABLE
     
259.                           dblink_build_sql_insert                          
     
260. ---------------------------------------------------------------------------
     
261. INSERT INTO test_dropped(id,col2b,col3,col4) VALUES('2','113','foo','42')
     
262. (1 row)
     
263. 
     
264.                                   dblink_build_sql_update                                 
     
265. -------------------------------------------------------------------------------------------
     
266. UPDATE test_dropped SET id = '2', col2b = '113', col3 = 'foo', col4 = '42' WHERE id = '2'
     
267. (1 row)
     
268. 
     
269.          dblink_build_sql_delete         
     
270. -----------------------------------------
     
271. DELETE FROM test_dropped WHERE id = '2'
     
272. (1 row)
     
273. 
     
274. SET
     
275. SET
     
276. SET
     
277. psql:./dblink.sql:434: ERROR:  could not establish connection
     
278. DETAIL:  FATAL:  database "contrib_regression" does not exist
     
279. 
     
280. psql:./dblink.sql:435: ERROR:  could not establish connection
     
281. DETAIL:  missing "=" after "myconn" in connection info string
     
282. 
     
283. psql:./dblink.sql:441: ERROR:  could not establish connection
     
284. DETAIL:  missing "=" after "myconn" in connection info string
     
285. 
     
286. psql:./dblink.sql:449: ERROR:  could not establish connection
     
287. DETAIL:  missing "=" after "myconn" in connection info string
     
288. 
     
289. psql:./dblink.sql:455: ERROR:  connection "myconn" not available
     
290. psql:./dblink.sql:459: ERROR:  connection "myconn" not available
     
291. psql:./dblink.sql:460: ERROR:  relation "result" does not exist
     
292. LINE 1: SELECT * FROM result;
     
293.                       ^
     
294. psql:./dblink.sql:461: ERROR:  table "result" does not exist
     
295. psql:./dblink.sql:468: ERROR:  connection "myconn" not available
     
296. psql:./dblink.sql:474: ERROR:  connection "myconn" not available
     
297. psql:./dblink.sql:475: ERROR:  relation "result" does not exist
     
298. LINE 1: SELECT * FROM result;
     
299.                       ^
     
300. psql:./dblink.sql:476: ERROR:  table "result" does not exist
     
301. psql:./dblink.sql:479: ERROR:  could not establish connection
     
302. DETAIL:  missing "=" after "myconn" in connection info string
     
303. 
     
304. psql:./dblink.sql:483: ERROR:  could not establish connection
     
305. DETAIL:  missing "=" after "myconn" in connection info string
     
306. 
     
307. CREATE TABLE
     
308. psql:./dblink.sql:489: ERROR:  could not establish connection
     
309. DETAIL:  missing "=" after "myconn" in connection info string
     
310. 
     
311. psql:./dblink.sql:494: ERROR:  could not establish connection
     
312. DETAIL:  missing "=" after "myconn" in connection info string
     
313. 
     
314. psql:./dblink.sql:496: ERROR:  could not establish connection
     
315. DETAIL:  missing "=" after "myconn" in connection info string
     
316. 
     
317. psql:./dblink.sql:501: ERROR:  could not establish connection
     
318. DETAIL:  missing "=" after "myconn" in connection info string
     
319. 
     
320. t
     
321. ---
     
322. (0 rows)
     
323. 
     
324. DROP TABLE
     
325. psql:./dblink.sql:509: ERROR:  connection "myconn" not available
     
326. psql:./dblink.sql:511: ERROR:  connection "myconn" not available
     
327. psql:./dblink.sql:513: ERROR:  connection "myconn" not available
     
328. DateStyle
     
329. -----------
     
330. ISO, MDY
     
331. (1 row)
     
332. 
     
333. IntervalStyle
     
334. ---------------
     
335. postgres
     
336. (1 row)
     
337. 
     
338. psql:./dblink.sql:521: ERROR:  connection "myconn" not available
     
339. RESET
     
340. RESET
     
341. RESET
     

复制代码

zhaopingzi

版本是psql9.3.0
可以

1. 
   
2. select dblink_connect('test_dblink','dbname=mytest host=127.0.0.1 port=5455 user=postgres');            
   
3. dblink_connect
   
4. ----------------
   
5. OK
   
6. (1 row)
   

复制代码

难道已经装好了？