Re: [GENERAL] Finally upgrading to 9.6!

On 18 October 2017 at 17:17, Vik Fearing wrote: > On 10/18/2017 08:17 PM, Don Seiler wrote: >> On Wed, Oct 18, 2017 at 1:08 PM, Vik Fearing >> > wrote: >> >> On 10/18/2017 05:57 PM, Melvin Davidson

Re: [GENERAL] looking for a globally unique row ID

On 15 September 2017 at 14:45, Adam Brusselback wrote: >> I cannot image a single postgres index covering more than one physical >> table. Are you really asking for that? > > > While not available yet, that is a feature that has had discussion before. > Global indexes

Re: [GENERAL] [HACKERS] SAP Application deployment on PostgreSQL

On 8 September 2017 at 15:34, chiru r wrote: > We have multiple SAP applications running on Oracle as backend and looking > for an opportunity to migrate from Oracle to PostgreSQL. Has anyone ever > deployed SAP on PostgreSQL community edition? > > Is PostgreSQL community

Re: [GENERAL] Please say it isn't so

On 12 July 2017 at 00:51, Steve Litt wrote: > Hi all, > > Please tell me this is a mistake: > > https://wiki.postgresql.org/wiki/Systemd > > Why a database system should care about how processes get started is > beyond me. Systemd is an entangled mess that every year

Re: [GENERAL] Imperative Query Languages

On 5 July 2017 at 01:22, Jason Dusek wrote: > Hi All, > > This more of a general interest than specifically Postgres question. Are > there any “semi-imperative” query languages that have been tried in the > past? I’m imagining a language where something like this: > > for

Re: [GENERAL] [SQL] commit inside a function failing

The straightforward answer is that stored functions always run *inside* the context of a preexisting transaction, therefore you cannot request a separate transaction from within a stored function. What you are asking is fairly deeply impossible.

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

On Mon, Jul 11, 2011 at 10:12 AM, Florian Pflug f...@phlo.org wrote: On Jul11, 2011, at 07:08 , Darren Duncan wrote: Christopher Browne wrote: Vis-a-vis the attempt to do nested naming, that is ns1.ns2.table1, there's a pretty good reason NOT to support that, namely that this breaks

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

On Mon, Jul 11, 2011 at 12:01 AM, Michael Nolan htf...@gmail.com wrote: On Fri, Jul 8, 2011 at 10:27 PM, Robert Haas robertmh...@gmail.com wrote: But if that's what you want, just don't put your data in different databases in the first place.  That's what schemas are for. Sadly, DBAs don't

Re: [GENERAL] nntp not working

2010/8/18 Arturo Pérez art...@ethicist.net: Is anyone else having problems accessing the mailing lists through NNTP? Yeah, I see the occasional message coming through, but it looks like the gateway between mail and NNTP isn't working. -- http://linuxfinances.info/info/linuxdistributions.html

[GENERAL] UUID + RPM + 64 bit

@ ca.afilias.info) Christopher Browne Bother, said Pooh, Eeyore, ready two photon torpedoes and lock phasers on the Heffalump, Piglet, meet me in transporter room three -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] postgresql.key secure storage

. If you're trying to design something, intending it to be tamper-resistant, then you *have* to consider the supergurus, particularly because they might blaze a trail for others to follow... -- (reverse (concatenate 'string ofni.sailifa.ac @ enworbbc)) Christopher Browne Bother, said Pooh, Eeyore, ready

Re: [GENERAL] handle audiofiles in postgres

in the database, referencing the files' names If there's good reason to store the files in the DBMS, then do so; just make sure there's good reason for it! -- let name=cbbrowne and tld=ca.afilias.info in name ^ @ ^ tld;; Christopher Browne Bother, said Pooh, Eeyore, ready two photon

Re: [GENERAL] Pet Peeves?

