473,320 Members | 2,035 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

New database creation takes about 60 seconds when >400 bases in PostgreSQL

Hello, everyone.

We have met a problem recently: CREATE DATABASE query takes up to 60-70 seconds.

This happens when the total number of databases exceeds the number of 400. And the more databases we add the bigger is the execution time of this command.

What can be the problem?

I doubt that PostgreSQL has a limitation of 400 DB per server and if more, it slows one query down (only CREATE DATABASE query gets slow).

The PostgreSQL server configuration file is default. So I think there is no need to inserted it here.

PS: no additional services(like replication etc.) are running. The PostgreSQL server CPU/RAM usage is not even close to 30% then the database is being created so it is not the reason.
The number of active connections has nothing to do with it too because the same behaviour can be reproduced on local server with the same configuration and databases number.

Please help.
Thank you.
Nov 11 '10 #1
2 2963
rski
700 Expert 512MB
What system do you use?
If linux/unix you can check what tooks so long using strace option like that
Expand|Select|Wrap|Line Numbers
  1. strace -ttt createdb <base name>
  2.  
or
Expand|Select|Wrap|Line Numbers
  1. strace -ttt psql -c "CREATE DATABASE <base name>"
  2.  
Can you put here the result of that strace command.

If you use windows, I don't know any such tool (like strace) for windows, but it must be some.
Nov 14 '10 #2
Here is the strace output.

