PDA

View Full Version : Pgsql General

  1. Recover by Log
  2. warm standby examples.
  3. postgres startup method for ubuntu
  4. Log file permissions?
  5. Re: Is PostGreSql's Data storage mechanism "inferior"?
  6. Re: Oracle Analytical Functions
  7. Re: can't create index with 'dowcast' row
  8. unique constraint
  9. close connection
  10. Re: Disk configurations....
  11. Test User.
  12. Finding all columns (in all tables) with a value
  13. looking up foreign keys
  14. Delete from base table and not partitions
  15. Converting from MySQL...need book ideas
  16. Create a function that returns multiple columns
  17. postgres rule with where clause
  18. change the default data directory
  19. PostgreSQL/PHP Application Server
  20. can't create index with 'dowcast' row
  21. Installing PostGreSQL - 2
  22. PostgreSQL/PHP Application Server
  23. maximum amount of data to be written during checkpoint?
  24. check constraint question
  25. Re: pg_xlog and standby - SOLVED
  26. changing the default directory
  27. Getting all tables into memory
  28. [Fwd: Re: retry: converting ASCII to UTF-8]
  29. constraints in table
  30. PGCon vs Postgresql Conference
  31. retry: converting ASCII to UTF-8
  32. Best practices for protect applications agains Sql injection.
  33. ascii to utf-8
  34. Count
  35. Re: altering foreign keys
  36. Re: altering foreign keys
  37. CSV options in COPY
  38. Postgresql + digital signature
  39. Tips for upgrading from 7.4
  40. pg_xlog and standby
  41. Installing PGSQL
  42. create a limited user in Postgre
  43. Selecting max(pk) is slow on empty set
  44. Errors with run_build.pl - 8.3RC2
  45. Graphics
  46. Problem of capital case-insensitive letter with accent
  47. US Military / Government Approval
  48. Re: Problem of capital case-insensitive letter with accent
  49. publicar
  50. (un)grouping question
  51. PG-8.2 backup strategies
  52. Views and permissions
  53. Newbee to databases (ODBC)
  54. suggested wording improvement in psql
  55. setof record "out" syntax and returning records
  56. postgres 8.3 rc-1 ispell installation problem
  57. PostgreSQL terminated with "signal 66"
  58. Deadlock in Postgres 8.2
  59. Re: varchar sort ordering ignore blanks
  60. error
  61. Re: Registration for PostgreSQL Conference East now open
  62. Re: varchar sort ordering ignore blanks
  63. SHA1 on postgres 8.3
  64. example query for postgresql
  65. TSearch: CLUSTER using GIST, query using GIN?
  66. turning off notices
  67. PHP and Postgres arrays
  68. Default_with_oids
  69. 7.4.6 to 8.2.5 - ' changes to $_$
  70. =?iso-2022-jp?B?GyRCRk1BMyQ5JCQkXiQ7JHMiLSItGyhC?=
  71. Stupid question about WAL archiving
  72. WARNINGs after starting backup server created with PITR
  73. transactionid lock type?
  74. transactionid lock type?
  75. china wholesale nike jordan sneakers WWW.21cn-shoes.COM discountgucci prada puma
  76. Replication Using Triggers
  77. case dumbiness in return from functions
  78. [OT] Slony Triggers pulling down performance?
  79. Trouble with UTF-8 data
  80. postgres.org src build vs. enterprisedb installer
  81. postgresql source build instructions for ubuntu 7.04
  82. testing the news gateway
  83. plpythonu
  84. pg_dumpall
  85. postgresql 8.3rc1 on vista
  86. [OT] RAID controllers blocking one another?
  87. Can't make backup (again)
  88. losing db user password going from 7.4 to 8.2
  89. Don't cascade drop to view
  90. template0(or template1) is a database?
  91. Accessing composite type columns from C
  92. =?iso-2022-jp?B?GyRCRk1BMzw6TmkkJCQ/JDckXiQ5ISMbKEI=?=
  93. A few very basic questions about postgresql
  94. PL/pgsql function handle CUBE values
  95. SVN event hooks for PL/PGSQL functions and DDL?
  96. Snapshot warm standby
  97. Building 8.1.11 on FC4
  98. INSERT with a composite columnt from query
  99. Re: Search connections created per day
  100. varchar sort ordering ignore blanks
  101. libpq updateable resultset?
  102. Prepared statement's plan
  103. Help with pre-loaded arbitrary key sequences
  104. Sun acquires MySQL
  105. advocacy: drupal and PostgreSQL
  106. autovacuum vs. createdb
  107. bulk copy
  108. out of memory with INSERT INTO... SELECT...
  109. Clearing old user ids completely
  110. LIKE and REGEX optimization
  111. varchar sort ordering ignore blanks
  112. an simple way to get count of SQL statements per some interval
  113. Postgres installation on Leopard; database on Mac-User-Level
  114. Prepared statement's planning
  115. =?iso-2022-jp?B?GyRCQWpALSQsJCQkJD13QC0kSD1QMnEkKiQmISohKhsoQ g==?=
  116. insert into ... select ... and column order
  117. Segmentation fault with 8.3 FTS ISpell
  118. Re: ECPG problem with 8.3
  119. Members-choice award at LinuxQuestions.org
  120. Locking & concurrency - best practices
  121. COUNT() with ORDER BY
  122. Forgot to dump old data before re-installing machine
  123. ERROR: shared buffer hash table corrupted
  124. backup and restore
  125. query performance
  126. UPDATE .. JOIN?
  127. ERROR during WAL replay
  128. tsearch2 install on Fedora Core 5 problems
  129. Satisfactory Query Time
  130. What pg_restore does to a non-empty target database
  131. Re: How to safely compare transaction id?
  132. tcp_keepalives_idle ignored
  133. ECPG problem with 8.3
  134. know the schema name in a trigger
  135. Postgresql 8.2.4 on linux-sparc problem
  136. Analytic SQL Server - next generation analytic Data Warehouse with OLAP support
  137. oddly slow query
  138. phpPgAdmin-4.1.3 login fail
  139. How to safely compare transaction id?
  140. alter varchar() column length?
  141. Online Banking Alert
  142. Re: Online Oracle to Postgresql data migration
  143. Search connections created per day
  144. Online Oracle to Postgresql data migration
  145. Re: 8.3 Beta Incompatible Data Disaster
  146. How to query for a user-table column name?
  147. Pl/Java broken since Postgresql 8.3-rc1
  148. Re: 8.3beta bug or feature?
  149. 8.3beta bug or feature?
  150. ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
  151. After Installing a Program I get this error:
  152. Time stamp issue
  153. 8.3 Beta Incompatible Data Disaster
  154. Storing and querying boolean fields
  155. Importing PostgreSQL data from another database
  156. 8.2.4 serious slowdown
  157. Can I create a TYPE (or DOMAIN) with arguments?
  158. Format Float numbers
  159. Increase the number of concurrent connection
  160. Query to get column-names in table via PG tables?
  161. Storing and querying boolean fields
  162. vacuum, dead rows, usual solutions didn't help
  163. Kernel kills postgres process - help need
  164. postgres 8.3 release date and 2008-01-07 Cumulative Security UpdateRelease
  165. Postgres and MySQL Rosetta stone??
  166. Prepared Statements
  167. Re: Insert waiting for update?
  168. quick question abt pg_dump and restore
  169. Installation problem: failed to initialize lc_messages to ""
  170. data transfer/migrate from win to linux
  171. Insert waiting for update?
  172. Startup scripts - Use -m fast or smart?
  173. performance differences of major versions
  174. (NONE)
  175. PgSql Mirroring/Fail Over Server
  176. Read/Write restriction mechanism
  177. WHERE vs ORDER BY vs LIMIT why not using the correct index?
  178. benchmarking update/insert and random record update
  179. XML path function
  180. Experiences with extensibility
  181. large objects,was: Restoring 8.0 db to 8.1
  182. Best way to fix Error: could not access status of transaction?
  183. need to dump/restore data for 8.3beta2 -> 8.3RC1 upgrade?
  184. =?iso-8859-1?Q?RE=3A_=5BGENERAL=5D_Problema_al_cargar_pol=EDg onos?=
  185. Re: need to dump/restore data for 8.3beta2 -> 8.3RC1 upgrade?
  186. Can a stored procedure that creates a temp table be declared STABLE?
  187. XML and Routing
  188. postgres dump cores
  189. Column limitation?
  190. Announcing PostgreSQL RPM Yum Repository
  191. Re: PhpBB 3.x query review
  192. Announcing PostgreSQL RPM Buildfarm
  193. many to one of many modeling question
  194. DB2 tutorial
  195. Looking for freelancer in Switzerland
  196. advisory locks: documentation hint and feature request
  197. Can a stored procedure that creates a temp table be declared STABLE?
  198. File system level backup from 32bit to 64bit
  199. WAL Sequence
  200. PhpBB 3.x query review
  201. calculating shared data memory space
  202. =?iso-2022-jp?B?GyRCJDMkcyRKSlEkSk02JCRKfSRiJEokJCRIO1ckJCReJ DkkMSRJGyhC?=
  203. Insert returning Npgsql
  204. Server doesn't seem to be listening...
  205. Index trouble with 8.3b4
  206. Memory on 32bit machine
  207. 8.3-beta4, analyze and db owner
  208. PostgreSQL - XML
  209. Setting variables equal to elements from an Array
  210. Need efficient way to do comparison with NULL as an option
  211. Create Index (Hash) on a Large Table Taking Days...
  212. Cannot connect to PgPool
  213. data volume resizing and large objects
  214. postgres 8.3 betat 1 version download
  215. Problem with pg_dump?
  216. Getting process id of a connection?
  217. Suggest Index
  218. large table vacuum issues
  219. Concurrent modification of plpgsql function body
  220. deadlock priority?
  221. Performance problem. Could it be related to 8.3-beta4?
  222. Fail to connect after server crash
  223. Hash Indexes
  224. Re: Mandatory AS keyword in SELECT statements
  225. [OT] Slony (initial) Replication - Slow
  226. Connect to SQL Server via ODBC from Postgresql
  227. Mandatory AS keyword in SELECT statements
  228. ERROR: catalog is missing 9 attribute(s) for relid 10297
  229. TCL
  230. CentOS-5 PostgreSQL 8.1.9 server instrumentation
  231. negative duration times in query logs
  232. SQLSTATE code for duplicate constraint
  233. server process (PID 27884) was terminated by signal 4 (SIGILL)
  234. Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?
  235. implicit vs. explicit RETURN when OUT is used
  236. Re: visibility rules for AFTER UPDATE Constraint Triggers Function
  237. Re: [SQL] PG is in different timezone than the OS
  238. PITR - filter by database?
  239. C-Extenions for PostgreSQL, Call Convention Version 0
  240. array as arguments of pg functions and php
  241. Re: Table auditing / Pg/tcl help
  242. [OT] Slony (initial) Replication - Slow
  243. Feature request: NOTIFY enhancement
  244. Using syslog on pg for Windows
  245. Table auditing / Pg/tcl help
  246. Re: [HACKERS] Slow count(*)
  247. tablefunc and crosstab
  248. Creating XML/KML documents from single tables
  249. M`I 5-Pers ecution - their metho ds and tact ics
  250. visibility rules for AFTER UPDATE Constraint Triggers Function