Re: [GENERAL] Oracle to PostgreSQL transition?

that worked with both Oracle and MSSQL into Postgres reliably; but really it shouldn't be too difficult; basically just ETL or some home brew replication scripting to glue things together. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

to verify all of this; if not you maybe you can set up some replication between old/new servers (we use mimeo for that when sever versions are this far apart) and point your app to both and see what happens. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general

Re: [GENERAL] Default timezone changes in 9.1

elsewhere too). It makes me wonder if there was enough thought put into the backwards compatibility angle of this; either what the default should be, or to make sure people were aware of the change. Robert Treat play: xzilla.net work: omniti.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] PG 9.0 EBS Snapshot Backups on Slave

/trunk/tools/zbackup.sh [2] https://github.com/omniti-labs/omnipitr Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] General performance/load issue

, but how what type, how many, and in what configuration? Also how is Postgres set up on top of the disks (all of $PGDATA and OS on one volume? Split up?) Also, how many active connections do you typically have? Can you reduce your sort mem to something like 4MB, and set log_temp_files to 0? Robert

Re: [GENERAL] General performance/load issue

is probably too high. 50 (connections) x 128 (mb work mem) x 2 (sorts per query) = 12GB RAM, which is 25% of total ram on the box. That doesn't necessarily mean game over, but it seem like it wouldn't be that hard to get thrashing being set up that way. YMMV. Robert Treat conjecture: xzilla.net

Re: [GENERAL] pg_standby for postgresql8.2

that feature. Robert Treat play: xzilla.net work: omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] synchronous replication + fsync=off?

environment are rare (which hopefully they should be). Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] autovacuum stuck on a table for 18+ hours, consuming lots of CPU time

), and you'll likely see this again in the future. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Is this safe to perform on PostgreSQL 8.3.7 - Resize a column in a PostgreSQL table without changing data

of length that are long enough that they probably indicate garbage data or something gone wrong. In a world where Postgres actually handled this problem gracefully (and I think 9.1 does), I don't think this rule is as clear cut as it used to be. Robert Treat conjecture: xzilla.net consulting

Re: [GENERAL] wal archiving on a hot-standby server

destination. Which method you want depends on the version / setup of postgres you have, and whether you want the slave to be in the chain of the replica site. (I probably wouldn't, which would make me lean towards something like omnipitr) Robert Treat conjecture: xzilla.net consulting: omniti.com

Re: [GENERAL] upgrading from 8.3 to 9.0

/9.1/interactive/release-8-4.html#AEN111313 http://www.postgresql.org/docs/9.1/interactive/release-8-3.html#AEN114593 Robert Treat conjecture: xzilla.net consulting: omniti.com On Thu, Nov 17, 2011 at 8:14 PM, David Morton davidmor...@xtra.co.nz wrote: I've performed a very similar upgrade

Re: [GENERAL] Incremental backup with RSYNC or something?

off to the backup server and used to reconstruct the server if needed. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] SIGNALNAME in pg_ctl kill

If you are trying to kill one specific connection/backend, I'd recommend using the pg_terminate_backend(pid_goes_here) function. Robert Treat conjecture: xzilla.net consulting: omniti.com On Wed, Nov 9, 2011 at 5:18 PM, Mike Blackwell mike.blackw...@rrd.com wrote: The manual section

Re: [GENERAL] Masquerading a unique index as a primary key in 8.4?

out or even know. Agreed. I'd be more inclined to change londiste, or just ditch it for something else that will recognize the unique index as a unique enough identifier to enable replication. That limitation is kind of lame. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via

Re: [GENERAL] Why is there no 8.3.16 rpm with _id ?

2011/11/3 Devrim GÜNDÜZ dev...@gunduz.org: On Wed, 2011-11-02 at 13:16 -0400, Robert Treat wrote: Hey Devrim, any chance you have published your rpm spec files you used on the earlier 8.3 -id builds? I looked around and couldn't find one. They were in the previous repo -- anyway, I just

Re: [GENERAL] Recommendations for SSDs in production?

testing and production use (for ourselves and our clients) seem to be Intel (mostly 320 series iirc), and Fusion-IO. I'd start with looking at those. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] FATAL: password authentication failed for user postgres

disable-triggers -U postgres -h 127.0.0.1 -p 5432 -f ./test.backup Does pgadmin also connect via 127.0.0.1? What happens if you dump via the local socket? Also, do you get an error for pg_dump, or does it just prompt for a password that it wont accept what you submit? Robert Treat conjecture