On Mon, Feb 2, 2009 at 5:48 PM, Gregory Stark st...@enterprisedb.com wrote: Christopher Browne cbbro...@gmail.com writes: - Managing jobs (e.g. - pgcron) A number of people have mentioned a job scheduler. I think a job scheduler entirely inside Postgres would be a terrible idea. I think

Re: [GENERAL] Pet Peeves?

On Thu, Jan 29, 2009 at 8:16 AM, Gregory Stark st...@enterprisedb.com wrote: So, what do people say? Is Postgres perfect in your world or does it do some things which rub you the wrong way? Things I'd particularly like to have that aren't entirely on the map yet: - In place upgrade - Stored

Re: [GENERAL] number of connections

On Mon, Jan 19, 2009 at 12:10 PM, Rubén F. rfs1...@gmail.com wrote: First of all, excuse my english... I have a doubt. I am designing a program for manage CV's. This program connect with a PostgresDB. This program will be used for 5,000 persons becaus it will be used in a University. Then,

Re: [GENERAL] Slave server: FATAL: incorrect checksum in control file

On Fri, Jan 16, 2009 at 9:18 PM, Leif Jensen l...@crysberg.dk wrote: You are perfectly right, master is 32bit and slave is 64bit. I didn't even consider that that would matter when just copying the data. First I was using different versions on the two boxes, but ended up installing 8.3.5 on

Re: [GENERAL] Why would I want to use connection pooling middleware?

On Thu, Jan 15, 2009 at 10:54 AM, Kirk Strauser k...@strauser.com wrote: I have a PostgreSQL 8.3.5 server with max_connections = 400. At this moment, I have 223 open connections, including 64 from a bunch of webserver processes and about 100 from desktop machines running a particular

Re: [Slony1-general] Re: [GENERAL] Stripping out slony after / before / during pg_restore?

Richard Huxton [EMAIL PROTECTED] writes: Glyn Astill wrote: Hi people, I'm setting us up a separate staging / test server and I want to read in a pg_dump of our current origin stripping out all the slony stuff. I was thinking this could serve two purposes a) test out backups restore

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

On Feb 17, 2008 7:47 AM, Jorge Godoy [EMAIL PROTECTED] wrote: Em Friday 15 February 2008 12:36:37 Adam Rich escreveu: I would instead queue messages (or suitable information about them) in a table, and have a process outside PostgreSQL periodically poll for them Why poll when you can

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

On 2/14/08, hewei [EMAIL PROTECTED] wrote: Can send email from stored procedure in Postgres? In principle, yes, using one of the untrusted stored function languages. pl/perl, pl/sh, pl/python, and such. I wouldn't do things that way... I would instead queue messages (or suitable information

Re: [GENERAL] Different host aliases in SLONY configuration table

On Thu, Feb 14, 2008 at 12:10 PM, Timur Luchkin [EMAIL PROTECTED] wrote: I have a question regarding SLONY replication. In short, the question is: Can I have different values on every node in the sl_path table in column pa_conninfo? For example, one node has IP addresses in pa_conninfo, but

Re: [GENERAL] Maximum realistic number of database user accounts?

On Thu, Feb 14, 2008 at 5:16 PM, Greg Fausak [EMAIL PROTECTED] wrote: Howdy, I find that user accounts are very good for helping me protect application access to the database. That is, instead of giving a user 1 account, I may give hem 10, and each of those accounts are restricted in the

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

On Feb 11, 2008 8:04 AM, Ivan Sergio Borgonovo [EMAIL PROTECTED] wrote: I did manage to find an announcement about the support of pg for windows... but I wasn't able to see anything you'd have a summary of scheduled and planned EOL for various pg versions (on different platform). There have

Re: [GENERAL] [OT] advanced database design (long)

On Feb 3, 2008 11:14 PM, Alex Turner [EMAIL PROTECTED] wrote: Im not a database expert, but wouldn't create table attribute ( attribute_id int attribute text ) create table value ( value_id int value text ) create table attribute_value ( entity_id int attribute_id int

