PDA

View Full Version : Pgsql General

  1. Seeking datacenter PITR backup suggestions
  2. More Time Zone fun
  3. FInding "corrupt" values in UTF-8 tables (regexp question, I think)
  4. Where are the Server error logs
  5. Accessing pg_timezone_names system view
  6. SELECT question
  7. tsearch2 query question
  8. Repeat posts
  9. Enterprise Wide Deployment
  10. Help creating a function
  11. Emigrar SqlServer a Posgres
  12. 8.3 performance
  13. Help with this query (some join stuff I think)
  14. Finding my database
  15. Some frustrations with admin tasks on PGSQL database
  16. Transaction auto-abort causes grief with Spring Framework
  17. Help creating a function
  18. Non-superuser creating a flat file
  19. Windows XP installation problem
  20. Problem Designing Index
  21. serial grows on failed requests
  22. Postmaster does not shut down
  23. CREATE RULE.. RETURNING?
  24. Vacuum problem
  25. Re: [BUGS] some information
  26. [RESEND] Transaction auto-abort causes grief with Spring Framework
  27. Strange inconsistency with UPDATE
  28. How to use Integer array in where IN clause parameter
  29. automatic rollback?
  30. Re: Running a stored procedure via pgagent, need an example
  31. I get a error msg when i try to connect to the DB
  32. Function with Integer array parameter
  33. Re: [SQL] Embedded C++ with ecpg?
  34. Accessing tables in other databases, through functions
  35. Performance question
  36. how to get id of currently executed query?
  37. array for cstring type
  38. INSERT before UPDATE?
  39. UTF-8 encoding problem
  40. PostgreSQL clustering (shared disk)
  41. Fastest way to import only ONE column into a table? (COPY doesn't work)
  42. =?EUC-KR?B?cGxlYXNlISBTUElfZmluaXNoIGlzIHN0cmFuZ2Ug?=
  43. Re: pg_dump on local Windows, pg_restore on Linux?
  44. SELECT ... FOR UPDATE performance costs? alternatives?
  45. User-Friendly TimeZone List
  46. pg_dump on local Windows, pg_restore on Linux?
  47. Customizing psql console to show execution times
  48. Yet Another COUNT(*)...WHERE...question
  49. Writing most code in Stored Procedures
  50. How to trap exceptions inside PL/Perl functions?
  51. Best practice for: ERROR: invalid byte sequence for encoding "UTF8"
  52. is this trigger safe and efective? - locking (caching via triiggers)
  53. check if database is correctly created
  54. memory optimization
  55. Custom functions for default values for columns on insert
  56. Transactional DDL
  57. language interface in postgresql
  58. Blobs in Postgresql
  59. query help
  60. Re: Select time jump after adding filter; please help mefigure out what I'm doing wrong.
  61. Compound Indexes
  62. Creating a row during a select
  63. MVCC cons
  64. Select time jump after adding filter; please help me figure out what I'm doing wrong.
  65. Using PITR Backup and Recovery
  66. Moving to postgresql and some ignorant questions
  67. Downloading PostgreSQL source code version 7.1 through CVS
  68. Insert or Replace or \copy (bulkload)
  69. PgAdmin .sql default handler
  70. Enterprise Wide Deployment
  71. Copy command and duplicate items (Support Replace?)
  72. Postgresql INSERT speed (how to improve performance)?
  73. How can I avoid PGPool as a single point of failure?
  74. Index not being used
  75. is there a psql equivilent of fsck?
  76. Running a stored procedure via pgagent, need an example
  77. can i use an array as a table (in the from clause)
  78. non superuser creating flat files
  79. Selecting rows where timestamp between two timestamps
  80. Problem Designing Index
  81. "Out of memory" errors..
  82. UDFs
  83. Persistent connections in PHP
  84. TimestampTZ
  85. copy command - date
  86. Performance check of my database
  87. Automation Using Databases.
  88. winxp failed installation problem
  89. pg_dumpall to psql -f NOT working
  90. why it doesn't work? referential integrity
  91. Trigger Procedure Error: NEW used in query that is not in a rule
  92. LIKE conditions in PGSQL very, very slow!
  93. SQL question: checking all required items
  94. PITR for postgresql-7.3
  95. Deadlocks caused by a foreign key constraint
  96. Re: UPDATES hang every 5 minutes
  97. CREATE RULE on VIEW with INSERT after UPDATE does not work
  98. Configuration starting point...
  99. Cluster and MVCC
  100. Re: UPDATES hang every 5 minutes
  101. [PROPOSAL] DML value format
  102. Database Select Slow
  103. Re: Allowing LAN connections
  104. Multiple operations on single rule, revisited
  105. Re: UPDATES hang every 5 minutes
  106. Re: [PERFORM] Dell Hardware Recommendations
  107. How I can know a back up database is up to date
  108. Connecting from one computer to another over lan
  109. Unable to connect to PostgreSQL server via PHP
  110. UPDATES hang every 5 minutes
  111. Installing Postgresql 8.2 on Windows Vista
  112. clustering failover... ala Oracle Parallel server
  113. Are these two creation commands functionally identical?
  114. Re: failed to unlink, Permission denied
  115. Confusing performance of specific query
  116. Bytea question with \208
  117. Re: failed to unlink, Permission denied
  118. timestamp skew during 7.4 -> 8.2 upgrade
  119. Time for Vacuum vs. Vacuum Full
  120. Interesting abilities of substring
  121. Multiple operations when updating a view - works in Postgres, doesn't in the app
  122. failed to unlink, Permission denied
  123. [JDBC] Restore database from zipped textfile (.sql) created by pg_dumpall
  124. Sylph Searcher
  125. Allowing LAN connections
  126. Crosstab Question
  127. Solved: Getting the field names for a given table
  128. Trigger not working as expected, first row gets a null value
  129. Running a query from the OS CLI
  130. Re: PostgreSQL and cluster
  131. Automation using postgres
  132. Interpreting statistics collector output
  133. Modified FIFO queue and insert rule
  134. Data Mart with Postgres
  135. PostgreSQL and cluster
  136. Installation problem
  137. Comment for column in view - "legal" or just working?
  138. track row / field usage
  139. Internal Postgre SQL documentation
  140. Reordering columns, will this ever be simple?
  141. Unsubscribe
  142. clustering failover... ala Oracle Parallel server
  143. List tables in load order
  144. Using function like where clause
  145. create table liek view
  146. Having trouble building 64-bit pgsql 7.4.17 on HPUX ia64
  147. tsearch2: plainto_tsquery() with OR?
  148. how to detect the backup database every day
  149. Removing a schema
  150. Intelligent Database in postgreSQL
  151. finding reusable ids
  152. finding out vacuum completion %, and vacuum VS vacuum full
  153. dbi and indexes
  154. more select-for-update questions
  155. 8.1.2 select for update issue
  156. Backup & Restore
  157. new line in psotgres
  158. Procedural Code Profiling
  159. Template zero xid issue
  160. Re: Postgres service startup
  161. Re: [PERFORM] Planner making wrong decisions 8.2.4. Insane cost calculations.
  162. Asynchronous Query processing
  163. Postgres service startup
  164. import content of XLS file into PostgreSQL
  165. Checkpoint segments too small
  166. Dealing with tsvector in fuctions for data split
  167. Modeling bill/ship addresses
  168. indexing large "text" attributes ... ERROR: maximum size is 8191
  169. Re: HA, failover and load balancing / howto?
  170. Changing column types
  171. pg_dump of only the structure from a client such as ruby
  172. Modelling tags
  173. Tablespace
  174. truncate transaction log
  175. PGSQL internals
  176. WAL Queries
  177. Re: backend process terminates
  178. clustering failover... ala Oracle Parallel server
  179. clustering failover... ala Oracle Parallel server
  180. v8.2 ... command line interface on Windows
  181. List tables in reverse dependancy order
  182. pg_restore UTF8 problem
  183. Help to solve configure error
  184. timezone + DST handling
  185. date ranges
  186. could not [extend relation|write block N of temporary file|write to hash-join temporary file]
  187. Safe usage of tsearch2: to_tsquery('<user input>')
  188. Select question..... is there a way to do this?
  189. virtual database
  190. Table queue (locking)
  191. pg_shdepend big
  192. Latin1 to UTF-8 ?
  193. invalid page header
  194. Suse RPM's
  195. Re: pgpool2 vs sequoia
  196. PG for DataWarehouse type Queries
  197. PostgreSQL Documentation on PalmOS
  198. Re: == PostgreSQL Weekly News - July 29 2007 ==
  199. ORDER BY on multiple columns still requires multi-col index?
  200. reindexing pg_shdepend
  201. want to drop corrupt db
  202. tsearch2 upgrade problem and mediawiki
  203. SQL function and "UPDATE...RETURNING"
  204. GiST index implementation
  205. pgTray - win32 tray tool for monitoring PostgreSQL service
  206. Error installing postgresql-8.2.4 on windows 2003 server
  207. Restrict access
  208. Re: pgpool2 vs sequoia
  209. Survey on changing a Free/Open Source Software project
  210. parsed queries (cursors) cashing issues
  211. python api to backup/restore data
  212. PGCluster-II version 1.3 , implementation
  213. file-system snapshot under freebsd for backup
  214. What do people like to monitor (or in other words, what might be nice in pgsnmpd)?
  215. why is the LIMIT clause slowing down this SELECT?
  216. Move database from Solaris to Windows
  217. how do i get num of recs inserted/deleted/updated in plpgsql
  218. Re: Linux distro
  219. Triggers: Detecting if a column value is explicitly set in an UPDATE statement or not... ("IS NULL" not working?)
  220. How do I connect postgres table structures and view structures to an existing svn repository?
  221. Linux distro
  222. Possible to Attach/Detach Tablespaces?
  223. Problem With gunzip backup
  224. Re: Core reported from vaccum function.
  225. array_to_set functions
  226. client encoding mismatch
  227. Re: Polymorphic functions' weird behavior
  228. continue in plpgsql 7.4
  229. FOREIGN KEY migration of syntax, help needed
  230. Indexing Hostnames with tsearch2 and fti.c
  231. Need quick help with standalone mode
  232. PG Admin
  233. huge file in pg_xlog and base
  234. Re: tables not in list
  235. Error restarting postmaster
  236. Re: tables not in list
  237. psql 8.2 client vs pg 8.1 server problem
  238. Polymorphic functions' weird behavior
  239. Performance problem with large resultsets (byte array 2200)
  240. Re: alter table table add column
  241. Manual Vaccum very slow with Autovaccum enabled
  242. Re: [NOVICE] alter table table add column
  243. Good News Mr 142.179.22.210 flood pgsql.general
  244. Good News Mr 142.179.22.210 flood pgsql.general
  245. pg_dump
  246. Auto Starting +/or Shutdown on OS X
  247. Stored Proc Problem
  248. plperl syntax highlighting for vi
  249. tables not in list
  250. Optimising SELECT on a table with one million rows