Re: [GENERAL] Server move using rsync

shipping in place. When you're ready to move, you shutdown the old database, synch up the xlogs, and then failover to the new database. Not only should this be faster, it seems less error prone, and you can actually test the failover and lunch bits while the original server is up and running. Robert

Re: [GENERAL] Why is there no 8.3.16 rpm with _id ?

packages quite easily, though. Hey Devrim, any chance you have published your rpm spec files you used on the earlier 8.3 -id builds? I looked around and couldn't find one. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4

Can you go into some more detail on how you set up ZFS on these systems? Robert Treat conjecture: xzilla.net consulting: omniti.com On Tue, Sep 13, 2011 at 10:56 PM, Andy Colson a...@squeakycode.net wrote: On 09/13/2011 08:15 PM, Toby Corkindale wrote: Hi, Some months ago, I ran some

Re: [GENERAL] md5 of table

psql (9.0.4, server 9.1beta3) WARNING: psql version 9.0, server version 9.1. Some psql features might not work. Type help for help. pagila=# select * from actor order by actor_id; f381ebdefe0aada9c0bc14e657962c1f Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via

Re: [GENERAL] SSDs with Postgresql?

traffic'd servers, and the performance has been good, and durability there when needed. It's certainly worth checking out for those investigating these options. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] SSDs with Postgresql?

-d8869e7c1668/OnxdZG Couldn't decide on exactly where to go from there. That's graphing MB/sec, which does map easily in my mind, since xlogs streams are in 16mb bursts. It would make more sense for wal streaming though (but in that case we'd probably want to measure it more precisely). Robert Treat

Re: [GENERAL] PG on two nodes with shared disk ocfs2 drbd

be worth pointing people to Postgres-XC (http://wiki.postgresql.org/wiki/Postgres-XC). It's got a ways to go, but they are at least trying. Robert Treat play: xzilla.net work: omniti.com hiring: l42.org/Lg -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Question about switchover with PG9 replication

worked on, and switchover is something on the list, but it's not an option yet. Robert Treat play: xzilla.net work: omniti.com hiring: l42.org/Lg -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

to either set a matching alias, or fix the table name qualifier in those order by columns. Robert Treat play: xzilla.net work: l42.org/lg

Re: [GENERAL] Why facebook used mysql ?

oriented companies, very few are looking for 32+ core systems as a solution to their problems. Robert Treat play: http://www.xzilla.net work: http://www.omniti.com/is/hiring

Re: [GENERAL] REINDEX requirement?

), but usually good enough to highlight the problems. See http://labs.omniti.com/labs/pgtreats/log/trunk/tools/pg_bloat_report.pl Robert Treat play: http://www.xzilla.net work: http://www.omniti.com/is/hiring

[GENERAL] Looking for PostgreSQL Folks in New Orleans area

Howdy folks, We're looking for some PostgreSQL users / advocates in the New Orleans area for some community outreach activities, like PGDays and User Groups. If you are in that area and interested in helping, or know who to talk to, please drop me a line, thanks! Robert Treat play: http

[GENERAL] Postgres officially accepted in to 2010 Google Summer of Code program

interesting year with GSoC, and hoping you'll join in. -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Volunteers needed to help staff the PostgreSQL Booth at LISA 2009

Wednesday (November 4th, Noon - 7PM) and half day Thursday (November 5th, 10AM-2PM). You get a Postgres T-shirt for your trouble, and the opportunity to talk with lots of people interested in getting started with Postgres. Please reply to this email if you've got some time. Thanks! -- Robert

Re: [GENERAL] Are there performance advantages in storing bulky field in separate table?

On Wednesday 08 April 2009 18:25:25 Ron Mayer wrote: Robert Treat wrote: You can be sure that discussion of this topic in this forum will soon be visited by religious zealots, but the short answer is nulls are bad, mmkay. A slightly longer answer would be that, as a general rule

Re: [GENERAL] Are there performance advantages in storing bulky field in separate table?

in this column, personally, I'd put it in a separate table. -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Are there performance advantages in storing bulky field in separate table?

On Wednesday 08 April 2009 15:30:28 Ian Mayo wrote: On Wed, Apr 8, 2009 at 8:13 PM, Robert Treat xzi...@users.sourceforge.net wrote: Maybe I've been reading too much Pascal again lately, but if only 1% of your rows are going to have data in this column, personally, I'd put

Re: [GENERAL] PostgreSQL on Webmin

/Tuning_Your_PostgreSQL_Server Once you go through that and restart, if it's still slow, can you paste explain analyze from the two different servers? -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] audit table

tables for each audited table, each of which looks like this: CREATE TABLE audit_tablename ( old_row tablename; ) INHERITS audit; http://pgfoundry.org/projects/tablelog/ -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing

Re: [GENERAL] Database schema data synchronizer software for PostgreSQL?

problems, they do exist: http://pgdiff.sourceforge.net/ http://apgdiff.sourceforge.net/ http://www.dbsolo.com/ http://sqlmanager.net/en/products/postgresql/dbcomparer there are others too... -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql

Re: [GENERAL] Is this on the to-do list?

contact_last_name = x.last_name, set contact_first_name = x.first_name FROM (select last_name, first_name from salesmen where salesmen.id = accounts.sales_id) x Which is great if you just want to get this done, but sucks if you wanted the specific syntax from above. -- Robert Treat Conjecture

Re: [GENERAL] Solution for tranaction independent logging in same database?

point to adapt it). HTH -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Tool to converter plsql in pgplsql

