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

gsql was port to use the core lexer. Ideally you'll have some kind of test suite / regression you can run 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 a

Re: [GENERAL] Oracle to PostgreSQL transition?

x27;s the latter, you'll probably need to write your own tools; at least we've always done that as we've never found anything 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 repli

Re: [GENERAL] Default timezone changes in 9.1

here system was UTC and Postgres was GMT, which was mostly a cosmetic problem, but it surprised us 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

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

old and crufty, but provides a good example: http://labs.omniti.com/labs/pgtreats/browser/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

w 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 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

h. 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 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] wal archiving on a hot-standby server

les to the other 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 con

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

idea in the past, though there is a valid argument for saying that while you don't have a specific limit you care about, there are values 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

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

ng. Personally I'd throw out those vacuum cost settings entirely as they cause more trouble than they're worth (IMNSHO), 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] synchronous replication + fsync=off?

will be corrupt upon server or OS crash (which is something most people should avoid). > I think the only use of fsync off is for performance testing so see how > expensive fynsc is. > Never speak in absolutes! ;-) It's not unheard of to run with fsync = off when you have asynchro

Re: [GENERAL] pg_standby for postgresql8.2

require compiling and implements 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] Incremental backup with RSYNC or something?

s that can be shipped 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] upgrading from 8.3 to 9.0

ostgresql.org/docs/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 wrote: > I've performed a very similar upgrade

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 wrote: > The manual section on the postmaster pro

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

, and when stuff fails because you lied to the > system, you will probably never ever figure 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. Th

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

127.0.0.1/32 password > > The command I am running is: > pg_dump -F c -v -X 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,

Re: [GENERAL] Recommendations for SSDs in production?

rchitecture, but the two that have proven best in our 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-gener

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

2011/11/3 Devrim GÜNDÜZ : > 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 t

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

lack of > request (first request since 8.3.11...). You can build your own 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: xz

Re: [GENERAL] Server move using rsync

it seems less error prone, and you can actually test the failover and lunch bits while the original server is up and running. 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] 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 wrote: > On 09/13/2011 08:15 PM, Toby Corkindale wrote: >> >> Hi, >> Some months ago, I ran

Re: [GENERAL] md5 of table

ons. I've always liked doing this with my pager: [robert@client-168] export PAGER=md5 -=[11:40:25 Thu Sep 01]=---=[ pagila-0.10.1 ]=- [robert@client-168] psql -hlocalhost -dpagila psql (9.0.4, server 9.1beta3) WARNING: psql version 9.0, server version 9.1. Some psql features m

Re: [GENERAL] SSDs with Postgresql?

re running fusion-io on some pretty heavily 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-gene

Re: [GENERAL] SSDs with Postgresql?

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 play: http://xzilla.net work: http://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] Question about switchover with PG9 replication

The issue is more just that the built in replication system isn't very mature yet. It's being 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

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

someone is looking to fund/help development of such a thing, it might 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 pgsq

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

is_cadex_released LIMIT 5 OFFSET 0 > Looks to me like the problem is you are trying to ORDER BY columns in "ca_customs_entry", but there is no such table for that (don't confuse it with "ca_customs_entries"). You need 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] REINDEX requirement?

ill output numbers on table/index bloat. It's not entirely accurate (patches welcome), 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

Re: [GENERAL] Why facebook used mysql ?

be somewhat workload dependent. It's mostly irrelevant though to "internet 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

[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:

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

ooking forward to another 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

l day 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!

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 w

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 > > 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 it >

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

ain lately, but if only 1% of your rows are going to have data 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] PostgreSQL on Webmin

that information is a bit out of date. There's a better write up at http://wiki.postgresql.org/wiki/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:

Re: [GENERAL] audit table

id SERIAL PRIMARY KEY, >table_changed regclass, >changed_by VARCHAR, >changed_when TIMESTAMP WITH TIME ZONE, > ); > > and then you have child audit tables for each audited table, each of > which looks like this: > > CREATE TABLE audit_tablename ( >

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

rst_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: 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] Database schema & data synchronizer software for PostgreSQL?