Re: [GENERAL] Continual uptime while loading data ... COPY vs INSERTS within a transaction.

On Feb 9, 2008 6:30 PM, Benjamin Arai [EMAIL PROTECTED] wrote: Hello, We are running a system which requires continual uptime while loading data. Currently one particular table receives a large number of inserts per commit (about 1 inserts). This process works well allowing both end

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

On Feb 4, 2008 3:31 PM, Tom Hart [EMAIL PROTECTED] wrote: Christopher Browne wrote: On Jan 31, 2008 4:40 PM, Guy Rouillier [EMAIL PROTECTED] wrote: Robert Treat wrote: Just so you know, I approached OReally about writing a PostgreSQL Cookbook, and they turned it down. They did

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

On Jan 31, 2008 4:40 PM, Guy Rouillier [EMAIL PROTECTED] wrote: Robert Treat wrote: Just so you know, I approached OReally about writing a PostgreSQL Cookbook, and they turned it down. They did offer me some other titles, but those don't seem to have gone anywhere. As someone else

Re: [GENERAL] Request for help with database of Kenyan election violence

On Feb 2, 2008 4:51 PM, Karl O. Pinc [EMAIL PROTECTED] wrote: Hello, The Kenya National Commission for Human Rights is investigating the violence in Kenya. This has led to an urgent request on Groklaw http://www.groklaw.net/article.php?story=20080202013451629 for assistance in setting up a

Re: [GENERAL] enabling autovacuum

On Jan 28, 2008 10:17 PM, Jeremy Harris [EMAIL PROTECTED] wrote: Hi, We're starting to run autovacuum for the first time on a system that's been running with nightly cron-driven vacuum for some time. Version: PostgreSQL 8.2.4 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2

Re: [GENERAL] PostgreSQL Storage: Sorted by Primary Key?

After takin a swig o' Arrakan spice grog, michi [EMAIL PROTECTED] belched out: Does PostgreSQL store records sorted by primary key? No. It initially stores tuples based on the order in which they are inserted. Behaviour changes later when a table has free space due to deleted tuples. -- let

Re: [GENERAL] VACUUM ANALYZE extremely slow

A long time ago, in a galaxy far, far away, Sergei Shelukhin [EMAIL PROTECTED] wrote: This is my first (and, by the love of the God, last) project w/pgsql and everything but the simplest selects is so slow I want to cry. This is especially bad with vacuum analyze - it takes several hours for

Re: [GENERAL] Lifecycle of PostgreSQL releases

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Erik Jones) transmitted: On Mar 14, 2007, at 6:17 PM, CAJ CAJ wrote: Hello, What is the lifecycle of a 8.0/8.1/8.2 releases? With 8.3 scheduled to be released in July, what will be the status of

Re: [GENERAL] Lifecycle of PostgreSQL releases

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Joshua D. Drake) transmitted: There is zero question that 8.2 is faster than 7.4 *but* if 7.4 isn't slow for them... Note, that I meant no reason for him to upgrade 7.4 *right now*. He could wait for 8.3. (I think he

Re: [GENERAL] PG Email Client

Sim Zacks [EMAIL PROTECTED] wrote: DBMail is an interesting concept, but I think the real advantage would be if there were a client that could take advantage of the power of a database backend. For example, instead of saving a copy of an email in 1 folder, the same email could be indexed to

Re: [GENERAL] Autovacuum Improvements

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Csaba Nagy) wrote: On Mon, 2007-01-08 at 22:29, Chris Browne wrote: [snip] Based on the three policies I've seen, it could make sense to assign worker policies: 1. You have a worker that moves its way through the queue in some

Re: [GENERAL] Slony across platforms

Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Scott Marlowe) wrote: On Fri, 2007-01-05 at 15:54, Raymond O'Donnell wrote: Hi all, Would there be any problem with using Slony-I to replicate from a Windows server to Linux? Has anyone done this? It otta work... Also, is

