Re: [GENERAL] updating all records of a table

robjsarg...@gmail.com (Rob Sargent) writes: > On 03/04/2011 04:54 AM, Vibhor Kumar wrote: >> >> On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote: >> >>> On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote: Hi: I have to update all the records of a table. I'm worried ab

Re: [GENERAL] disable triggers using psql

li...@serioustechnology.com (Geoffrey Myers) writes: > Greg Sabino Mullane wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: RIPEMD160 >> >> >>> cut and paste: >>> >>> set ON_ERROR_ROLLBACK; >> >> Should be >> >> \set ON_ERROR_ROLLBACK on >> >> You can also set this when calling psql like so: >

Re: [GENERAL] database instance creation

prabakara...@zohocorp.com ("prabakaran.a") writes: > Dear All, > >  In Mysql, If we create a directory under mysql/data, mysql treated as > database instance without starting mysql server. >  Is there any similar provision in postgres where we can create a > database instance without starting postg

Re: [GENERAL] Database Design Question

carlos.menn...@gmail.com (Carlos Mennens) writes: > I was sitting down thinking the other day about when is it good to > generate a new database or just use an existing one. For example, lets > say my company name is called 'databasedummy.org' and I have a > database called 'dbdummy'. Now I need Po

Re: [GENERAL] Why does my DB size differ between Production and DR? (Postgres 8.4)

peter.geoghega...@gmail.com (Peter Geoghegan) writes: > On 1 February 2011 03:52, Scott Marlowe wrote: >> You can reclaim that space by doing a cluster or vacuum full on the >> subject table. > > Yes, but this is a fairly bad idea, particularly prior to PG 9.0 . 9.0 > has a new vacuum full impleme

Re: [GENERAL] Why does my DB size differ between Production and DR? (Postgres 8.4)

atsaloli.t...@gmail.com (Aleksey Tsalolikhin) writes: > Situation: Disk usage on production server root filesystem is at 68% > utilization (80 GB used), on DR is at 51% (56 GB used). We use > SlonyII-1.2.x to keep the DR up to date. I would like to account for > the 24 GB difference. It's more

Re: [GENERAL] Book recommendation?

hero...@unicell.co.il (Herouth Maoz) writes: > As a result of my recent encounter with table bloat and other tuning > issues I've been running into, I'm looking for a good resource for > improving my tuning skills. > > My sysadmin ran into the following book: > > PostgreSQL 9.0 High Performance, by

Re: [GENERAL] Adding ddl audit trigger

guilla...@lelarge.info (Guillaume Lelarge) writes: > Le 26/01/2011 23:13, Tom Lane a écrit : >> Guillaume Lelarge writes: >>> Le 26/01/2011 22:29, Lawrence Cohan a écrit : All I need is to at least be able and save a userid(current_user), >>> timestamp, action, and the name of the object and

Re: [GENERAL] Moving from SQL Anywhere to PostGres - First Time

"Robert Paresi" writes: > Hello, > > We have 700 user install base using Sybase SQL Anywhere 9.02 > > We are looking at migrating these installations over to PostGres > > 1. Very Very Short Answer Please - why should we? Cheaper? Perhaps faster? It's tough to guess, absent of metrics as to why

Re: [GENERAL] How to generate unique invoice numbers for each day

m...@smogura.eu (Radosław Smogura) writes: > In any approach preventing gaps, locking is required. This is real life > situation; imagine you have two coworkers and then they need to create > invoices, so they looks in ledger (or a last day copy of ledger in their > offices; international compan

Re: [GENERAL] UUID column as pimrary key?

dal...@solfertje.student.utwente.nl (Alban Hertroys) writes: > On 6 Jan 2011, at 17:51, Chris Browne wrote: > >> wmo...@potentialtech.com (Bill Moran) writes: >> If your system is sufficiently negligently designed that this particular >> conflict causes it to kill people

Re: [GENERAL] UUID column as pimrary key?

dennis.jenkins...@gmail.com (dennis jenkins) writes: > The UUID itself is 128 bits. Some of those bits are pre-determined. > I don't recall, but I think that a "normal" UUID has 121 bits of > randomness. That doesn't match RFC 4122 very well... It indicates 5 forms of UUIDs: 1) Time-based, wher