* :-) There are still a number of shortcomings, so depending on how large and/or complicated your systems are, it may or may not work for you, but it's certainly worth a look if you're planning a migration. -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql

Re: [GENERAL] Ubuntu for servers (was TurnKey PostgreSQL)

for folks is to switch to another operating system thats a bit more stable *cough*solaris*cough*bsd*cough* :-) -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Favorite Tom Lane quotes

thread. Mine is (roughly): http://archives.postgresql.org/pgsql-hackers/2006-04/msg00288.php I remember after reading this post wondering whether Tom uses caffeinated soap... -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing

Re: [GENERAL] Job scheduling in Postgre

that it might follow autovacuums path and get moved into a contrib module and possibly integrated into the backend some day, but I haven't seen much push in that direction. -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Switch off PITR

up, but should be doable) -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Limit on number of databases in a Cluster ?

connections to all databases when you think about how high you can set these. Don't forget some of these settings (like work_mem) can be set per database using the ALTER DATABASE command, just be careful becuase the support for backing up those changes is spotty at best. -- Robert Treat

Re: [GENERAL] In memory Database for postgres

on hdd, if you lose the system catalogs, the right answer is initdb -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] speed up restore from dump

. -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions

we need? Is it possible to give the master/slave knowledge about each other? -- Robert Treat Conjecture: http://www.xzilla.net Consulting: http://www.omniti.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] [HACKERS] Hot Standby utility and administrator functions

On Monday 27 October 2008 12:12:18 Simon Riggs wrote: On Mon, 2008-10-27 at 11:42 -0400, Robert Treat wrote: On Monday 20 October 2008 05:25:29 Simon Riggs wrote: I'm looking to implement the following functions for Hot Standby, to allow those with administrative tools or management

Re: [GENERAL] How to free disk space

. -- Emanuel Calvo Franco Syscope Postgresql DBA BaPUG Member -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Drop database / database in use question

, and restart normally. -- Robert Treat http://www.omniti.com Database: Scalability: Consulting -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Column level triggers

it into the last commitfest; after that you're probably looking at 8.5. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] how to remove the duplicate records from a table

will be nice and compacted, and wont get any more duplicate rows. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Slony vs Longiste

to pick from those two. However, given the requirements you laid out, PITR is probably your best option (this is what Richard alluded too), and certainly the one I would recommend you try first. -- Robert Treat http://www.omniti.com/ Database: Scalability: Consulting -- Sent via pgsql-general

Re: [GENERAL] 8.3.3 stability ?

you do the actual upgrade. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Fastest way to restore a database

, with multiple database in a cluster, you dont want to disable it for all databases, though it'd be nice to disable it for the one you're restoring) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] pg_restore parameters

need that flag? If you do you might want to think about factoring that out of your design, if not then verify you need the -b flag too. As a final though, if you're already going through the pain of a dump/restore, I'd suggest looking at upgrading to 8.3 during the process. -- Robert Treat

Re: [GENERAL] Restore filesystem backup

the files on disk correctly. Otherwise you might be forced to try and get some filesystem level tools going, but I'm not sure how feasible that is on windows, especially on such an old version. Good luck. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent

Re: [GENERAL] about partitioning