Re: [GENERAL] Autovacuum Improvements

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Alvaro Herrera) wrote: Christopher Browne wrote: Seems to me that you could get ~80% of the way by having the simplest 2 queue implementation, where tables with size some threshold get thrown at the little table queue

Re: [GENERAL] Autovacuum Improvements

After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Csaba Nagy) belched out: On Thu, 2006-12-21 at 18:41, Alvaro Herrera wrote: From all the discussion here I think the most benefit would result from a means to assign tables to different categories, and set up separate autovacuum

Re: [GENERAL] Clustering Load Balancing Replication

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: Suggest you download my little application and read the documentation, you'll see its very different, maybe even interesting. Maybe they should change that to Postgres DOES HAVE a free multi-master replication system :)

Re: [GENERAL] Second attempt, roll your own autovacuum

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Tom Lane) transmitted: Glen Parker [EMAIL PROTECTED] writes: I am still trying to roll my own auto vacuum thingy. Um, is this purely for hack value? What is it that you find inadequate about regular autovacuum? It is

Re: [GENERAL] VACUUM and transactions in different databases

Oops! [EMAIL PROTECTED] (Cornelia Boenigk) was seen spray-painting on a wall: Hi all If I have a running transaction in database1 and try to vacuum database2 but the dead tuples in database2 cannot be removed. INFO: vacuuming public.dummy1 INFO: dummy1: found 0 removable, 14

Re: [GENERAL] Database Mirroring Solution

[EMAIL PROTECTED] (Gideon) wrote: Thanks for the quick reply. We basicaly need to run a database servers in 2 different towns. Now there will be update's and selects and both need to be in sync with each other. Aswell as if / when database in town 1 goes down ... we need to be able to switch

Re: [GENERAL] Does PostgreSQL support multi-instancing?

After a long battle with technology, Bill [EMAIL PROTECTED], an earthling, wrote: Is is possible to have two different versions of PostgreSQL running on the same computer at the same time? Certainly. You need separate binaries, separate data directories, separate port configuration. If

Re: [GENERAL] per-row security

[EMAIL PROTECTED] (Andrew Sullivan) wrote: On Mon, Nov 06, 2006 at 01:40:18PM -0800, Marc Munro wrote: You will of course be replicating the underlying tables and not the views, so your replication user will have to have full access to the unsecured data. This is natural and should not be a

Re: [GENERAL] time value '24:00:00'

On 11/1/06, Uwe C. Schroeder [EMAIL PROTECTED] wrote: why don't you just use '00:00:00'::time and avoid the issue? IMHO there shouldn't even be a 24:00:00, because that would imply that there is a 24:00:01 - which there is not. It should go from 23:59 to 00:00 But then, I didn't write the

Re: [GENERAL] CUBE, ROLLUP, GROUPING SETS?

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Nicolas Barbier) would write: 2006/10/28, Robert Treat [EMAIL PROTECTED]: On Tuesday 10 October 2006 15:19, stig erikson wrote: Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in future PostgreSQL versions? I

Re: [GENERAL] Wordpress PostgreSQL ...

[EMAIL PROTECTED] (Joshua D. Drake) wrote: Marc G. Fournier wrote: Does anyone know of any work being done to get wordpress ported to PostgreSQL? My search on the web finds emails from March of this year concerning some ppl more or less looking into it, but I can't find anything that

Re: [GENERAL] more anti-postgresql FUD

After a long battle with technology, [EMAIL PROTECTED] (Jim C. Nasby), an earthling, wrote: But you can actually write good code that will run on multiple databases if you're willing to write the tools to allow you to do it. There's an argument out there that we don't actually have relational

Re: [GENERAL] postgresql rising

After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Brad Nicholson) belched out: On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote: On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote: For a high level corp manager all they ever hear about is MS SQL Server, Oracle

Re: [GENERAL] creating table while slony-I replication is running