Re: [GENERAL] UUID column as pimrary key?

wmo...@potentialtech.com (Bill Moran) writes: > If the chance of a duplicate is 1 in a hundred gazillion, then I can > still hit a dupe the VERY FIRST TIME I USE IT. > > I'm writing software that is intended to be used to save lives in the > event of an earthquake or flood or cosmic ray flipping bi

Re: [GENERAL] UUID column as pimrary key?

a...@crankycanuck.ca (Andrew Sullivan) writes: > On Wed, Jan 05, 2011 at 12:41:43PM -0700, Scott Ribe wrote: >> I'm not sidestepping the point at all. > > You may be missing it, however, because. . . > >> The point is that the finiteness of the space is a red herring. The >> space is large enough t

Re: [GENERAL] UUID column as pimrary key?

dal...@solfertje.student.utwente.nl (Alban Hertroys) writes: >>> From wikipedia, "only after generating 1 billion UUIDs every second for >> the next 100 years, the probability of creating just one duplicate would >> be about 50%. The probability of one duplicate would be about 50% if >> every perso

Re: [GENERAL] UUID column as pimrary key?

d.w...@computer.org (David Wall) writes: > We're using UUID for primary keys in PG 8.4 without any issues. I > have no real insights into the details or performance issues, but > always figured it was stored as a binary 128-bit value, but with added > benefits of being able to enter and view them

Re: [GENERAL] Standard schemas for common features?

gvi...@gmail.com (gvim) writes: > I'm putting together a database for a web project which has a lot of > HR components which I imagine are fairly standardised so, to avoid > re-inventing the wheel, is there a source of standard, downloadable > schemas for common projects? One might imagine so...

Re: [GENERAL] 2 versions of an entity worth distinct table?

gvi...@gmail.com (gvim) writes: > If a table representing contact details can have 2 but no more than 2 email > addresses is it really worth factoring-out email addresses to a separate > table. Technically it's a 1-to-many relationship so should be done this way > but what is the general practic

Re: [GENERAL] Tool for data modeling and ER diagram

gwch...@gmail.com (Gary Chambers) writes: >> What is the best tool of data modeling and ER diagram for PostgreSQL. >> http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools > > Although it may not be considered a tool for use in the design (per > se) of a database, I would highly recommend that

Re: [GENERAL] pgadmin story...

andrew writes: > hi all, > I've just read that pgadmin team was hired by some company and the > project will be closed... It was a post from 2009. > I'm just curious what's the story behind that. Did anyone leave? > thanks. Are you thinking about this announcement? http://pgsnake.blogspot.com/

Re: [GENERAL] Why facebook used mysql ?

kamaual...@gmail.com (Allan Kamau) writes: > I agree with Merlin, There is a surprising big number of "good" > technology companies (including Google) out there using MySQL. For > sometime I have been wondering why and have come up with a few > (possibly wrong) theories. Such as: these companies ar

Re: [GENERAL] experience with tags schemas

matthieu.h...@wallix.com (Matthieu Huin) writes: > Greetings, > > Does anyone here have any experience with tags schemas on postgresql ? > > I am struggling with a schema inspired by "scuttle" described here : > > http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html > > Performances

Re: [GENERAL] Views - Under the Hood

te...@chosen-ones.org (Terry Lee Tucker) writes: > Lately, I've begun using views quite often especially when queries for > various > reports, etc. become complicated. I am now wondering if there is a price to > pay in terms of overhead for this. In truth, I don't really understand how a > view

Re: [GENERAL] Linux

mgo...@intermodalsoftwaresolutions.net (Michael Gould) writes: > What and why should I look at certain distributions? It appears from > what I read, Ubanta is a good desktop but not a server. There are Ubuntu versions that don't promise support (e.g. - ongoing bug & security fixes, and such) for

Re: [GENERAL] Database INNOVATION

mcham...@gmail.com (Mauricio Chamati) writes: > Postgree is the most amazing DB, even more it will be the only one that will > remain free (the good ones) as MySQL has been taken. In order to move on with > this project, as an Java Senior Architect, I am recomming to you guys to have > an special "

Re: [GENERAL] NoSQL -vs- SQL

