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
>> mailto:vik.fear...@2ndquadrant.com>> wrote:
>>
>> On 10/18/2017 05:57 PM, Melvin Davidson wrote:
>> >
>> > I support the policy of using cautio
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 are what i've seen it called
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 involved in any future ro
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 subsumes more
> and more of th
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 employee in employees:
>
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.
On Mon, Jul 11, 2011 at 10:12 AM, Florian Pflug 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
On Mon, Jul 11, 2011 at 12:01 AM, Michael Nolan wrote:
>
>
> On Fri, Jul 8, 2011 at 10:27 PM, Robert Haas 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 always have the ability to
2010/8/18 Arturo Pérez :
> 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
--
Sent via pgsql-g
ut = ("cbbrowne" "@" "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-g
it publicly enough to make it
accessible to rather more than the "1% of supergurus."
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..
, perhaps with cryptic names
(hashes?)
- Storing the metadata about the files 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
On Mon, Feb 2, 2009 at 5:48 PM, Gregory Stark wrote:
> Christopher Browne 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 it
On Thu, Jan 29, 2009 at 8:16 AM, Gregory Stark 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 procedures that can man
On Mon, Jan 19, 2009 at 12:10 PM, Rubén F. 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, ¿how many activ
On Fri, Jan 16, 2009 at 9:18 PM, Leif Jensen 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
> both of t
On Thu, Jan 15, 2009 at 10:54 AM, Kirk Strauser 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
> application. The rest
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
>
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 whe
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 informati
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
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_conn
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 h
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
>
On Feb 3, 2008 11:14 PM, Alex Turner <[EMAIL PROTECTED]> wrote:
> I"m 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
> a
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 app
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 som
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 settin
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
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
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
>
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 thi
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 stat
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 inde
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
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...
>> Al
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
>> thre
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
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
>> > au
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?
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
[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 s
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
[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
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 s
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 v
[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
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 relation
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,
>>
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.
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
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
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.
Clinging to sanity, [EMAIL PROTECTED] (Tom Lane) mumbled into her beard:
> Martijn van Oosterhout 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 row an
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'
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 tha
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
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
> damag
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
> arg
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
> --+-+---+---
[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 yo
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. p
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 conv
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
> WHER
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
> wi
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 o
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,
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 th
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
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 Thur
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 di
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.
>
>> Y
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
> 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 admini
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.
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
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 prop
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 bu
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
> http://www.linux-watch.c
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?
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
>
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
>
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 th
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 infor
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
> ,audio...
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 ho
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 o
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
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 =
[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 oft
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-transa
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
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
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 la
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
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 bo
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 some
[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 *seco
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
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Neil Conway)
wrote:
> On Fri, 2006-02-17 at 11:34 +0800, Qingqing Zhou wrote:
>> AFAIK there is no such API for this purpose. The reason is that to access
>> BTree, you have to setup complex enough environment to enable so. For
>> exam
1 - 100 of 310 matches
Mail list logo