In the last exciting episode, [EMAIL PROTECTED] wrote: Hi, I am trying to find out how to CREATE a table while Slony-I replication is running (meaning without stopping Slony-I replication adding/creating new table into replication) I think you have some extra characters in the script.

Re: [GENERAL] Data Warehouse

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Jaime Casanova) transmitted: Anyone here knows if exists a data warehouse software that uses postgresql? if it is open source that will be a plus... There tends to be 3 parts to this... 1. Data storage The RDBMS of

Re: [GENERAL] Postrgesql and Mysql in the same server Linux (Fedora core 5)

In an attempt to throw the authorities off his trail, Toffy [EMAIL PROTECTED] transmitted: Hi, as i put Postrgesql and Mysql in the same server Linux (Fedora core 5), is it possible that this configuration may cause a strong deceleration of all system performace? If either or both are

Re: [GENERAL] Cutting the Gborg throat

In the last exciting episode, [EMAIL PROTECTED] (Joshua D. Drake) wrote: Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have been looking at the migration of Gborg lately. It looks like the only two active projects on that site are Slony, and pljava. Libpqxx has

Re: [GENERAL] SQL:2003 Window Functions for postgresql 8.3?

Clinging to sanity, [EMAIL PROTECTED] (Tom Lane) mumbled into her beard: Martijn van Oosterhout kleptog@svana.org writes: The main thing I want to use them for is for cumulative output. ... With window functions you define for each row a window which is from the beginning of the table to that

Re: [GENERAL] trigger help

On 8/22/06, marcelo Cortez [EMAIL PROTECTED] wrote: I think my trigger need transaction ,but the pgsql compiler refuse to compile 'begin .. commit ' sequence I use the perform , to do the works Stored functions already execute inside the context of some already-running transaction. You don't

Re: [GENERAL] Restarting Slony crashes Postgresql?

In an attempt to throw the authorities off his trail, Nico [EMAIL PROTECTED] transmitted: Hi group, I'm using Slony-I 1.1.5 with Postgresql 8.1.4 on 3 DB server (OS = debian sarge). I set a replication from a database on server A (master) to 2 servers B and C (slaves). Note that the

Re: [GENERAL] database file encryption

Martha Stewart called it a Good Thing when kleptog@svana.org (Martijn van Oosterhout) wrote: On Fri, Aug 11, 2006 at 09:47:49AM +0200, Stefano B. wrote: Hi all, I have just discovered that in postgres database file the data are not encrypted. If I open with a text editor these files I can

Re: [GENERAL] Best Procedural Language?

Martha Stewart called it a Good Thing when Carlo Stonebanks [EMAIL PROTECTED] wrote: I am interested in finding out a non-religious answer to which procedural language has the richest and most robust implementation for Postgres. C is at the bottom of my list because of how much damage runaway

Re: [GENERAL] Performance of the listen command

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Flemming Frandsen) wrote: I just looked at the pg_listener table: zepong- \d+ pg_listener Table pg_catalog.pg_listener Column| Type | Modifiers | Description

Re: [GENERAL] Performance of the listen command

The world rejoiced as [EMAIL PROTECTED] (Tom Lane) wrote: Flemming Frandsen [EMAIL PROTECTED] writes: I just looked at the pg_listener table: ... and noticed the complete lack of indexen, surely this must be a bug? No, that was intentional. It's been a long time but I think the argument was

Re: [GENERAL] Aim of --enable-thread-safety ?

[EMAIL PROTECTED] (DANTE Alexandra) wrote: I wonder if this compilation option is really taken into account as PostgreSQL is not multi-threading but multi-processing. I have read that without this option, the libpq won't know anything about threads and may indeed have problems, but could you

Re: [GENERAL] pgsql vs mysql

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Merlin Moncure) transmitted: hm. that's all very true (and important), but I try and keep focus on the things besides basic correctness that drive the development cultural divide that seperates the two communities. pg,

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing

Ron Mayer [EMAIL PROTECTED] wrote: David Fetter wrote: the terse mathematical notation commonly used... Again, if you have a piece of software you can point to that does this thing, please do so. I seriously doubt it follows Date or Pascal religiously, but it does have a convenient and

Re: [GENERAL] Aggregate functions not allowed in WHERE clause

Quoth [EMAIL PROTECTED] (Ricardo Naranjo Faccini): I have two tables, Claims and Logs, and I need to fish in for the id of any claim who have into the logs anything into the fields invoices or payments I think the best way to do this is by mean of: SELECT claim_id FROM logs WHERE (

Re: [GENERAL] TOAST not working

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (list_man) would write: Can someone tell me if I have to 'enable' TOAST on columns to have it kick in. According to my research, numeric data types are toastable. TOAST is only used on individual columns that exceed 8K in size. The

Re: [GENERAL] TOAST not working

After a long battle with technology, [EMAIL PROTECTED] (list_man), an earthling, wrote: Hi, I wonder if anyone can help. I have a VERY wide table and rows. There are over 800 columns of type: numeric(11,2) I can create the table no problem, but when I go to fill out a full row with data,

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing the relational model

In the last exciting episode, [EMAIL PROTECTED] wrote: I'm reading, and enjoying immensely, Fabial Pascal's book Practical Issues in Database Management. Though I've just gotten started with the book, he seems to be saying that modern RDBMSs aren't as faithful to relational theory as they

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing the relational model

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Trent Shipley) wrote: On Thursday 2006-06-08 15:14, David Fetter wrote: On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote: on bag theory[1] and 3-value logic[2]. Until they come up with a testable system, or Hell

Re: [GENERAL] Best high availability solution ?

In the last exciting episode, dpage@vale-housing.co.uk (Dave Page) wrote: If I'm honest, I think your boss is going to be disappointed. You would add a *lot* of complexity to the system to make it handle failures with zero intervention, and that extra complexity is probably more likely to go

[GENERAL] Toronto PostgreSQL Gathering - June 1st

I had intended to try to organize some form of Toronto PostgreSQL 'user group'; some challenges have gotten in the way of having that be at all large scale, but it certainly makes sense to try to get local people interested in PostgreSQL together every so often. A number of groups gather at

Re: [GENERAL] Toronto PostgreSQL Gathering - June 1st

Martha Stewart called it a Good Thing when Christopher Browne [EMAIL PROTECTED] wrote: A number of groups gather at different times at Toronto's Linux Caffe; the first Thursday of the month seems an opportune time for this, and the next incidence of that is next Thursday, June 1st. And oops

Re: [GENERAL] background triggers?

The world rejoiced as [EMAIL PROTECTED] (Rafal Pietrak) wrote: On Wed, 2006-05-24 at 07:41 -0400, Kenneth Downs wrote: Why not have the INSERT go to an inbox table, a table whose only job is to receive the data for future processing. Actually, it 'sort of' works that way. Your client

Re: [GENERAL] To recover data corrupted

After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Jim C. Nasby) belched out: On Tue, May 23, 2006 at 01:03:16PM +0200, Frederic Massot wrote: Hi, We have an old waiter Postgresql 6.5.3 which regularly had problem and which crashed. 6.5?! Holy cow, you win the prize for oldest

Re: [GENERAL] GUI Interface

Also most DBAs are not hard core OSS programmers and anyone coming from a commercial system is more than likely used to running the admin tools on windows. We have a whole department of DBAs, *none* of whom have Microsoft on their desktops. Further, the Big, Important Systems that we

Re: [GENERAL] Is PostgreSQL an easy choice for a large CMS?

Oops! [EMAIL PROTECTED] (Tony Lausin) was seen spray-painting on a wall: Ahh. I see the point more clearly now. Perhaps the best strategy for me is to press on with Postgres until the project is at a profitable enough stage to merit a migration to Oracle - should Postgres become an issue. I