dp...@pgadmin.org (Dave Page) writes: > On Tue, Oct 12, 2010 at 2:58 AM, Peter C. Lai wrote: >> On 2010-10-11 05:57:37PM -0600, David Boreham wrote: >>>   On 10/11/2010 5:46 PM, Carlos Mennens wrote: >>> > Just wondering how you guys feel about NoSQL and I just wanted to >>> > share the following

Re: [GENERAL] NoSQL -vs- SQL

carlos.menn...@gmail.com (Carlos Mennens) writes: > Just wondering how you guys feel about NoSQL and I just wanted to > share the following article... > > http://www.linuxjournal.com/article/10770 > > Looking to read your feedback and / or opinions. There's a lot there to agree with, and a lot to

Re: [GENERAL] Binary Replication and Slony

johnlich...@gmail.com (John Cheng) writes: > Congrats on the 9.0 release of PostgreSQL. One of the features I am really > interested in is the built-in binary replication. > > Our production environment has been using PostgreSQL for more than 5 years > (since this project started). We have been usi

Re: [GENERAL] pg_dump-restore concurrency

yasinma...@gmail.com (paladine) writes: > Hi all > I prefer doing pg_dump - psql restore to vacuum full and > is there anyone know whether postgresql can insert data concurrently while > restoring a table for not losing any data. > > thanks in advance... The problem scenario that I'd expect is w

Re: [GENERAL] Want to schedule tasks for the future

m...@tplus1.com (Matthew Wilson) writes: > Just recently I discovered the listen/notify feature in postgresql. > Now I don't have external processes polling tables, watching for new > inserted rows. > > Anyhow, I'm curious if there is some other feature that will help me out > with a new puzzle. >

Re: [GENERAL] Scheduling backup

passionate_program...@hotmail.com (RP Khare) writes: > Is there any way to schedule PGSQL databases backups?  I want to > take hourly dumps of my production database. Sure. You can use whatever tool you already have to schedule running "pg_dump." On Unix-like systems, you almost always have a sy

Re: [GENERAL] Postgres table contents versioning

jsmg...@numericable.fr (John Gage) writes: > Is there an equivalent of svn/git etc. for the data in a database's > tables? > > Can I set something up so that I can see what was in the table two > days/months etc. ago? > > I realize that in the case of rapidly changing hundred million row > tables t

Re: [GENERAL] HA for PostgreSQL (Auth-Server)

cr...@postnewspapers.com.au (Craig Ringer) writes: > OpenLDAP is a pretty solid LDAP server these days, and I highly > recommend it for use as an authentication database. By default it uses > Berkeley DB as a backend, which is quite acceptable with newer versions > of Berkeley DB that provide decen

Re: [GENERAL] The case of PostgreSQL on NFS Server

shik...@air.co.jp (Iwao Shikase) writes: > If I mount the database cluster with caching in my environment, What kind of >  problem I will meet? Please give the information about the problem you met. If you use NFS, and are not absolutely certain of the semantics of the implementation, then you are

Re: [GENERAL] A thought about other open source projects

bnich...@ca.afilias.info (Brad Nicholson) writes: > Scott Marlowe wrote: >>> As with phrases like, "the quickest way to grill a unicorn steak," >>> that it can be stated in a few words does not make in possible. >> >> Exactly. The big issue here is that nobody's saying what kind of app >> they wan

Re: [GENERAL] IMMUTABLE columns in tables?

avbid...@fortytwo.ch (Adrian von Bidder) writes: > Heyho! > > (Ok, seems to be feature wish day ...) > > I was wondering if others would find an IMMUTABLE (or whatever) column > constraint useful as well. Semantics would (obviously?) be to disallow > changing the value of this column after inser

Re: [GENERAL] Cognitive dissonance

t...@sss.pgh.pa.us (Tom Lane) writes: > Peter Eisentraut writes: >> On lör, 2010-06-12 at 11:18 +0200, John Gage wrote: >>> A one file html version would be a godsend. > >> I've committed a build target for that now. Use 'make postgres.html' in >> doc/src/sgml/. > > Huh, is that actually worth a

Re: [GENERAL] Cognitive dissonance

jus...@magwerks.com (Justin Graf) writes: > Its also available in chm windows help file format. Which i find allot > more useful > http://www.postgresql.org/docs/manuals/ > you could print chm to a text file. > > also it not hard to dump a PDF document into a text file. I wish I could find a co