While I would agree that these tools can't solve organizational 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:

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

ny trigger functions on the postgres side as well (or at least givec you a good starting 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

so you can run your code unmodified. > *In theory* :-) 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 C

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

ther option 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

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

d example (tracking pages across all databases), but also things like work_mem need to account for all 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, j

Re: [GENERAL] Switch off PITR

our backup and then moving the missing logs manually. (This is more/less fragile depending on exactly how you've set things 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] Job scheduling in Postgre

ubset of the community. I had hopes 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

Re: [GENERAL] Favorite Tom Lane quotes

." > > We really need a 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 Con

Re: [GENERAL] In memory Database for postgres

This assumes you're keeping the default table space 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

Re: [GENERAL] speed up restore from dump

It would be good to know where and when his bottlenecks are... ie. i could see him being i/o, memory, or cpu bottlenecked depending on where he is in the restore process. -- 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

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 th

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

equired. > > What else do 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

Re: [GENERAL] How to free disk space

t, isn't there a better way > > to do this without shutting down postgres? > > > > Thanks in advandce. > > -- > Emanuel Calvo Franco > Syscope Postgresql DBA > BaPUG Member -- Robert Treat Build A Brighter LAMP :: Linux Apache {middlew

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

base, 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

1st, so if you did have something you wanted to get into 8.4, you have 2 weeks to make 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-

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

ad idea to do begin; lock table t1 in access exclsuive mode; create temp table x as select ... from t1; truncate t1; insert into t1 select * from x; create unique index ui1 on t1(...); commit; this way you're now unique table will be nice and compacted, and wont get any more duplicate

Re: [GENERAL] Slony vs Longiste

e testing, and scripts that > were to automate setup and manage the installation. It did not include > support and maintenance. Are you planning on hiring someone to do it, or are you going to do it yourself, because the prices of the solution is completely orthogonal to which is the bet

Re: [GENERAL] 8.3.3 stability ?

ant to really move to that version when 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] about partitioning

e info, I've given at least one presentation on the topic, which seems to be missing from 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 Databa

Re: [GENERAL] Restore filesystem backup

tempted to just try copying the tables files directly between the two directories if you can matchup 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 v

Re: [GENERAL] pg_restore parameters

h the pain of a dump/restore, I'd suggest looking at upgrading to 8.3 during the process. -- 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

o locking issues as well. Note, this can sometimes apply to more narrow restore scenarios, but it isnt as cut and dried. (Ie, 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) -- Ro

Re: [GENERAL] Fastest way to restore a database

gresql-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://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] PostgreSQL TPC-H test result?

e tpc-h allows for changes to queries to support syntax variations between databases; I'm pretty sure I could make suttle changes to "break" other databases as well. Incidentally, I poked Mark Wong, who used to work at the OSDL (big linux kernel hacking shop), and he noted he

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

y, but there can be advantages to doing it using the pitr tools, and I think in most cases it would be hard to argue it isn't safer. As a counter example to theo's zfs based post, I posted a linux/lvm script that can work as the basis of a simple snapshot backup tool, available at h

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 PROTECTE

Re: [GENERAL] Oracle and Postgresql

g simple like oracle's dblink, which comes pre-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-genera

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

cific questions beyond that, please post them in the list, and be sure to include 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

list 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 nee

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/ > > Reg

Re: [GENERAL] Using PostGres general distribution