the omniti site, but I've uploaded it to slideshare... http://www.slideshare.net/xzilla/postgresql-partitioning-pgcon-2007-presentation HTH. -- Robert Treat http://www.omniti.com Database: Scalability: Consulting: -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Fastest way to restore a database

on this topic: http://people.planetpostgresql.org/xzilla/index.php?/archives/133-Getting-faster-database-restores-on-postgresql-8.1.html http://people.planetpostgresql.org/xzilla/index.php?/archives/223-Measuring-database-restore-times.html A little old, but might be helpful. -- Robert Treat http

Re: [GENERAL] Install Postgres on a SAN volume?

of a simple snapshot backup tool, available at http://people.planetpostgresql.org/xzilla/index.php?/archives/344-ossdb-snapshot,-lvm-database-snapshot-tool.html And yes, I prefer working on the zfs based one :-) -- Robert Treat http://www.omniti.com Database: Scalability: Consulting: -- Sent via

Re: [GENERAL] PostgreSQL TPC-H test result?

before on postgres. In the end, I can't speak to what the issues are wrt monet and postgres and thier tpc-h benchmarks, but personally I don't think they are worth worring about. -- Robert Treat http://www.omniti.com Database: Scalability: Consulting: -- Sent via pgsql-general mailing

Re: [GENERAL] Oracle and Postgresql

On Wednesday 03 September 2008 09:17:54 Asko Oja wrote: On Wed, Sep 3, 2008 at 5:56 AM, Robert Treat [EMAIL PROTECTED]wrote: On Tuesday 02 September 2008 17:21:12 Asko Oja wrote: On Tue, Sep 2, 2008 at 2:09 AM, Michael Nolan [EMAIL PROTECTED] wrote: Oracle handles connecting

Re: [GENERAL] Oracle and Postgresql

-installed, is simple to set-up, and has a much more straight-forward syntax for use in day to day query work. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] New to postgres -' how to' tips needed

your OS and version information. HTH :-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] mailing list/newsgroup disconnect

and not to me personally). Is there someone I should mention this to or does he already know? Problems like this should be reported to [EMAIL PROTECTED] It would likely be helpful to include emails with full header information, though the folks there can tell you what they need. -- Robert Treat Build

Re: [GENERAL] [EMAIL PROTECTED]

Hiroshi-san, Is this something specific to windows? If so, should this be consider a bug? Robert Treat On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote: Hi. Sorry, it was not included in release. please see, http://winpg.jp/~saito/pg_work/OSSP_win32/ Regards, Hiroshi Saito Hi

Re: [GENERAL] Using PostGres general distribution

in that scenario. (The other problem spots is server upgrades, but you can probably go years on a particular version before that becomes really problematic, it just depends on what your applications lifecycle looks like) -- Robert Treat Database Architect http://www.omniti.com -- Sent via pgsql

Re: [GENERAL] Must be table owner to truncate?

. Just fyi, there is a patch for 8.4 that will add truncate permissions. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] [pgsql-advocacy] [pdxpug] Pg booth staffing at OSCON

to pay are way in. I can't imagine how you could have taken Josh's post to be anything but courteous and respectful, but I do encourage you to join us at the BOF where we can settle it once and for all sumo suits anyone? http://www.maineventweb.com/page/page/2916926.htm -- Robert Treat

Re: [GENERAL] limits?

/index.php?/archives/37-The-million-table-challenge.html -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Losing data

missing. Out of curiosity, what is your vacuum strategy? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Alias in the HAVING clause

allow alias in having in this instance? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_standby / WAL archive-restore through system restarts

as they are processed, any shutdown will likely cause you to have to start the whole thing over again. Note pg_standby and 8.3 give some pretty convenient tools to manage this. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] PG -v- MySQL

). It's an understandably difficult issue to work around, since ever storage engine you use means that you're basically learning the intricacies of a separate database, so it doesn't surprise me that things end up a little schizophrenic at times. -- Robert Treat Build A Brighter LAMP :: Linux

Re: [GENERAL] Is this possible in a trigger?

and ctid of the row involved, and then grabbing the info from the system tables. Certainly easier to do it in plperl though. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] How to modify ENUM datatypes?

On Thursday 01 May 2008 01:30, Greg Smith wrote: On Wed, 30 Apr 2008, Robert Treat wrote: Whenever anyone posts a problem on 7.3, the first thing people do now days is jump up and down waving thier arms about while exclaiming how quickly they should upgrade. While I am certain