Re: [GENERAL] Move data from DB2 to Postgres any software/solutions/approach?

dm.a...@gmail.com (DM) writes: > It is not real time, updates every 5 mins should be fine.  > > But the DB2 database is real busy and its real performance based.  The book "Scalable Internet Architectures" (by Theo Schlossnagle) has an example of how to build a trigger-based replication system cop

Re: [GENERAL] Commit every N rows in PL/pgsql

Chris Browne writes: > len.wal...@gmail.com (Len Walter) writes: >> I need to populate a new column in a Postgres 8.3 table. The SQL would be >> something like "update t set col_c = col_a + >> col_b". Unfortunately, this table has 110 million rows, so running th

Re: [GENERAL] Commit every N rows in PL/pgsql

len.wal...@gmail.com (Len Walter) writes: > I need to populate a new column in a Postgres 8.3 table. The SQL would be > something like "update t set col_c = col_a + > col_b". Unfortunately, this table has 110 million rows, so running that query > runs out of memory. Unnecessary. On Oracle, the

Re: [GENERAL] What Linux edition we should chose?

Michal Szymanski writes: > Hi, > Currently we use Debian, but it chosen by our OS admnistrator. Now we > can change our OS and it is question what Linux edition will be the > best. We would like have access to new versions of Postgres as soon > as possible, for Debian sometimes we had to wait man

Re: [GENERAL] Am I supposed to be all scared of compound primary keys?

m...@kitchenpc.com (Mike Christensen) writes: > I have a table that stores a user ID and a subscription type, and this is > really all it needs to store and any pair of values will always be unique.  In > fact, I think this pair should be the primary key on the table.  However, I'm > using Castle A

Re: [GENERAL] Save MySQL? HA

dcor...@connx.com ("Dann Corbit") writes: > (Commercial use of MySQL without paying a license fee requires that > projects using the database are also GPL, IIRC). I know I've seen Monty say this sort of thing a lot of times, and his most recent rant (

Re: [GENERAL] Books

thomas.granv...@gmail.com (Thomas Løcke) writes: > There's a new series of PostgreSQL books available: > > PostgreSQL 8.4 Official Documentation - Volume I > PostgreSQL 8.4 Official Documentation - Volume II > > And so on, up to volume V I think. > > Would I be supporting the PostgreSQL project by

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

paul_t...@fastmail.fm (Paul Taylor) writes: > If instead you have to run a database standalone, then you do hit > configurations problems, not only platform specific issues but also > people bloody mindness about creating databases with different names > and database users : whatever the documentat

Re: [GENERAL]

sw...@opspl.com writes: >> You can use "kill " command to kill the slon daemons, >> find >> the pid's of the cluster and kill. >> >> > > But that is not totally right :P . If there is no other way we will > use it.. But I want to stop slony properly using slony command. :) There

Re: [GENERAL] SVN and Postgres 8.3

phoenix.ki...@gmail.com (Phoenix Kiula) writes: > My question: how can I use PostgreSQL 8.3 and SVN on the same server? > Has someone figured out how to fix this situation? I'm on CentOS 5 x64 > bit. RPM has a "--replacefiles" option which might either help or hurt... I think there's a fair chanc

Re: [GENERAL] Can postgresql store its data on raw device now?

lizz...@gmail.com (Lizzy M) writes: > I have an problem: can postgresql store its data on the raw disks now? > > I have checked the mail list and manual, but haven’t found the > answer. In some early mails, they mentioned pg didn’t support this > character. But how about now? Raw disk m

Re: [GENERAL] Schema, databse, or tables in different system folder

"Carlos Oliva" writes: > Would the backup be unrecoverable if I shutdown the databse first? If the backup includes pg_xlog and pg_clog, as well as all of the database metadata files, then whatever portions *are* included are likely to be somewhat usable. The portions not included in the backup w

Re: [GENERAL] Schema, databse, or tables in different system folder

"Carlos Oliva" writes: > Is there a way to create a database or a table of a database in its own > folder? We are looking for ways to backup the sytem files of the database > to tape and one to exclude some tables from this backup. We can selectively > backup folders of the file system so we

Re: [GENERAL] Schema, databse, or tables in different system folder