't designed into your original expectations; but if you have controlled access to the server, it's likely postgres can work in that scenario. (The other problem spots is server upgrades, but you can probably go years on a particular version before that becomes really pr

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

difference between an unqualified DELETE and a TRUNCATE? > > lack of triggers and RULEs spring to mind. > 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-gen

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

nce and for all.... sumo suits anyone? http://www.maineventweb.com/page/page/2916926.htm -- 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] limits?

eeps creating empty tables and see where > that goes, but I'd prefer not to do something like this... > http://people.planetpostgresql.org/greg/index.php?/archives/37-The-million-table-challenge.html -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via p

Re: [GENERAL] Losing data

ms to have started last friday, when reports started to go > 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 s

Re: [GENERAL] Alias in the HAVING clause

l problems the spec is trying to keep you from getting into... but I have to wonder, if we have established f1 by the time we evaluate the group by, shouldn't we also be able to determine f1 at having time, and therefore allow alias in having in this instance? -- Robe

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

gt; > There is a caveat here, in that you need to keep around n number of xlogs, where n is determined based on the last restart point processed on the slave. If you are deleting all xlogs as they are processed, any shutdown will likely cause you to have to start the whole thing over again. Not

Re: [GENERAL] PG -v- MySQL

to find information specific to your environment). 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 schizophren

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

; You can't in plpgsql. It doesn't have the equivalent of a walkable > fields collection. Its possible in some other procedure languages (I've > seen it done in C). > I did it once by setting up the function to accept the tablename and ctid of the row involved, and then g

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

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

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. Whi

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 > >

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/3

Re: [GENERAL] How to modify ENUM datatypes?

argue that since it is expected that the ratings might change in some way every few years that an enum type is not a good choice for this, but I feel like some type of counter-argument is that this is probably longer than one would expect thier database software to last. :-) -- Ro

Re: [GENERAL] Column order

its and you'll have soon have a patch for doing this the right way. -- 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?

s ever (yeah, i > > skipped some special cases). > > 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 ;-) > T

Re: [GENERAL] pgcrypto and dblink

sing configure. > A post installation step is fine but I think it needs to be documented > as such. > There are instructions on how to install them at http://www.postgresql.org/docs/8.3/interactive/contrib.html, but your right they don't seem to be mentioned anywhere in the install s

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

t E'\\connect ' || datname || E'\nvacuum;' from > pg_database where datallowconn" | psql > > that's not actually complicated (i'm not saying it's nice, as it isn't). > I have to think that a better solution for someone whose needs are met by the abo

Re: [GENERAL] Postgres development

as been pestering him about it pretty steady. -- 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] Postgresql partitioning

update rule to the parent table itself, rewriting into a set of insert, delete statements. (or call 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 mailin

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

n escape from the failure scenario by having either a different role, or a different database with the ability to do "alter database disable on connect triggers". whether this is a direct alter database, or set at the GUC level, either makes it pretty hard to lock yourself out completly,

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

te for it, and the public doesn't want to commit > to a database that has only a handfull of books available. > Just to clarify, the market needs to expand to get publishers on board, not authors. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL --

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

p://www.postgresql.org/ I'd place it in the support menu... Actually I think we should be pointing people 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 tha

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

module.) > Note another possible solution for mediawiki users is to do a fresh install using 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

Re: [GENERAL] Is PG a moving target?

was the idea behind castcompat, which didn't get far out of the gate before several examples cropped up showing how backwards-compatible casting would break new 8.3 system expectations. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL --

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

t put > use.perl.org in the top results. > hmm, i'd have thought you 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)--

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

gt; > > > like > > > > commit_delay, > > > > fsync. > > I haven't done any tuning as of yet. I'm running with the default settings > produced by initdb. > Don't even bother trying to tune zfs untill after you've tuned postgres,

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

d I > bought a bit of it too, didn't bother subscribing to safari, it just > ain't a book!) to be used as reference 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 rem

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

second co-lo for now. But, pretty soon we're > 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

Re: [GENERAL] Online Oracle to Postgresql data migration

business factors. My guess is that in your case, you'd want a mix of replicating data from the current Oracle database and your application, as best possible. Figuring out how you go about replicating the data is certainly easier if you've have been through it before, but I don't thin

Re: [GENERAL] advocacy: drupal and PostgreSQL

started to pay off. I'd guess that if they wanted to, they could switch to PDO with Drupal 7 and not hurt themselves 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   >