Re: [GENERAL] Database Selection

Centuries ago, Nostradamus foresaw when IvoD [EMAIL PROTECTED] would write: [EMAIL PROTECTED] (Scott Marlowe) writes: About the security thing. Security is a process, and you won't get it from using two different database engines. I'd argue that security is an emergent property which is

Re: [GENERAL] Database Selection

After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Robert Treat) belched out: On Tuesday 25 April 2006 01:46, IvoD wrote: My sixth sense tells me that PostgreSQL is better than MySQL, therefore for main app I prefer PostgreSQL; but I am in doubt to run only one db engine for two

Re: [GENERAL] How to have a blind-superuser

After a long battle with technology, Qingqing Zhou [EMAIL PROTECTED], an earthling, wrote: Jim C. Nasby [EMAIL PROTECTED] wrote On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote: Is it possible to have a superuser who could do CHECKPOINT, BACKUP and whatever but could not see

Re: [GENERAL] PostgreSQL and the OCFS2 filesystem

Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Ploski, Karen L) wrote: The change log for Kernel Stable Build 2.6.16 indicates that OCFS2 has been integrated into the kernel. (See http://www.kernel.org/pub/linux/kernel/v2.6/ChangeLog-2.6.16  and

Re: [GENERAL] Is a high tab_reloid worrying?

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (John Sidney-Woollett) transmitted: I just added a new table to a slony relication set. The new table seems to have a really high tab_reloid value of 94,198,669 I presume the database instance has been around for a while?

Re: [GENERAL] Is difference between PostgreSQL and mySQL licences for client application minor only

In the last exciting episode, Andrus [EMAIL PROTECTED] wrote: I created closed source Postgres/mySQL client application. When using PostgreSQL as backend I can include Postgres server binary code in my application distro. When using mySQL my application setup can load mySQL server

Re: [GENERAL] [Slightly OT] data model books/resources?

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Robert Treat) transmitted: On Thursday 30 March 2006 03:03, Aaron Glenn wrote: Anyone care to share the great books, articles, manifestos, notes, leaflets, etc on data modelling they've come across? Ideally I'd like to

Re: [GENERAL] [Slightly OT] data model books/resources?

In the last exciting episode, [EMAIL PROTECTED] (Aaron Glenn) wrote: Anyone care to share the great books, articles, manifestos, notes, leaflets, etc on data modelling they've come across? Ideally I'd like to find a great college level book on data models, but I haven't come across one that

Re: [GENERAL] Replication web apps

In the last exciting episode, [EMAIL PROTECTED] (Leonardo Francalanci) wrote: In other words: how can asynchronous replication be used in an application??? Yes, this is an issue. Asynchronous replication is NOT suitable in cases where you point applications that need forcibly up-to-date

Re: [GENERAL] Can the PostgreSQL store the Multimedia files

In the last exciting episode, [EMAIL PROTECTED] wrote: hallo, I am working with a group on a Gradute project and we use the PostgreSQL database for build an information system for a school. we have a small question: - Can the PostgreSQL store the Multimedia files ( Images ,video

Re: [GENERAL] Postgres does not accept socket connections

After a long battle with technology, [EMAIL PROTECTED], an earthling, wrote: I need the PostgreSQL server on the machine which contains the database to accept socket connections. Any help in this regard will be appreciated. Look for the configuration file postgresql.conf. It is doubtless

Re: [GENERAL] Default Access Exclusive Lock on Update?

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write: For anyone that is interested, my problem was solved on another list. Turns out the TRUNCATE command that I run at the beginning of the SP creates and holds an access exclusive lock on the table for the entire duration of

Re: [GENERAL] Solaris 10 ZFS Postgresql request for comments

After a long battle with technology, [EMAIL PROTECTED] (Reid Thompson), an earthling, wrote: Hi all, I'm querying for feedback/comments. Wondering what the list thinks of the following. Assume this is to provide a production database for a small company or a department. Production hours

Re: [GENERAL] Temporal Databases, offtopic - relative updates

In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] ([EMAIL PROTECTED]) transmitted: I have a somehow related question to this topic: is it possible to know (in postgresql) if an update on a column is absolute (set col = 3) or relative to it's previous value (set col = col