"Carlos Oliva" writes: > Is there a way to create a database or a table of a database in its own > folder? We are looking for ways to backup the sytem files of the database > to tape and one to exclude some tables from this backup. We can selectively > backup folders of the file system so we

Re: [GENERAL] Postgres, DB design, and object IDs (of any ilk)

kentil...@gmail.com (Kenneth Tilton) writes: > Just looking for postgres "best practices" input from the veterans: OIDs are decidedly a bad idea; the difference between "natural" IDs and "surrogate" IDs is a general database issue that is fairly well documented in the literature and is not notably

Re: [GENERAL] Yet another "drop table vs delete" question

x...@thebuild.com (Christophe) writes: > On Apr 21, 2009, at 12:28 PM, Peter Eisentraut wrote: >> Yes, but if you are asking that question, you probably really want >> to use >> TRUNCATE. > > The advantage of DROP TABLE being, of course, that DROP TABLE is > transactionally-safe, while TRUNCATE is

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

ianm...@tesco.net (Ian Mayo) writes: > 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 in a >> separate table. > > thanks for that Robert - it

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

juankarlos.open...@gmail.com (Juan Pereira) writes: > Quite interesting! The main reason why we thought using a table per > truck was because concurrent load: if there are 100 trucks trying to > write in the same table, maybe the performance is worse than having > 100 tables, due to the fact that t

Re: How to delete all locks? Re: [GENERAL] Strange behavior: row won't delete

phoenix.ki...@gmail.com (Phoenix Kiula) writes: > On Wed, Mar 4, 2009 at 12:55 AM, Phoenix Kiula > wrote: >> I guess my question is, how should I remove all pending locks on a >> table so that I can get on with the rest of the stuff? >> >> I mean, even if I can now find an offending RULE on the t

[GENERAL] Non-Fun with SSHA Password scheme

I have been trying to set up pl/pgsql code to generate and evaluate {SSHA} passwords, with somewhat limited success. {SSHA} is a password scheme that uses SHA-1 along with salting to ward off dictionary attacks. Apparently it's used quite a bit with LDAP. There does not seem to be a "claimed aut

Re: [GENERAL] does postgres has the same limitation as MySQL?