Re: [GENERAL] How to modify ENUM datatypes?

On Wednesday 30 April 2008 11:00, Craig Ringer wrote: Robert Treat wrote: If one were to have built something on postgresql 5 years ago, they would have had to do it on 7.3. Whenever anyone posts a problem on 7.3, the first thing people do now days is jump up and down waving thier arms

Re: [GENERAL] How to modify ENUM datatypes?

On Thursday 01 May 2008 13:40, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: And again, if you do the math, any install before 2008-11-17 would have been on 7.3, which is less than 5 years. I'm not sure how you're doing the math, but my copy of the release notes dates 7.3 as 2002

Re: [GENERAL] How to modify ENUM datatypes?

On Monday 28 April 2008 10:28, Andrew Sullivan wrote: On Sat, Apr 26, 2008 at 08:33:28PM -0400, Robert Treat wrote: enum types custom ordering. It also showcases the idea of data definitions that should never change, but that do changes every half dozen years or so. Now you can argue

Re: [GENERAL] How to modify ENUM datatypes?

On Monday 28 April 2008 17:35, Jeff Davis wrote: On Sat, 2008-04-26 at 20:33 -0400, Robert Treat wrote: I think one of the best examples of this is the movie rating system (which I blogged about at http://people.planetpostgresql.org/xzilla/index.php?/archives/320-Postgre SQL-8.3-Features

Re: [GENERAL] How to modify ENUM datatypes?

expect thier database software to last. :-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to modify ENUM datatypes?

). I was gonna say ! :-) Add hermaphrodite transgender with female phenotype transgender with male phenotype and you should be set from current medical science's point of view ;-) The standard is unknown, male, female, and n/a. -- Robert Treat Build A Brighter LAMP :: Linux Apache

Re: [GENERAL] Column order

. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pgcrypto and dblink

/contrib.html, but your right they don't seem to be mentioned anywhere in the install section. I'm not sure where it should go, but perhaps making it 15.6.1 and bumping the other items down a notch. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql

Re: [GENERAL] Re: Survey: renaming/removing script binaries (createdb, createuser...)

nice, as it isn't). I have to think that a better solution for someone whose needs are met by the above is to just enable autovacuum. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Postgresql partitioning

a function to manage it which is probably better on a larger number of partitions) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Postgres development

be very useful, depending on cost, I may be able to arrange for funds to cover this development. I'd suggest tracking down Neil Conway, and maybe David Fetter. I know Neil has been playing with something similar for 8.4, and David has been pestering him about it pretty steady. -- Robert Treat

Re: [GENERAL] Trigger to run @ connection time?

out completly, and single user mode can be the fall back for that if needed. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] postgresql book - practical or something newer?

needs to expand to get publishers on board, not authors. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] end of life for pg versions...

to http://www.postgresql.org/developer/roadmap. Of course we would still need to add an EOL page... I think one could make a strong argument for a static url for EOL info now that windows is EOL for 8.2. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: [GENERAL] TSearch2 Migration Guide from 8.2 to 8.3

latest svn, which has native 8.3 fts support for postgres, and then do an xml dump/import of the wiki contents. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Is PG a moving target?

-compatible casting would break new 8.3 system expectations. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

would have wanted planet.perl.org anyway (though that doesn't show up either) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [GENERAL] Performance problems with Postgresql/ZFS/Non-global zones on Solaris?

by initdb. Don't even bother trying to tune zfs untill after you've tuned postgres, otherwise your wasting your time. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 9: In versions below

Re: [GENERAL] postgresql book - practical or something newer?

and what not. In PG, all there is, is the manual, a book by Robert Treat, the Book from Joshua, 1 or 2 other books authored by someone I can't remember etc and that's about it. Then I would have to go hunt(via google) for any bit of blog/ presentation slides from a meetup/talk etc for ways to find

Re: [GENERAL] WARNINGs after starting backup server created with PITR

going to be surpassing the available limits in portably drive capacity unless we invest in tape drives. Are you guys running ZFS yet? If so it's snapshot / cloning capabilities might be the way to go. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: [GENERAL] Online Oracle to Postgresql data migration

it before, but I don't think it is anything too magical; we went through a number of different ideas and ended up using multiple methods depending on the data involved. HTH. -- Robert Treat Database Architect http://www.omniti.com ---(end of broadcast

Re: [GENERAL] advocacy: drupal and PostgreSQL

too much. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

  1   2   3   4   >