Re: [GENERAL] Postgre capability

[EMAIL PROTECTED] (Farhad) wrote: I'm looking for any experience on runing an ERP software (Oracle application, SAP, PeopleSoft, ...) on top of a postgre data base. You won't find it, for two reasons: 1. There's no such thing as postgre The proper name is PostgreSQL, though people are often

Re: [GENERAL] Temporal Databases

A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jim C. Nasby) wrote: On Fri, Feb 24, 2006 at 11:56:58AM -0500, Brad Nicholson wrote: Simon Riggs wrote: A much easier way is to start a serialized transaction every 10 minutes and leave the transaction idle-in-transaction. If

Re: [GENERAL] psql is very slow

Oops! [EMAIL PROTECTED] (Michal Merta) was seen spray-painting on a wall: I have a psql 7.3.4, apache 2.0.40, perl  v5.8.0. Database is pretty big, (dump is about 100Megs). But all the operations are very, very slow. Is any possibility to make postgresql more quick? (don't tell me to cut

Re: [GENERAL] phantom backends

Oops! [EMAIL PROTECTED] (Ed L.) was seen spray-painting on a wall: I have a bunch of 7.4.6 backend processes that show up via pg_stat_get_db_numbackends(), pg_stat_get_backend_idset(), etc, but do not show up in ps. Any clues? Possibly your statistics collector got overrun, and the last

Re: [GENERAL] Requesting LinuxWorld East staffers

Quoth [EMAIL PROTECTED]: Joshua. We need booth staffers for Linux World east. Please step up. Is that for Command Prompt or postgreSQL? Both, probably. I'm confused about Linux World east, though. I googled it and it looks like it was in Boston last month. It could be one of two

Re: [GENERAL] Backup file extension

After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Michael Schmidt) belched out: I am writing a client GUI application and am adding backup/restore features.  I noticed that different backup file extensions are used for PostgreSQL - pgAdmin uses .backup (possible problem because it

Re: [GENERAL] Performance Tuning

The world rejoiced as [EMAIL PROTECTED] (Darryl W. DeLao Jr.) wrote: Running ver 7.3.10 in RHEL 3.0 ES.  If I change shared buffers, dont i have to change max connections as well?  If you have enough connections, then that seems unnecessary. The *opposite* would be true; if you change max

Re: [GENERAL] EnterpriseDB

[EMAIL PROTECTED] (Benjamin Arai) wrote: Is the PL support in EnterpriseDB worth the money?  Are there any specific benefits that I should specifically be aware of? I dunno; this is a PostgreSQL list, and many (most?) of us have never used EnterpriseDB. The people that can answer your *second*

Re: [GENERAL] How do I use the backend APIs

A long time ago, in a galaxy far, far away, Chad [EMAIL PROTECTED] wrote: In a word: The kind of problems people use Berkeley DB for. People use BDB for more fine grained cursor access to BTrees. Stuff you CANNOT do with SQL. There is a market for this. See their website. I'd like something

Re: [GENERAL] A question about Vacuum analyze

Quoth [EMAIL PROTECTED] (Emi Lu): no. the suggestion was that a VACUUM is not needed, but that an ANALYZE might be. Thank you gnari for your answer. But I am a bit confused about not running vacuum but only analyze. Can I seperate these two operations? I guess vacuum analyze do both vacuum

Re: [GENERAL] Oracle tried to buy MySQL

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (John Zubac) would write: Isn't this article false in stating that Ingres is tring to build a high end open source database package. Isn't postgres based on Ingres if I'm correct in my history lesson. And postgres IS a high end open

  1   2   3   >