tekion writes: > I know that MySQL can only use one index at at time for query. Does > Postgres has this same limitation? For example, the following query: > > select uid,count(uid) from A, B where A.uid = B.uid and date between > and > > MySQL will either use index on uid or the date (Both uid

Re: [GENERAL] Relational database design book

rshep...@appl-ecosys.com (Rich Shepard) writes: > > [2] Strangely enough -- to me, at least -- the lack of full support for > date- and time-based SQL in database tools such as PostgreSQL is puzzling. > Virtually all business-related databases (think accounting systems as a > prime example) depend

Re: [GENERAL] Favorite Tom Lane quotes

[EMAIL PROTECTED] (Tom Lane) writes: > "Scott Marlowe" <[EMAIL PROTECTED]> writes: >> We really need a favorite Tom Lane quotes thread. Mine is (roughly): > >> We don't support that, but you're free to try it, you just get to keep >> both pieces if it breaks. > > Hate to disillusion you, but that'

Re: [GENERAL] Using postgres.log file for replication

[EMAIL PROTECTED] (Ioana Danes) writes: > I've been wondering if anybody tried to use the postgresql csv log > file to replicate sql statements. I've been looking into it in the > past days and after a brief testing it doesn't look bad at all... It's *plausible*, but you have to ensure that you *

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

[EMAIL PROTECTED] ("Scott Marlowe") writes: > I assume hardware failure rates are zero, until there is one. Then I > restore from a known good backup. compressed file systems have little > to do with that. There's a way that compressed filesystems might *help* with a risk factor, here... By red

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

[EMAIL PROTECTED] (Tom Lane) writes: > We already have the portions of this behavior that seem to me to be > likely to be worthwhile (such as NULL elimination and compression of > large field values). Shaving a couple bytes from a bigint doesn't > strike me as interesting. I expect that there wou

[GENERAL] PostgreSQL talk at CASCON

https://www-927.ibm.com/ibm/cas/cascon/papers/papers.shtml#1 Tuesday, October 28 paper presentations Session 1: Databases DBMS Workload Control Using Throttling: Experimental Insights Best Paper Wendy Powley and Pat Martin, Queen's University; Paul Bird, IBM Toronto Lab "Today's Database Managem

Re: [GENERAL] Execute Shell script after insert

[EMAIL PROTECTED] ("Anderson dos Santos Donda") writes: > Is there a way to execute a simple shell script in server after execute > INSERT INTO ? > Example? > INSERT INTO clients (name) VALUES ('Donda'); > after it, execute shell : mkdir $1 You could do this, directly, via stored procedure langua

[GENERAL] Rounding of floating point in text dumps?

A question came up on the Slony-I list (quite a while ago, but that's another story!) as to the handling of floating point values. The user is concerned about whether FP values are faithfully replicated. I commented that the issue will be identical to that of the handling of data in pg_dump; if S

Re: [GENERAL] [LIKELY_SPAM]Re: Oracle and Postgresql

[EMAIL PROTECTED] ("Roberts, Jon") writes: > Roberts, Jon wrote: >> > My top 10 reasons why companies pick Oracle. >> >> Do you mean they actually get these things, or they imagine they do? >> > Huh? Companies buy Oracle all of the time. That's not the point. The question isn't whether they

Re: [GENERAL] PostgreSQL process architecture question.

[EMAIL PROTECTED] ("Amber") writes: >We know PostgreSQL uses one dedicated server process to serve one > client connection, what we want to know is whether PostgreSQL use > multiple threads inside agents processes to take advantage of > multiple CPUs. In our site we have only a few concurren

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

[EMAIL PROTECTED] ("Phoenix Kiula") writes: > On 8/26/08, Tomasz Ostrowski <[EMAIL PROTECTED]> wrote: >> >> I think nobody would guide you step by step. Either read documentation >> and do it yourself or hire an expert: > > Thanks. I suppose that spirit is quite evident in the documentation. > Wh

Re: [GENERAL] Easy upgrade on Cpanel *without* downtime

[EMAIL PROTECTED] ("Phoenix Kiula") writes: > See, this is where I get confused. I want to upgrade from 8.2.3 to > 8.3.3. The recommendation is to try Slony. So I download Slony and try > to configure it. The configure command gives me this: > > > > checking for correct version of PostgreSQL..

Re: [GENERAL] Probably been asked a hundred times before.

[EMAIL PROTECTED] (David Siebert) writes: > Well I am kind of stuck using OpenSuse. Not a bad distro and is the one > we use in our office for production work. > I like CentOS myself for database work and tend to use that for test > systems here since I manage them myself. > I was more wondering if

Re: [GENERAL] PostgreSQL and AMD?

[EMAIL PROTECTED] ("John Tregea") writes: > I have been asked to specify a pair of HP PC's to set up a > PostGreSQL server (and backup) for a client. The HP model we are > looking at has an AMD Phenomâ,,¢ Quad Core Processor (9600B). The > machines would be running Windows XP Pro (our clients > req

Re: [GENERAL] New MS patent: sounds like PG db rules

[EMAIL PROTECTED] (Martijn van Oosterhout) writes: > On Fri, May 30, 2008 at 03:07:17AM +0930, Shane Ambler wrote: >> Exactly. The real problem is that the first one to apply for a patent >> gets it. It really doesn't matter who invents it. If we have patents >> that cover our work then we can cont

Re: [GENERAL] Open Source CRM - Options?

[EMAIL PROTECTED] (Kaloyan Iliev) writes: > And what about RT (Request Tracker - http://bestpractical.com/rt/) > . > AFAIK it is free and open-source, uses Postgres and is easy to setup. RT has a very different purpose; it was designed to track work (e.g. - "work tickets"), as opposed to managing

Re: [GENERAL] PG -v- MySQL

[EMAIL PROTECTED] ("Joshua D. Drake") writes: > Gauthier, Dave wrote: >> I’ve been invited to participate in a forum which discusses >> technical issues for relational DBs used in the corporation. The 3 >> DBs they are discussing are Oracle, SQL-Server and MySQL. I’d like >> to introduce PG, but

Re: [GENERAL] choiche of function language was: Re: dynamic procedure call

[EMAIL PROTECTED] (Ivan Sergio Borgonovo) writes: > On Sat, 10 May 2008 07:35:36 +0200 > "Pavel Stehule" <[EMAIL PROTECTED]> wrote: > >> your application different execution paths. Generally I can say, so >> plpgsql isn't well language for this games, and better is using >> plperl, plpython or othe

Re: [GENERAL] How to modify ENUM datatypes?

[EMAIL PROTECTED] (Robert Treat) writes: > On Thursday 01 May 2008 13:40, Tom Lane wrote: >> 7.4 was released 2003-11-17, so I think that it will very likely get >> obsoleted at the end of 2008. >> > If that's the case, it'd be nice to get an official statement of that now. :-) People have been ma

Re: [GENERAL] How to modify ENUM datatypes?

[EMAIL PROTECTED] (Robert Treat) writes: > I feel like some type of counter-argument is that this is probably longer > than one would expect thier database software to last. :-) That has the counterargument that if the database software works, it's likely to get used for longer than one would ex

Re: [GENERAL] How to modify ENUM datatypes?

[EMAIL PROTECTED] (Andrew Sullivan) writes: > On Wed, Apr 23, 2008 at 07:46:07PM -0400, brian wrote: >> >> Absolutely true. Which is odd, because this example is trotted out >> whenever there's a thread about ENUMs. > > I don't think it's odd at all. In my view, the people who think enums are a

Re: [GENERAL] Adding notes against fields

[EMAIL PROTECTED] (Oliver Helm) writes: > Hello, > > > > I was wondering if if is possible to add a note against a field on a > postgresql table?   > > > > For example when running "\d tablename" i would like to have and additional > column called 'notes' which i could add to by altering the tab

Re: [GENERAL] Need to update all my 60 million rows at once without transactional integrity

[EMAIL PROTECTED] writes: > How can I make a Update of a column in a very large table for all > rows without using the double amount of disc space and without any > need for atomic operation? You may need to redefine the problem. > I have a very large table with about 60 million rows. I sometimes

[GENERAL] pg_bulkloader (was Re: In the belly of the beast (MySQLCon))

[EMAIL PROTECTED] ("Scott Marlowe") writes: > What I keep dreaming of is a process that lets slony use pg_bulkloader > or something like it to do the initial load... Does there seem to be some likelihood of some portion of pg_bulkloader getting added to core? It sounds like it's worth looking at

Re: [GENERAL] In the belly of the beast (MySQLCon)

[EMAIL PROTECTED] (Csaba Nagy) writes: > On Sun, 2008-04-20 at 11:32 -0600, Scott Marlowe wrote: >> On Sun, Apr 20, 2008 at 11:12 AM, Scott Ribe <[EMAIL PROTECTED]> wrote: >> > > I am going to play with this and see where it breaks, but it's going to >> > > be >> > > an enormous time investment t

[GENERAL] Slony-I for upgrades - was Re: In the belly of the beast (MySQLCon)

[EMAIL PROTECTED] (Alvaro Herrera) writes: > Geoffrey wrote: >> Joshua D. Drake wrote: >>> On Fri, 18 Apr 2008 14:30:18 -0400 >>> Geoffrey <[EMAIL PROTECTED]> wrote: >>> I don't know that slony is the answer. It was more of a question then an answer. We are hoping to use that solution t

Re: [GENERAL] In the belly of the beast (MySQLCon)

[EMAIL PROTECTED] ("Joshua D. Drake") writes: > On Thu, 17 Apr 2008 22:19:23 -0500 > Josh Trutwin <[EMAIL PROTECTED]> wrote: > >> Is your presentation available online at all? > > Blogging the bad boy up right now Will be available soon. The presentation seems pretty good... ... But what is

Re: [GENERAL] table as log (multiple writers and readers)

[EMAIL PROTECTED] (Andrew Sullivan) writes: > Oh, one other thing > > On Thu, Apr 17, 2008 at 12:44:51PM +0800, Craig Ringer wrote: > >> > One way I can think of doing it is to write a seen_log that notes what the >> > client has already seen with a timestamp of (say) 1 minute. Then you can >> >

Re: [GENERAL] ALTER TABLE DDL Triggers?

[EMAIL PROTECTED] ("Richard Broersma") writes: > I don't believe that DDL Triggers exist, correct? That is correct.[1] The usual point is that you cannot attach triggers to pg_catalog tables, which would be the "obvious" way of trying to notice DDL changes. (e.g. - by having triggers that woul

Re: [GENERAL] session_replication_role

[EMAIL PROTECTED] (Terry Lee Tucker) writes: > Is there a distinction between "ORIGIN" and "LOCAL" as related to > session_replication_role, and if so, what is it? I am unable to understand > from the documentation any distinction between the two settings. The intent is that a system that is the

Re: [GENERAL] Unacceptable postgres performance vs. Microsoft sqlserver

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > Let me just start off by saying that I *want* to use postgresql. > That's my goal. I do not want to use SQLServer. I'm posting this > message not to slam postgres, but to ask for someone to help me figure > out what I'm doing wrong. > > I've used

Re: [GENERAL] SQL injection, php and queueing multiple statement

[EMAIL PROTECTED] (Ivan Sergio Borgonovo) writes: > Is there a switch (php side or pg side) to avoid things like: > > pg_query("select id from table1 where a=$i"); > > into becoming > > pg_query("select id from table1 where a=1 and 1=1; do something > nasty; -- "); > > So that every > pg_query(...)

Re: [GENERAL] pgcrypto and dblink

[EMAIL PROTECTED] ("Roberts, Jon") writes: > I am moving from Windows to Solaris and I need pgcrypto and dblink. > Where are these? I don't see anything in the configure that suggests it > is even an option. They are part of the set of "contrib" functions. You head to directory "contrib", and, i

Re: [GENERAL] Way to shutdown/freeze/stop an individual database without taking postmaster down?

[EMAIL PROTECTED] ("W S") writes: > I was asked this question, and I wasn't sure if it is possible: > > > do you know of a way to stop just one database (not delete/drop) on > our PostgreSQL 8.1 server? > > > And, while I know how to shut down postmaster, and/or put in rules to > pg_hba.conf to lim

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

[EMAIL PROTECTED] (Steve Atkins) writes: > There are no existing clashes with system tools that I'm aware of. Are > there any? Most of the clashes are with other installations of > postgresql installed on the same machine, so if name clashes is the > real reason for the change, then the version num

Re: [GENERAL] PostgreSQL Replication with read-only access to standby DB

[EMAIL PROTECTED] (Keaton Adams) writes: > That is an interesting question. If our organization were to help fund the > development of such a feature, would that be something taken into > consideration by the development team? I seem to recall there being a relevant Google Summer of Code project

Re: [GENERAL] postgre vs MySQL

[EMAIL PROTECTED] (Craig Ringer) writes: > Erik Jones wrote: >> They've gotten around that by making MySQL "dual-licensed". If >> you're going to be using MySQL in a commercial application then you >> can not use the GPL'd version, you have to use their paid, >> commercial license. >> > My underst

Re: [GENERAL] postgre vs MySQL

[EMAIL PROTECTED] (David Wall) writes: >> What then? Could it be marketing or the sad results of a avalanche >> effect? Geee, there's a thought. >> > What a wide variety of topics. One big difference for me is that > MySQL used to be open source, but it no longer is. It's an odd hybrid > OSS tha

Re: [GENERAL] PostreSQL Single File ( Like M$ Access)

[EMAIL PROTECTED] ("Christian Teguh") writes: > Hi guys, i just wondering, i there a way to make PostgreSQL database > like M$ Access. That have only single or several files without > installing it.?? Thanks for your attention. No, there isn't, just as there isn't a "make it faster" flag. If you

Re: [GENERAL] Is PostGreSql's Data storage mechanism "inferior"?

[EMAIL PROTECTED] ("Andrej Ricnik-Bay") writes: > On 01/02/2008, Tony Caduto <[EMAIL PROTECTED]> wrote: >> The part about the BSD license is bogus. A BSD license is the most >> desirable of any Open Source license and gives you the right to use >> PostgreSQL in your commercial apps without worry.

Re: [GENERAL] [OT] Slony Triggers pulling down performance?

[EMAIL PROTECTED] (Ow Mun Heng) writes: > Just wondering if my 'Perceived' feeling that since implementing slony > for master/slave replication of select tables, my master database > performance is getting slower. > > I'm constantly seeing a very high amount of IO wait. ~40-80 according to > vmstat

  1   2   3   4   >