Expand|Select|Wrap|Line Numbers
  1. 1289808932.840528 execve("/usr/bin/createdb", ["createdb", "-U", "ptm", "-p", "5433", "-h", "127.0.0.1", "speed2"], [/* 22 vars */]) = 0
  2. 1289808932.841098 brk(0)                = 0x191a4000
  3. 1289808932.841163 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15826d000
  4. 1289808932.841224 uname({sys="Linux", node="*******.com", ...}) = 0
  5. 1289808932.841320 readlink("/proc/self/exe", "/home/PostgreSQL/bin/createdb"..., 4096) = 29
  6. 1289808932.841405 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
  7. 1289808932.841474 open("/home/PostgreSQL/bin/../lib/tls/x86_64/libpq.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
  8. 1289808932.841540 stat("/home/PostgreSQL/bin/../lib/tls/x86_64", 0x7fff80903720) = -1 ENOENT (No such file or directory)
  9. 1289808932.841598 open("/home/PostgreSQL/bin/../lib/tls/libpq.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
  10. 1289808932.841645 stat("/home/PostgreSQL/bin/../lib/tls", 0x7fff80903720) = -1 ENOENT (No such file or directory)
  11. 1289808932.841690 open("/home/PostgreSQL/bin/../lib/x86_64/libpq.so.5", O_RDONLY) = -1 ENOENT (No such file or directory)
  12. 1289808932.841787 stat("/home/PostgreSQL/bin/../lib/x86_64", 0x7fff80903720) = -1 ENOENT (No such file or directory)
  13. 1289808932.841962 open("/home/PostgreSQL/bin/../lib/libpq.so.5", O_RDONLY) = 3
  14. 1289808932.842031 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220~\0\0\0\0\0\0"..., 832) = 832
  15. 1289808932.842096 fstat(3, {st_mode=S_IFREG|0755, st_size=168575, ...}) = 0
  16. 1289808932.842161 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15826e000
  17. 1289808932.842208 mmap(NULL, 1191696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2ae15826f000
  18. 1289808932.842249 mprotect(0x2ae158290000, 1048576, PROT_NONE) = 0
  19. 1289808932.842296 mmap(0x2ae158390000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x21000) = 0x2ae158390000
  20. 1289808932.842363 close(3)              = 0
  21. 1289808932.842417 open("/home/PostgreSQL/bin/../lib/libxslt.so.1", O_RDONLY) = 3
  22. 1289808932.842467 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\236\0\0\0\0\0\0"..., 832) = 832
  23. 1289808932.842522 fstat(3, {st_mode=S_IFREG|0755, st_size=806996, ...}) = 0
  24. 1289808932.842581 mmap(NULL, 1274128, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2ae158392000
  25. 1289808932.842627 mprotect(0x2ae1583c8000, 1048576, PROT_NONE) = 0
  26. 1289808932.842685 mmap(0x2ae1584c8000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x36000) = 0x2ae1584c8000
  27. 1289808932.842946 close(3)              = 0
  28. 1289808932.842990 open("/home/PostgreSQL/bin/../lib/libxml2.so.2", O_RDONLY) = 3
  29. 1289808932.843039 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\261\2\0\0\0\0\0"..., 832) = 832
  30. 1289808932.843093 fstat(3, {st_mode=S_IFREG|0755, st_size=4115398, ...}) = 0
  31. 1289808932.843156 mmap(NULL, 2352216, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2ae1584ca000
  32. 1289808932.843215 mprotect(0x2ae1585ff000, 1044480, PROT_NONE) = 0
  33. 1289808932.843263 mmap(0x2ae1586fe000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x134000) = 0x2ae1586fe000
  34. 1289808932.843314 mmap(0x2ae158707000, 5208, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x2ae158707000
  35. 1289808932.843361 close(3)              = 0
  36. 1289808932.843403 open("/home/PostgreSQL/bin/../lib/libpam.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  37. 1289808932.843461 open("/etc/ld.so.cache", O_RDONLY) = 3
  38. 1289808932.843521 fstat(3, {st_mode=S_IFREG|0644, st_size=42853, ...}) = 0
  39. 1289808932.843586 mmap(NULL, 42853, PROT_READ, MAP_PRIVATE, 3, 0) = 0x2ae158709000
  40. 1289808932.843625 close(3)              = 0
  41. 1289808932.843670 open("/lib64/libpam.so.0", O_RDONLY) = 3
  42. 1289808932.843719 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\300$ \27:\0\0\0"..., 832) = 832
  43. 1289808932.843950 fstat(3, {st_mode=S_IFREG|0755, st_size=46800, ...}) = 0
  44. 1289808932.844027 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158714000
  45. 1289808932.844081 mmap(0x3a17200000, 2140040, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a17200000
  46. 1289808932.844138 mprotect(0x3a1720b000, 2093056, PROT_NONE) = 0
  47. 1289808932.844181 mmap(0x3a1740a000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa000) = 0x3a1740a000
  48. 1289808932.844228 close(3)              = 0
  49. 1289808932.844276 open("/home/PostgreSQL/bin/../lib/libssl.so.4", O_RDONLY) = 3
  50. 1289808932.844342 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\343\320\1=\0\0\0"..., 832) = 832
  51. 1289808932.844402 fstat(3, {st_mode=S_IFREG|0755, st_size=244288, ...}) = 0
  52. 1289808932.844461 mmap(0x3d01d00000, 1291880, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3d01d00000
  53. 1289808932.844503 mprotect(0x3d01d36000, 1048576, PROT_NONE) = 0
  54. 1289808932.844545 mmap(0x3d01e36000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x36000) = 0x3d01e36000
  55. 1289808932.844602 mmap(0x3d01e3b000, 1640, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3d01e3b000
  56. 1289808932.844664 close(3)              = 0
  57. 1289808932.844714 open("/home/PostgreSQL/bin/../lib/libcrypto.so.4", O_RDONLY) = 3
  58. 1289808932.844934 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\311\244\1=\0\0\0"..., 832) = 832
  59. 1289808932.844988 fstat(3, {st_mode=S_IFREG|0755, st_size=1234328, ...}) = 0
  60. 1289808932.845048 mmap(0x3d01a00000, 2295992, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3d01a00000
  61. 1289808932.845094 mprotect(0x3d01b0f000, 1048576, PROT_NONE) = 0
  62. 1289808932.845155 mmap(0x3d01c0f000, 122880, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x10f000) = 0x3d01c0f000
  63. 1289808932.845212 mmap(0x3d01c2d000, 14520, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3d01c2d000
  64. 1289808932.845255 close(3)              = 0
  65. 1289808932.845298 open("/home/PostgreSQL/bin/../lib/libkrb5.so.3", O_RDONLY) = -1 ENOENT (No such file or directory)
  66. 1289808932.845352 open("/usr/lib64/libkrb5.so.3", O_RDONLY) = 3
  67. 1289808932.845406 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\221\241\30:\0\0\0"..., 832) = 832
  68. 1289808932.845478 fstat(3, {st_mode=S_IFREG|0755, st_size=613896, ...}) = 0
  69. 1289808932.845542 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158715000
  70. 1289808932.845589 mmap(0x3a18a00000, 2706624, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a18a00000
  71. 1289808932.845630 mprotect(0x3a18a91000, 2097152, PROT_NONE) = 0
  72. 1289808932.845673 mmap(0x3a18c91000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x91000) = 0x3a18c91000
  73. 1289808932.845785 close(3)              = 0
  74. 1289808932.845976 open("/home/PostgreSQL/bin/../lib/libz.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  75. 1289808932.846037 open("/usr/lib64/libz.so.1", O_RDONLY) = 3
  76. 1289808932.846087 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\36\340\24:\0\0\0"..., 832) = 832
  77. 1289808932.846140 fstat(3, {st_mode=S_IFREG|0755, st_size=85608, ...}) = 0
  78. 1289808932.846199 mmap(0x3a14e00000, 2178600, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a14e00000
  79. 1289808932.846248 mprotect(0x3a14e14000, 2093056, PROT_NONE) = 0
  80. 1289808932.846309 mmap(0x3a15013000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x13000) = 0x3a15013000
  81. 1289808932.846363 close(3)              = 0
  82. 1289808932.846407 open("/home/PostgreSQL/bin/../lib/libreadline.so.4", O_RDONLY) = 3
  83. 1289808932.846458 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`'al=\0\0\0"..., 832) = 832
  84. 1289808932.846510 fstat(3, {st_mode=S_IFREG|0755, st_size=229816, ...}) = 0
  85. 1289808932.846573 mmap(0x3d6c600000, 1278864, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3d6c600000
  86. 1289808932.846633 mprotect(0x3d6c630000, 1048576, PROT_NONE) = 0
  87. 1289808932.846681 mmap(0x3d6c730000, 32768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x30000) = 0x3d6c730000
  88. 1289808932.846945 mmap(0x3d6c738000, 912, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3d6c738000
  89. 1289808932.846990 close(3)              = 0
  90. 1289808932.847042 open("/home/PostgreSQL/bin/../lib/libtermcap.so.2", O_RDONLY) = 3
  91. 1289808932.847101 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240\20\340m=\0\0\0"..., 832) = 832
  92. 1289808932.847173 fstat(3, {st_mode=S_IFREG|0755, st_size=15728, ...}) = 0
  93. 1289808932.847232 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158716000
  94. 1289808932.847278 mmap(0x3d6de00000, 1060400, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3d6de00000
  95. 1289808932.847319 mprotect(0x3d6de03000, 1044480, PROT_NONE) = 0
  96. 1289808932.847361 mmap(0x3d6df02000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3d6df02000
  97. 1289808932.847416 close(3)              = 0
  98. 1289808932.847476 open("/home/PostgreSQL/bin/../lib/libcrypt.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  99. 1289808932.847532 open("/lib64/libcrypt.so.1", O_RDONLY) = 3
  100. 1289808932.847582 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360\t\240\25:\0\0\0"..., 832) = 832
  101. 1289808932.847635 fstat(3, {st_mode=S_IFREG|0755, st_size=48600, ...}) = 0
  102. 1289808932.847695 mmap(0x3a15a00000, 2322880, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a15a00000
  103. 1289808932.847945 mprotect(0x3a15a09000, 2093056, PROT_NONE) = 0
  104. 1289808932.848007 mmap(0x3a15c08000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x8000) = 0x3a15c08000
  105. 1289808932.848060 mmap(0x3a15c0a000, 184768, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a15c0a000
  106. 1289808932.848105 close(3)              = 0
  107. 1289808932.848148 open("/home/PostgreSQL/bin/../lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  108. 1289808932.848203 open("/lib64/libdl.so.2", O_RDONLY) = 3
  109. 1289808932.848260 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\16`\23:\0\0\0"..., 832) = 832
  110. 1289808932.848331 fstat(3, {st_mode=S_IFREG|0755, st_size=23360, ...}) = 0
  111. 1289808932.848391 mmap(0x3a13600000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a13600000
  112. 1289808932.848432 mprotect(0x3a13602000, 2097152, PROT_NONE) = 0
  113. 1289808932.848475 mmap(0x3a13802000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3a13802000
  114. 1289808932.848526 close(3)              = 0
  115. 1289808932.848577 open("/home/PostgreSQL/bin/../lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  116. 1289808932.848648 open("/lib64/libm.so.6", O_RDONLY) = 3
  117. 1289808932.848696 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`>\340\23:\0\0\0"..., 832) = 832
  118. 1289808932.848792 fstat(3, {st_mode=S_IFREG|0755, st_size=615136, ...}) = 0
  119. 1289808932.849005 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158717000
  120. 1289808932.849053 mmap(0x3a13e00000, 2629848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a13e00000
  121. 1289808932.849102 mprotect(0x3a13e82000, 2093056, PROT_NONE) = 0
  122. 1289808932.849164 mmap(0x3a14081000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x81000) = 0x3a14081000
  123. 1289808932.849213 close(3)              = 0
  124. 1289808932.849259 open("/home/PostgreSQL/bin/../lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  125. 1289808932.849311 open("/lib64/libc.so.6", O_RDONLY) = 3
  126. 1289808932.849356 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\332!\23:\0\0\0"..., 832) = 832
  127. 1289808932.849414 fstat(3, {st_mode=S_IFREG|0755, st_size=1717800, ...}) = 0
  128. 1289808932.849494 mmap(0x3a13200000, 3498328, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a13200000
  129. 1289808932.849536 mprotect(0x3a1334d000, 2097152, PROT_NONE) = 0
  130. 1289808932.849578 mmap(0x3a1354d000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14d000) = 0x3a1354d000
  131. 1289808932.849630 mmap(0x3a13552000, 16728, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a13552000
  132. 1289808932.849674 close(3)              = 0
  133. 1289808932.849791 open("/home/PostgreSQL/bin/../lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  134. 1289808932.849994 open("/home/PostgreSQL/bin/../lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  135. 1289808932.850062 open("/lib64/libpthread.so.0", O_RDONLY) = 3
  136. 1289808932.850109 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240W\240\23:\0\0\0"..., 832) = 832
  137. 1289808932.850163 fstat(3, {st_mode=S_IFREG|0755, st_size=145824, ...}) = 0
  138. 1289808932.850223 mmap(0x3a13a00000, 2204528, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a13a00000
  139. 1289808932.850269 mprotect(0x3a13a16000, 2093056, PROT_NONE) = 0
  140. 1289808932.850329 mmap(0x3a13c15000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x3a13c15000
  141. 1289808932.850387 mmap(0x3a13c17000, 13168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a13c17000
  142. 1289808932.850432 close(3)              = 0
  143. 1289808932.850484 open("/home/PostgreSQL/bin/../lib/libaudit.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  144. 1289808932.850538 open("/lib64/libaudit.so.0", O_RDONLY) = 3
  145. 1289808932.850588 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340&`\26:\0\0\0"..., 832) = 832
  146. 1289808932.850658 fstat(3, {st_mode=S_IFREG|0755, st_size=107112, ...}) = 0
  147. 1289808932.850722 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158718000
  148. 1289808932.850946 mmap(0x3a16600000, 2200080, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a16600000
  149. 1289808932.850987 mprotect(0x3a16619000, 2093056, PROT_NONE) = 0
  150. 1289808932.851030 mmap(0x3a16818000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x18000) = 0x3a16818000
  151. 1289808932.851082 close(3)              = 0
  152. 1289808932.851147 open("/home/PostgreSQL/bin/../lib/libgssapi_krb5.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  153. 1289808932.851208 open("/usr/lib64/libgssapi_krb5.so.2", O_RDONLY) = 3
  154. 1289808932.851258 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\222 \26:\0\0\0"..., 832) = 832
  155. 1289808932.851310 fstat(3, {st_mode=S_IFREG|0755, st_size=190976, ...}) = 0
  156. 1289808932.851404 mmap(0x3a16200000, 2283888, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a16200000
  157. 1289808932.851504 mprotect(0x3a1622c000, 2097152, PROT_NONE) = 0
  158. 1289808932.851565 mmap(0x3a1642c000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2c000) = 0x3a1642c000
  159. 1289808932.851621 close(3)              = 0
  160. 1289808932.851667 open("/home/PostgreSQL/bin/../lib/libcom_err.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  161. 1289808932.851720 open("/lib64/libcom_err.so.2", O_RDONLY) = 3
  162. 1289808932.851942 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\320\n\240\27:\0\0\0"..., 832) = 832
  163. 1289808932.852003 fstat(3, {st_mode=S_IFREG|0755, st_size=10000, ...}) = 0
  164. 1289808932.852082 mmap(0x3a17a00000, 2103048, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a17a00000
  165. 1289808932.852124 mprotect(0x3a17a02000, 2093056, PROT_NONE) = 0
  166. 1289808932.852166 mmap(0x3a17c01000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x3a17c01000
  167. 1289808932.852214 close(3)              = 0
  168. 1289808932.852258 open("/home/PostgreSQL/bin/../lib/libk5crypto.so.3", O_RDONLY) = -1 ENOENT (No such file or directory)
  169. 1289808932.852319 open("/usr/lib64/libk5crypto.so.3", O_RDONLY) = 3
  170. 1289808932.852385 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260V\340\30:\0\0\0"..., 832) = 832
  171. 1289808932.852438 fstat(3, {st_mode=S_IFREG|0755, st_size=153464, ...}) = 0
  172. 1289808932.852498 mmap(0x3a18e00000, 2247272, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a18e00000
  173. 1289808932.852539 mprotect(0x3a18e24000, 2093056, PROT_NONE) = 0
  174. 1289808932.852581 mmap(0x3a19023000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x23000) = 0x3a19023000
  175. 1289808932.852639 close(3)              = 0
  176. 1289808932.852713 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158719000
  177. 1289808932.853073 open("/home/PostgreSQL/bin/../lib/libkrb5support.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  178. 1289808932.853178 open("/usr/lib64/libkrb5support.so.0", O_RDONLY) = 3
  179. 1289808932.853241 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200\"`\31:\0\0\0"..., 832) = 832
  180. 1289808932.853295 fstat(3, {st_mode=S_IFREG|0755, st_size=35728, ...}) = 0
  181. 1289808932.853363 mmap(0x3a19600000, 2128592, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a19600000
  182. 1289808932.853424 mprotect(0x3a19608000, 2093056, PROT_NONE) = 0
  183. 1289808932.853467 mmap(0x3a19807000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x7000) = 0x3a19807000
  184. 1289808932.853515 close(3)              = 0
  185. 1289808932.853561 open("/home/PostgreSQL/bin/../lib/libkeyutils.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  186. 1289808932.853615 open("/lib64/libkeyutils.so.1", O_RDONLY) = 3
  187. 1289808932.853673 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\n\240\26:\0\0\0"..., 832) = 832
  188. 1289808932.853961 fstat(3, {st_mode=S_IFREG|0755, st_size=9472, ...}) = 0
  189. 1289808932.854022 mmap(0x3a16a00000, 2102416, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a16a00000
  190. 1289808932.854064 mprotect(0x3a16a02000, 2093056, PROT_NONE) = 0
  191. 1289808932.854107 mmap(0x3a16c01000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x3a16c01000
  192. 1289808932.854155 close(3)              = 0
  193. 1289808932.854211 open("/home/PostgreSQL/bin/../lib/libresolv.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  194. 1289808932.854280 open("/lib64/libresolv.so.2", O_RDONLY) = 3
  195. 1289808932.854329 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\2402`\27:\0\0\0"..., 832) = 832
  196. 1289808932.854381 fstat(3, {st_mode=S_IFREG|0755, st_size=92736, ...}) = 0
  197. 1289808932.854441 mmap(0x3a17600000, 2181864, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a17600000
  198. 1289808932.854483 mprotect(0x3a17611000, 2097152, PROT_NONE) = 0
  199. 1289808932.854536 mmap(0x3a17811000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x11000) = 0x3a17811000
  200. 1289808932.854604 mmap(0x3a17813000, 6888, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a17813000
  201. 1289808932.854648 close(3)              = 0
  202. 1289808932.854699 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15871a000
  203. 1289808932.854964 open("/home/PostgreSQL/bin/../lib/libselinux.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  204. 1289808932.855018 open("/lib64/libselinux.so.1", O_RDONLY) = 3
  205. 1289808932.855073 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`E \24:\0\0\0"..., 832) = 832
  206. 1289808932.855141 fstat(3, {st_mode=S_IFREG|0755, st_size=95464, ...}) = 0
  207. 1289808932.855201 mmap(0x3a14200000, 2192784, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a14200000
  208. 1289808932.855243 mprotect(0x3a14215000, 2097152, PROT_NONE) = 0
  209. 1289808932.855286 mmap(0x3a14415000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x3a14415000
  210. 1289808932.855337 mmap(0x3a14417000, 1424, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a14417000
  211. 1289808932.855393 close(3)              = 0
  212. 1289808932.855460 open("/home/PostgreSQL/bin/../lib/libsepol.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  213. 1289808932.855514 open("/lib64/libsepol.so.1", O_RDONLY) = 3
  214. 1289808932.855559 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0=`\24:\0\0\0"..., 832) = 832
  215. 1289808932.855610 fstat(3, {st_mode=S_IFREG|0755, st_size=247496, ...}) = 0
  216. 1289808932.855670 mmap(0x3a14600000, 2383136, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a14600000
  217. 1289808932.855785 mprotect(0x3a1463b000, 2097152, PROT_NONE) = 0
  218. 1289808932.855966 mmap(0x3a1483b000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x3b000) = 0x3a1483b000
  219. 1289808932.856024 mmap(0x3a1483c000, 40224, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a1483c000
  220. 1289808932.856066 close(3)              = 0
  221. 1289808932.856133 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15871b000
  222. 1289808932.856219 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15871c000
  223. 1289808932.856277 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15871d000
  224. 1289808932.856339 arch_prctl(ARCH_SET_FS, 0x2ae15871ca30) = 0
  225. 1289808932.856521 mprotect(0x3a17811000, 4096, PROT_READ) = 0
  226. 1289808932.856961 mprotect(0x3a13c15000, 4096, PROT_READ) = 0
  227. 1289808932.857162 mprotect(0x3a1354d000, 16384, PROT_READ) = 0
  228. 1289808932.857228 mprotect(0x3a14081000, 4096, PROT_READ) = 0
  229. 1289808932.857306 mprotect(0x3a13802000, 4096, PROT_READ) = 0
  230. 1289808932.857380 mprotect(0x3a15c08000, 4096, PROT_READ) = 0
  231. 1289808932.858244 mprotect(0x3a1301b000, 4096, PROT_READ) = 0
  232. 1289808932.858289 munmap(0x2ae158709000, 42853) = 0
  233. 1289808932.858335 set_tid_address(0x2ae15871cac0) = 14273
  234. 1289808932.858375 set_robust_list(0x2ae15871cad0, 0x18) = 0
  235. 1289808932.858423 futex(0x7fff8090424c, FUTEX_WAKE_PRIVATE, 1) = 0
  236. 1289808932.858484 rt_sigaction(SIGRTMIN, {0x3a13a05380, [], SA_RESTORER|SA_SIGINFO, 0x3a13a0e930}, NULL, 8) = 0
  237. 1289808932.858541 rt_sigaction(SIGRT_1, {0x3a13a052b0, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3a13a0e930}, NULL, 8) = 0
  238. 1289808932.858589 rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
  239. 1289808932.858639 getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=RLIM_INFINITY}) = 0
  240. 1289808932.858795 access("/etc/selinux/", F_OK) = 0
  241. 1289808932.859044 brk(0)                = 0x191a4000
  242. 1289808932.859089 brk(0x191c5000)       = 0x191c5000
  243. 1289808932.859142 open("/etc/selinux/config", O_RDONLY) = 3
  244. 1289808932.859204 fstat(3, {st_mode=S_IFREG|0644, st_size=511, ...}) = 0
  245. 1289808932.859267 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158709000
  246. 1289808932.859312 read(3, "# This file controls the state o"..., 4096) = 511
  247. 1289808932.859404 read(3, "", 4096)     = 0
  248. 1289808932.859458 close(3)              = 0
  249. 1289808932.859501 munmap(0x2ae158709000, 4096) = 0
  250. 1289808932.859581 open("/proc/mounts", O_RDONLY) = 3
  251. 1289808932.859659 fstat(3, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
  252. 1289808932.859788 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae158709000
  253. 1289808932.859961 read(3, "rootfs / rootfs rw 0 0\n/dev/root"..., 4096) = 701
  254. 1289808932.860060 read(3, "", 4096)     = 0
  255. 1289808932.860104 close(3)              = 0
  256. 1289808932.860141 munmap(0x2ae158709000, 4096) = 0
  257. 1289808932.860268 open("/usr/lib/locale/locale-archive", O_RDONLY) = 3
  258. 1289808932.860321 fstat(3, {st_mode=S_IFREG|0644, st_size=56422016, ...}) = 0
  259. 1289808932.860391 mmap(NULL, 56422016, PROT_READ, MAP_PRIVATE, 3, 0) = 0x2ae15871e000
  260. 1289808932.860446 close(3)              = 0
  261. 1289808932.860525 getcwd("/home/pgsql-9.0.1/data"..., 1024) = 23
  262. 1289808932.860586 stat("/usr/kerberos/sbin/createdb", 0x7fff80902c70) = -1 ENOENT (No such file or directory)
  263. 1289808932.860636 stat("/usr/kerberos/bin/createdb", 0x7fff80902c70) = -1 ENOENT (No such file or directory)
  264. 1289808932.860686 stat("/usr/local/sbin/createdb", 0x7fff80902c70) = -1 ENOENT (No such file or directory)
  265. 1289808932.860797 stat("/usr/local/bin/createdb", 0x7fff80902c70) = -1 ENOENT (No such file or directory)
  266. 1289808932.860964 stat("/sbin/createdb", 0x7fff80902c70) = -1 ENOENT (No such file or directory)
  267. 1289808932.861013 stat("/bin/createdb", 0x7fff80902c70) = -1 ENOENT (No such file or directory)
  268. 1289808932.861056 stat("/usr/sbin/createdb", 0x7fff80902c70) = -1 ENOENT (No such file or directory)
  269. 1289808932.861101 stat("/usr/bin/createdb", {st_mode=S_IFREG|0755, st_size=54882, ...}) = 0
  270. 1289808932.861174 geteuid()             = 0
  271. 1289808932.861220 getcwd("/home/pgsql-9.0.1/data"..., 1024) = 23
  272. 1289808932.861272 chdir("/usr/bin")     = 0
  273. 1289808932.861323 lstat("createdb", {st_mode=S_IFLNK|0777, st_size=29, ...}) = 0
  274. 1289808932.861389 readlink("createdb", "/home/PostgreSQL/bin/createdb"..., 1024) = 29
  275. 1289808932.861439 chdir("/home/PostgreSQL/bin") = 0
  276. 1289808932.861483 lstat("createdb", {st_mode=S_IFREG|0755, st_size=54882, ...}) = 0
  277. 1289808932.861553 getcwd("/home/PostgreSQL/bin"..., 1024) = 21
  278. 1289808932.861602 chdir("/home/pgsql-9.0.1/data") = 0
  279. 1289808932.861789 geteuid()             = 0
  280. 1289808932.861978 socket(PF_FILE, SOCK_STREAM, 0) = 3
  281. 1289808932.862029 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
  282. 1289808932.862071 connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
  283. 1289808932.862148 close(3)              = 0
  284. 1289808932.862196 socket(PF_FILE, SOCK_STREAM, 0) = 3
  285. 1289808932.862241 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
  286. 1289808932.862277 connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
  287. 1289808932.862338 close(3)              = 0
  288. 1289808932.862390 open("/etc/nsswitch.conf", O_RDONLY) = 3
  289. 1289808932.862445 fstat(3, {st_mode=S_IFREG|0644, st_size=1696, ...}) = 0
  290. 1289808932.862511 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15bced000
  291. 1289808932.862559 read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1696
  292. 1289808932.862638 read(3, "", 4096)     = 0
  293. 1289808932.862676 close(3)              = 0
  294. 1289808932.862715 munmap(0x2ae15bced000, 4096) = 0
  295. 1289808932.862958 open("/home/PostgreSQL/bin/../lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  296. 1289808932.863020 open("/etc/ld.so.cache", O_RDONLY) = 3
  297. 1289808932.863068 fstat(3, {st_mode=S_IFREG|0644, st_size=42853, ...}) = 0
  298. 1289808932.863127 mmap(NULL, 42853, PROT_READ, MAP_PRIVATE, 3, 0) = 0x2ae15bced000
  299. 1289808932.863166 close(3)              = 0
  300. 1289808932.863216 open("/lib64/libnss_files.so.2", O_RDONLY) = 3
  301. 1289808932.863274 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\37\0\0\0\0\0\0"..., 832) = 832
  302. 1289808932.863336 fstat(3, {st_mode=S_IFREG|0755, st_size=53880, ...}) = 0
  303. 1289808932.863407 mmap(NULL, 2139432, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2ae15bcf8000
  304. 1289808932.863450 mprotect(0x2ae15bd02000, 2093056, PROT_NONE) = 0
  305. 1289808932.863495 mmap(0x2ae15bf01000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x2ae15bf01000
  306. 1289808932.863552 close(3)              = 0
  307. 1289808932.863631 mprotect(0x2ae15bf01000, 4096, PROT_READ) = 0
  308. 1289808932.863685 munmap(0x2ae15bced000, 42853) = 0
  309. 1289808932.863939 open("/etc/passwd", O_RDONLY) = 3
  310. 1289808932.863995 fcntl(3, F_GETFD)     = 0
  311. 1289808932.864033 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
  312. 1289808932.864077 fstat(3, {st_mode=S_IFREG|0644, st_size=1934, ...}) = 0
  313. 1289808932.864151 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15bced000
  314. 1289808932.864202 read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1934
  315. 1289808932.864267 close(3)              = 0
  316. 1289808932.864304 munmap(0x2ae15bced000, 4096) = 0
  317. 1289808932.864366 geteuid()             = 0
  318. 1289808932.864410 open("/etc/passwd", O_RDONLY) = 3
  319. 1289808932.864469 fcntl(3, F_GETFD)     = 0
  320. 1289808932.864514 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
  321. 1289808932.864550 fstat(3, {st_mode=S_IFREG|0644, st_size=1934, ...}) = 0
  322. 1289808932.864609 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2ae15bced000
  323. 1289808932.864650 read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1934
  324. 1289808932.864703 close(3)              = 0
  325. 1289808932.864950 munmap(0x2ae15bced000, 4096) = 0
  326. 1289808932.865008 stat("/root/.pgpass", 0x7fff80903c30) = -1 ENOENT (No such file or directory)
  327. 1289808932.865086 socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3
  328. 1289808932.865140 setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
  329. 1289808932.865189 fcntl(3, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
  330. 1289808932.865230 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
  331. 1289808932.865286 connect(3, {sa_family=AF_INET, sin_port=htons(5433), sin_addr=inet_addr("127.0.0.1")}, 16) = -1 EINPROGRESS (Operation now in progress)
  332. 1289808932.865467 poll([{fd=3, events=POLLOUT|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLOUT}])
  333. 1289808932.865524 getsockopt(3, SOL_SOCKET, SO_ERROR, [17179869184], [4]) = 0
  334. 1289808932.865574 getsockname(3, {sa_family=AF_INET, sin_port=htons(41334), sin_addr=inet_addr("127.0.0.1")}, [16]) = 0
  335. 1289808932.865633 poll([{fd=3, events=POLLOUT|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLOUT}])
  336. 1289808932.865699 rt_sigprocmask(SIG_BLOCK, [PIPE], [], 8) = 0
  337. 1289808932.865962 sendto(3, "\0\0\0\10\4\322\26/", 8, 0, NULL, 0) = 8
  338. 1289808932.866084 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
  339. 1289808932.866125 poll([{fd=3, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
  340. 1289808932.866176 recvfrom(3, "N", 16384, 0, NULL, NULL) = 1
  341. 1289808932.866222 poll([{fd=3, events=POLLOUT|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLOUT}])
  342. 1289808932.866280 rt_sigprocmask(SIG_BLOCK, [PIPE], [], 8) = 0
  343. 1289808932.866342 sendto(3, "\0\0\0&\0\3\0\0user\0ptm\0database\0post"..., 38, 0, NULL, 0) = 38
  344. 1289808932.866462 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
  345. 1289808932.866503 poll([{fd=3, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
  346. 1289808932.868617 recvfrom(3, "R\0\0\0\10\0\0\0\0S\0\0\0\26application_name\0\0"..., 16384, 0, NULL, NULL) = 317
  347. 1289808932.868794 rt_sigprocmask(SIG_BLOCK, [PIPE], [], 8) = 0
  348. 1289808932.868977 sendto(3, "Q\0\0\0\35CREATE DATABASE speed2;\n\0", 30, 0, NULL, 0) = 30
  349. 1289808932.869096 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
  350. 1289808932.869137 poll([{fd=3, events=POLLIN|POLLERR}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
  351. 1289808970.642297 recvfrom(3, "C\0\0\0\24CREATE DATABASE\0Z\0\0\0\5I", 16384, 0, NULL, NULL) = 27
  352. 1289808970.642409 rt_sigprocmask(SIG_BLOCK, [PIPE], [], 8) = 0
  353. 1289808970.642467 sendto(3, "X\0\0\0\4", 5, 0, NULL, 0) = 5
  354. 1289808970.642526 rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
  355. 1289808970.642571 close(3)              = 0
  356. 1289808970.642863 exit_group(0)         = ?
  357.  
  358.  
Nov 15 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: KumarForG | last post by:
Hi, is there a way , other than using EMS PostGreSql Extract to export a PostGreSql datatbase ( table structures,data , functions , triggers etc... ) to sql. i tried EMS PostGreSql Extract ,...
2
by: Eugeny Balakhonov | last post by:
Hello, all! I have a good question for PostgreSQL FAQ. How to use string functions (like UPPER()/LOWER()) for non-latin strings? Why UPPER() function doesn't work with my UNICODE PostgreSQL...
4
by: KG | last post by:
I'm getting the following error message when I try to create a user or database on postgresql 7.2.2 on Freebsd 4.7, I installed it from the ports directory but I'm stumped when I got the following...
33
by: Joshua D. Drake | last post by:
Hello, I think the below just about says it all: http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg Sincerely, Joshua Drake
3
by: Domagoj Cajic | last post by:
First i want to say that i just subscribed to this mailing list and this is my first post. :) im new to postgresql and i installed it recently on linux redhat 9 system following the instructions...
74
by: John Wells | last post by:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either...
3
by: Christian Enklaar | last post by:
Hello, we are using a table with a primary key of type varchar. If we try to find entries with select * from <table> where <table.key> = '<text>'; entries with a key length of more than 32...
12
by: Ben | last post by:
If I have have the table: create table foo ( a int references bar(id), b int references baz(id) ) .... how do I make sure one and only one of the columns a and b are non-null? Is it even...
5
by: Marijn | last post by:
Hello everybody, I am new to PHP and working on extending my knowledge of OOP. The posts in this group concerned with whether or not to use an OO approach when programming in PHP is not what I...
2
by: Sam | last post by:
Recently started using DB_DataObject with a Postgresql DB. Seems pretty nice, but I am not sure if insert() is supposed to be able to return the id of a recently returned object. It just seems to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.